msgbartop
List for SAS fans and programmer
msgbarbottom

14 3月 11 SAS资讯 from 新浪微博-2011-03-14


微博是最近流行的一种信息发布方式,具有实时性和多项性。大家可以在网上关注,也可以查看我的关注对象, 里面大部分都是与SAS相关的人或组织如有SAS中国公司,还有很多正在SAS公司工作的员工。通过关注新浪微博上的这些ID,就可以得到很多最新的SAS公司新闻和一些行业消息。因此本站不定期的收集一段时间内微博上的SAS资讯,整理后发布。
下面是从2011年初到2011年3月4日发布的信息,我从中挑选部分精华信息,供大家了解。
    (更多…)

原创文章: ”SAS资讯 from 新浪微博-2011-03-14“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/102


05 1月 11 读者来信一 请教一些关于SAS学习及工作前景的一些问题


今天收到一个新鲜SASor的来信,我也做了一个回复,我觉得他是很有准备的一个人,对QA稍作修改,问和答见下面,希望给有同样问题的新手有个参考。

from: www.saslist.net
Q:
sxlion **:您好!冒昧来信,恳请见谅,个人现在处于SAS学习的初级阶段,关于SAS学习及行业应用有一些问题,想向前辈请教一下,十分感谢您能抽空阅读一下我邮件,谢谢!

首先,简单的介绍下我的相关信息 :-):
我叫***,现在就读于**大学,是统计系2008级的学生。2009年底接触SAS,2010后半年投入SAS的学习中,开始关注SAS方面的一些论坛、博客及工作信息。2010年10月至12月学习完成了SAS Base和Adv的考试,算是刚刚有一点入门吧。英语方面应该还算过得去吧,口语交流有待提高。计算机其他软件方面的能力比较欠缺,如C++等。

我近期初步的规划是:大四毕业的时候,能以SAS为工具技术,找到一份与统计相关的工作。

下面有几点希望前辈能给予一些指导与建议:

1.关于SAS工作及前景
个人之前关注过一些SAS相关的招聘信息,然而由于眼界有限,对从事SAS相关工作(尤其对本科毕业生来说)仍是不太明了,希望前辈能就您所了解的介绍下SAS在各个行业的应用情况。若希望将来有比较好的发展前途,有哪些方向?需要具备怎的素质?以及学位有怎样的重要性?(好像很多高级职位都需要硕士及以上学历)
2.关于SAS应用能力
从接触SAS到现在,总是感觉自己SAS知识掌握的不牢,面对一些实际问题时总是难以很好的解决,考完SAS初高级后,仍感觉自己SAS的编程及应用能力很欠缺。若是希望能全面(或者某一方面)提高自己的SAS应用能力,不知道前辈您有没有一些建议?另外也希望前辈能介绍下您SAS学习过程中的经验,以及重要的阶段和体会。
祝,新年快乐!工作顺利!

—————–  from: www.saslist.net     ————————
A:
hi, ***, 谢谢信任。 你是一个有准备的人,比我们这些老的好多了 – : )。

必须提前说明的是,我对这些情况了解有限,不过我仍然愿意倚老卖老的按你的问题做些回答。
你的目标是找一份与SAS相关的工作, 在我看来,SAS方面的工作前景不错,特别是对于本科生来说机会会更多。我觉得你的基础和专业也很好,不过为了得到更好的offer,提一些小小的建议把,其实这也是一些大公司的硬性要求。
  1. 英语口语要好。 我感觉90后的英语感觉都不错,不过还是建议花的钱去学点商业英语,然后把你自己统计专业英语词汇熟悉下,就差不多了。这个在中国很重要,因为给SAS工作机会多地方在上海,北京和广州,用你的公司多多少少和外国有点关系。
  2. SAS基本编程能力要好。 你有base和adv认证,一般HR会给你机会面试的。面试你的未来上司会考察SAS编程能力,这个对新手,会逃不到考察项目。 建议去论坛回答问题,留下自己的代码,就算写的不是很好。另外和别人的代码多比较下,会学到很多的。
  3. 专业。你应该属于很对口,基本上有关SAS的工作,HR会直接考虑你的,如果有一份很好的专业成绩表,HR会更喜欢。
  4. 业务上   你自己必须知道,光大学毕业是没有业务经验,毕业之前找个公司实习吧,这个更实在,你的上司对这个很看重。
如果你上面都顺利的话,也就是搞定了HR和你的未来上司,你这份工作就差不多了,也是你尽自己的能力做得非常好了。剩下的就看老大拍板了,上不上差不多和你关系不大了,这个运气成分很大。
哈哈,上面的问题很严肃,这个没办法,实际中就这样,下面调侃些轻松的吧。
  1. 提供SAS工作的公司挺多的,就业面挺广,目前需求也旺盛的。有钱有风险的行业,像金融、银行、证券、保险、投行之类的,要SASor的多;稳定工资不错的,像CRO,药厂等等也是招SASor的大户;另外国内现在很多外包型的公司,接大公司的业务,直接外派你去做项目,这样的公司还不少,大中小的公司都有,不少SASor都是从这样的公司入行的。
  2. SAS工作前景总体感觉不错,但是SAS学起来很枯燥,学习周期挺长的,也挺难学的,需要涉及的东西很多,编程能力,统计知识和业务敏感三个方面,能做到oloolo所说的三合一的业内顶尖统计人才不多。很多做SAS工作的人,只是个程序员(又称码农),而不是一个SAS程序员。当然如果规划好,加上几年的业务积累,速度成为顶级的业内高手也是可能的。
  3. 其他语言或工具软件,像C,C++,java之类的流行语言,刚开始不用学太好,基本了解就行了,实际工作中在根据需要用。倒是像如SAS同类型的软件,比如SPSS,R,matlab需要了解一点点,不过学好SAS的话,这几个难度不大。最近挖掘挺热的,SAS/em,还有IBM的clementine神马的,倒是需要练练手。
  4. 谈谈SAS认证,这个表示你不讨厌SAS,系统的学习过SAS编程的一些知识,离实际比较远,是个有胜于无的东西,受HR偏爱。实际能力还需多练手才能提高。【还有学位证什么的,只要人家不是招你去做研究的(这个非常之少的),学位真的是浮云。工作以后有钱有闲的,读个MBA会划算很多的。注:后面详谈,以保客观评价】
  5. 谈谈学位,学位一张纸,本身是浮云。你读了博士或硕士,表示你有时间和机会去接触前沿知识,这个很开阔眼界,至少不会陷入井底之见。如果不浪费时间,还会有项目积累和研究经验,会为简历添光不少。硕博学习经历和三年或以上的工作经验,两者怎么取? 就算是问过来人,你得到总是会得到两种或者三种看法,这个是社会问题,读者自清。老话重听不无道理:“师傅领进门,修行在各人”。顺便提一下,个别职位会严格要求学历的,不过大部分公司职位往往会前面提学历要求,后面会加上,“如果能力非常强的话,前面可以忽略”之类的。这里面有学习经历和经验之间的PK潜台词就是对学位问题最好的解答。
  6. 提高SAS应用能力的话,自学或者公司锻炼都可以,个人造化。现在网上资源非常多,前人给的建议也非常实在,提不提高看个人意愿了。

OK,差不多,你需要的我知道的都在上面。

最后给你来个私人建议吧,参杂大量我个人主观意愿。
  1. 尽可能回答mysas.net 或 sasor.feoh.net论坛上的所有问题。
  2. 开始写博客吧,把你写过的程序,稍微总结一下,并加以讨论。慢慢积累,以后招聘你的上司,一看你写的东西,就知道你的SAS水平了。
  3. 当你感觉你准备差不多的时候,要找实习或者工作了,去mysas圈子发短信给shiyiming。国内的一些公司时常会在mysas或者我的博客上有消息的。51或者招聘什么的网站,广告太多,圈子里面工作信息很多,感谢shiyiming吧。
by sxlion
ps:顺便广告下,想在SAS博客列表 http://saslist.com的开博客的TX,可以来邮件告之。
ps2:2010年1月7日 增加了对学位的看法,尽量保证客观公正的评价。

原创文章: ”读者来信一 请教一些关于SAS学习及工作前景的一些问题“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/100


22 11月 10 最全的SAS9.2函数列表二


第二类 函数  windows环境下函数;

CALL SOUND Generates a sound with a specific frequency and duration.
MCIPISLP Causes SAS to wait for a piece of multimedia equipment to become active.
MCIPISTR Submits an MCI string command to a piece of multimedia equipment.
MODULE Calls a specific routine or module that resides in an external dynamic link library (DLL).
WAKEUP Specifies the time a SAS DATA step begins execution.

第三类,OpenVMS虚拟内存环境下函数;

ASCEBC Converts an input character string from ASCII to EBCDIC.
CALL FINDEND Releases resources that are associated with a directory search.
DELETE Deletes a file.
EBCASC Converts an input character string from EBCDIC to ASCII.
FILEATTR Returns the attribute information for a specified file.
FINDFILE Searches a directory for a file.
GETDVI Returns a specified item of information from a device.
GETJPI Retrieves job-process informations.
GETLOG Returns information about a DCL logical name.
GETMSG Translates an OpenVMS error code into text.
GETQUOTA Retrieves disk quota information.
GETSYM Returns the value of a DCL symbol.
GETTERM Returns the characteristics of your terminal device.
MODULE Calls a specific routine or module that resides in a sharable image.
NODENAME Returlns the name of the current node.
PUTLOG Creates an OpenVMS logical-name in your process-level logical name table.
PUTSYM Creates a DCL symbol in the parent SAS process.
SETTERM Modifies a characteristic of your terminal device.
TERMIN Allows simple input from SYS$INPUT.
TERMOUT Allows simple output to SYS$OUTPUT.
TTCLOSE Closes a channel that was previously assigned by TTOPEN.
TTCONTRL Modifies the characteristics of a channel that was previously assigned by TTOPEN.
TTOPEN Assigns an I/O channel to a terminal.
TTREAD Reads characters from the channel assigned by TTOPEN.
TTWRITE Writes characters to the channel assigned by TTOPEN.
VMS Spawns a subprocess and executes a DCL command.

第四类,z/OS操作环境下函数,

CALL TSO Issues a TSO command or invokes a CLIST or a REXX exec during a SAS session.
CALL WTO Sends a message to the system console.
TSO Issues a TSO command or invokes a CLIST or a REXX exec during a SAS session.
WTO Sends a message to the system console.

第五类,宏语言函数;

%BQUOTE, %NRBQUOTE Masks special characters and mnemonic operators in a resolved value at macro execution.
%EVAL Evaluates arithmetic and logical expressions using integer arithmetic.
%INDEX Returns the position of the first character of a string.
%LENGTH Returns the length of a string.
%QUOTE, %NRQUOTE Masks special characters and mnemonic operators in a resolved value at macro execution.
%SCAN, %QSCAN Searches for a word that is specified by its position in a string.
%STR, %NRSTR Masks special characters and mnemonic operators in constant text at macro compilation.
%SUBSTR, %QSUBSTR Produces a substring of a character string.
%SUPERQ Masks all special characters and mnemonic operators at macro execution but prevents further resolution of the value.
%SYMEXIST Returns an indication of the existence of a macro variable.
%SYMGLOBL Returns an indication as to whether a macro variable is global in scope.
%SYMLOCAL Returns an indication as to whether a macro variable is local in scope,
%SYSEVALF Evaluates arithmetic and logical expressions using floating-point arithmetic.
%SYSFUNC, %QSYSFUNC Executes SAS functions or user-written functions.
%SYSGET Returns the value of the specified operating environment variable.
%SYSPROD Reports whether a SAS software product is licenses at the site.
%UNQUOTE During macro execution, unmasks all special characters and mnemonic operators for a value.
%UPCASE, %QUPCASE Converts values to uppercase.

第六类,多国语言函数,

EUROCURR Converts one European currency to another.
GETPXLANGUAGE Returns the current two letter language code.
GETPXLOCALE Returns the POSIX locale value for a SAS locale.
GETPXREGION Returns the current two letter region code.
KCOMPARE Returns the result of a comparison of character expressions.
KCOMPRESS Removes specified characters from a character expression.
KCOUNT Returns the number of double-byte characters in an expression.
KCVT Converts data from one type of encoding data toanother encoding data.
KINDEX Searches a character expression for a string of characters.
KINDEXC Searches a character expression for specified characters.
KLEFT Left-aligns a character expression by removing unnecessary leading DBCS blanks and SO/SI.
KLENGTH Returns the length of an argument.
KLOWCASE Converts all letters in an argument to lowercase.
KREVERSE Reverses a character expression.
KRIGHT Right-aligns a character expression by trimming trailing DBCS blanks and SO/SI.
KSCAN Selects a specified word from a character expression.
KSTRCAT Concatenates two or more character expressions.
KSUBSTR Extracts a substring from an argument.
KSUBSTRB Extracts a substring from an argument according to the byte position of the substring in the argument.
KTRANSLATE Replaces specific characters in a character expression.
KTRIM Removes trailing DBCS blanks and SO/SI from character expressions.
KTRUNCATE Truncates a numeric value to a specified length.
KUPCASE Converts all single-byte letters in an argument to uppercase.
KUPDATE Inserts, deletes, and replaces character value contents.
KUPDATEB Inserts, deletes, and replaces the contents of the character value according to the byte position of the character value in the argument.
KVERIFY Returns the position of the first character that is unique to an expression.
NLDATE Converts the SAS date value to the date value of the specified locale by using the date format descriptors.
NLDATM Converts the SAS datetime value to the time value of the specified locale by using the datetime- format descriptors.
NLTIME Converts the SAS time or the datetime value to the time value of the specified locale by using the NLTIME descriptors.
SORTKEY Creates a linguistic sort key.
TRANTAB Transcodes data by using the specified translation table.
VARTRANSCODE Returns the transcode attribute of a SAS data set variable.
VTRANSCODE Returns a value that indicates whether transcoding is enabled for the specified character variable.
VTRANSCODEX Returns a value that indicates whether transcoding is enabled for the specified argument.
UNICODELEN Specifies the length of the character unit for the Unicode data.
UNICODEWIDTH Specifies the length of a display unit for the Unicode data.

第七类,其他函数  以下是其他函数的不完全情况:

1,有模块有自己的专用函数,如IML模块里面的函数。

2,现在模块中出现,如果用得很多的话,就变成了常规函数,如有些函数是从其他版本中其他模块转过来的,如SAS/ETS的INTCINDEX,INTCYCLE等等; SAS High-Performance Forecasting的HOLIDAY和NWKDOM函数等等就是这样。

3,还有一类函数是SAS文档中没有记录的,比如说PROC SQL语句中的 MONOTONIC( ) 函数,但是可以使用的,半官方的解释就是不成熟,处于试用中的函数,这种函数有些地方确实能起到惊艳的作用,但需要小心使用,多测试,防止意外发生。

4,有些函数文档里一些情况也没叙述完全,可能在调试中。比如说函数indexw(),具体见说明见mysas圈

5,也许还有其他的情况,待考。

另附SAS9.2中新增和变动的函数列表(中文):
以下为新增的函数和 CALL 例程:
ALLCOMB
以最小更改顺序一次从 n 个变量中任选 k 个值时生成的所有组合。
ALLPERM
以最小更改顺序生成若干变量的值的所有排列。
ARCOSH
返回反双曲余弦。
ARSINH
返回反双曲正弦。
ARTANH
返回反双曲正切。
CALL ALLCOMB
以最小更改顺序一次从 n 个变量中任选 k 个值时生成的所有组合。
CALL ALLCOMBI
以最小更改顺序一次从 n 个对象中任选 k 个指数时生成的所有组合。
CALL GRAYCODE
以最小更改顺序生成 n 个项的所有子集。
CALL ISO8601_CONVERT
将 ISO 8601 时间间隔转换为日期时间值和持续时间值,或将日期时间值和持续时间值转换为 ISO 8601 时间间隔。
CALL LEXCOMB
以字典顺序一次从 n 个变量中任选 k 个非缺失值时生成的所有非重复组合。
CALL LEXCOMBI
以字典顺序一次从 n 个对象中任选 k 个指数时生成的所有组合。
CALL LEXPERK
以字典顺序一次从 n 个变量中任选 k 个非缺失值时生成的所有非重复排列。
CALL LEXPERM
以字典顺序生成若干变量的非缺失值的所有非重复排列。
CALL SORTC
对字符参数的值进行排序。
CALL SORTN
对数值参数的值进行排序。
CATQ
使用分隔符分隔各个项,并将含该分隔符的字符串用引号引起来,以此连接字符或数值。
CHAR
从字符串的指定位置返回单个字符。
CMISS
统计缺失参数的数量。
COUNTW
统计字符表达式中的字词数。
DIVIDE
返回用于处理 ODS 输出的特殊缺失值的除法结果。
ENVLEN
返回环境变量的长度。
EUCLID
返回非缺失参数的欧氏范数。
FINANCE
执行财务计算,如折旧、到期时间、应计利息、净现值、定期储蓄和内部收益率。
FINDW
在字符串中搜索单词。
FIRST
返回字符串的第一个字符。
GCD
返回一个或多个整数的最大公约数。
GEODIST
返回两个纬度和经度坐标之间的大地距。
GRAYCODE
以最小更改顺序生成 n 个项的所有子集。
INTFIT
返回两个日期之间的时间间隔。
INTGET
返回基于三个日期值或日期时间值的时间间隔。
INTSHIFT
返回与基时间间隔相对应的移位时间间隔。
INTTEST
若时间间隔有效,返回 1;若时间间隔无效,则返回 0。
LCM
返回能被一组数中的每个数整除的最小倍数。
LCOMB
计算 COMB 函数的对数,即一次从 n 个对象中任选 r 个的组合数的对数。
LEXCOMB
以字典顺序一次从 n 个变量中任选 k 个非缺失值时生成的所有非重复组合。
LEXCOMBI
以字典顺序一次从 n 个对象中任选 k 个指数时生成的所有组合。
LEXPERK
以字典顺序一次从 n 个变量中任选 k 个非缺失值时生成的所有非重复排列。
LEXPERM
以字典顺序生成若干变量的非缺失值的所有非重复排列。
LFACT
计算 FACT(阶乘)函数的对数。
LOG1PX
返回 1 加该参数的对数。
LPERM
计算 PERM 函数的对数,即从 n 个对象中任选 r 个元素的排列数的对数。
LPNORM
返回第二个参数和随后的非缺失参数的 Lp 范数。
MD5
返回指定的字符串的消息摘要的结果。
MSPLINT
返回保单调插值样条的纵坐标。
RENAME
重命名 SAS 逻辑库的成员、外部文件或目录。
SUMABS
返回非缺失参数的绝对值的总和。
TRANSTRN
若一个字符串中的某个子串的值大于零,则在该字符串中替换找到的所有该子串。
WHICHC
搜索与第一个参数相等的字符值,并返回第一个匹配值的索引。
WHICHN
搜索与第一个参数相等的数值,并返回第一个匹配值的索引。
ZIPCITYDISTANCE
返回两个邮政编码位置之间的大地距。
改进了以下函数中的参数说明:
DOPEN
打开目录,并返回一个目录标识符值。
EXIST
验证 SAS 逻辑库成员是否存在。
FOPEN
打开外部文件并返回一个文件标识符值。
FEXIST
验证与文件引用名相关的外部文件是否存在。
FILENAME
为外部文件、目录或输出设备分配或取消分配文件引用名。
FILEREF
验证是否已将文件引用名分配给当前 SAS 会话。
LIBNAME
为 SAS 逻辑库分配或取消分配逻辑库引用名。
LIBREF
验证是否已分配逻辑库引用名。
MOPEN
根据目录 ID 和成员名称打开文件,并返回文件标识符或 0。
PATHNAME
返回 SAS 逻辑库或外部文件的物理名称,或返回一个空格。
以下函数以前包含在 Risk Dimensions 中,现已成为 Base SAS 的一部分:
BLACKCLPRC
根据 Black 模型计算欧式期货期权的买权价格。
BLACKPTPRC
根据 Black 模型计算欧式期货期权的卖权价格。
BLKSHCLPRT
根据 Black-Scholes 模型计算欧式期权的买权价格。
BLKSHPTPRT
根据 Black-Scholes 模型计算欧式期权的卖权价格。
GARKHCLPRC
根据 Garman-Kohlhagen 模型计算欧式股票期权的买权价格。
GARKHPTPRC
根据 Garman-Kohlhagen 模型计算欧式股票期权的卖权价格。
MARGRCLPRC
根据 Margrabe 模型计算欧式股票期权的买权价格。
MARGRPTPRC
根据 Margrabe 模型计算欧式股票期权的卖权价格。
以下函数以前包含在 SAS/ETS 中,现已成为 Base SAS 的一部分:
INTCINDEX
按给定日期、时间或日期时间值,返回周期指数。
INTCYCLE
按给定日期、时间或日期时间间隔,返回下一较高季节周期的日期、时间或日期时间间隔。
INTFMT
按给定日期、时间或日期时间间隔,返回推荐的格式。
INTINDEX
按给定日期、时间或日期时间间隔和值,返回季节指数。
INTSEAS
按给定日期、时间或日期时间间隔,返回季节周期的长度。
以下函数以前包含在 SAS High-Performance Forecasting 中,现已成为 Base SAS 的一部分:
HOLIDAY
返回指定年中指定假日的日期。
NWKDOM
返回指定年的指定月中某个星期几第 n 次出现时的日期。
以下函数已由 SAS 语言参考:字典转移到 SAS/IML 文档:
MODULEIC
调用外部例程,并返回一个字符值(仅在 IML 环境下)。
MODULEIN
调用外部例程,并返回一个数值(仅在 IML 环境下)。
CALL MODULEI
调用外部例程,但不返回任何代码(仅在 IML 环境下)。
以下函数和 CALL 例程已增强:
CALL POKE
现在可以直接将浮点数写入基于 32 位平台的内存。
CALL POKELONG
现在可以直接将浮点数写入基于 32 位平台和 64 位平台的内存。
CALL SCAN
返回字符表达式中给定单词的位置和长度。
DATDIF
已将“ACT/360”和“ACT/365”这两个值添加到 basis 参数,并在美国证券业协会出版的文档中添加了一条参考信息。
FSEP
为十六进制字符分隔符添加了一个可选参数。
INDEX
添加了说明如何处理开头空格和结尾空格的示例。
LAG
添加了关于 LAG 函数内存限制的信息。
SCAN
返回字符表达式中的第 n 个单词。
ZIPSTATE
在文档中添加了关于美国陆军邮局 (Army Post Office, APO) 和美国海军邮局 (Fleet Post Office, FPO) 的信息。
RX 函数集和 CALL 例程已从文档中删除,取而代之的是一组 PRX 函数和 CALL 例程。这些 PRX 函数和 CALL 例程在 SAS 以前的版本中已可以使用,可以提供强大的功能。
以下为已删除的 RX 函数和 CALL 例程:
RXMATCH 函数
RXPARSE 函数
RXCHANGE CALL 例程
RXFREE CALL 例程
RXSUBSTR CALL 例程
SCANQ 函数和 CALL SCANQ 例程已从文档中删除,由功能强大的 SCAN 函数和 CALL SCAN 例程取代。

以上参考文献来源主要为: SAS9.2随机帮助  美国SAS研究所  2009

原创文章: ”最全的SAS9.2函数列表二“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/98


22 11月 10 最全的SAS9.2函数列表一


SAS提供了大量的内置函数,并且在数量和内容上不断的发展改进,从版本9.2开始还提供了自定义函数功能。使用合适的函数,将会使你的工作效率加倍。2008年我在SASor论坛上贴了一个SAS9.2新增函数的列表,具体见论坛帖子;2009年我曾经在技术博客上对SAS函数做了比较深入的讨论,对SAS函数从版本6到版本9.2进行了细致的综述,详见SAS函数&CALL例程介绍与实例精选,并在SAS爱好者上海聚会分享了这一内容,当时的PPT见“SAS函数和CALL 例程的发展”。

当时所关注的函数其实仅仅集中于SAS常规函数,尽管如此,SAS9.2 的常规函数已达到499个。庞大的函数库确实给SASor们带来了非常多的方便,但是仓库式的SAS builted in帮助太杂乱,常常让人有一种“不识庐山真面目,只缘身在此山中”的感觉。有时,需要的函数找不到,找到的函数又不合适。其实SAS很体贴地不断增加高效的函数来精简你的代码和提高编程速度,可惜很多函数,SASor们并不知晓,常常看到别人使用的时候,才惊叹“原来SAS已经提供了这样的函数,我编了半天小算法”,或者“白费这么大劲,编了个宏”等等。这里按类列出SAS9.2版本的函数,供大家参考。

按不同的使用环境,SAS一共有七大类函数:

一,常规函数 ;二,windows环境下函数;三,OpenVMS虚拟内存环境下函数;四,z/OS操作环境下函数,五,宏语言函数;六,多国语言函数,七,其他函数

第一类函数常规函数最常用,数量也最多,这里依次列出所有的常规函数。

Character 字符函数


函数名称 功能
ANYALNUM Function Searches a character string for an alphanumeric character, and returns the first position at which the character is found.
ANYALPHA Function Searches a character string for an alphabetic character, and returns the first position at which the character is found.
ANYCNTRL Function Searches a character string for a control character, and returns the first position at which that character is found.
ANYDIGIT Function Searches a character string for a digit, and returns the first position at which the digit is found.
ANYFIRST Function Searches a character string for a character that is valid as the first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
ANYGRAPH Function Searches a character string for a graphical character, and returns the first position at which that character is found.
ANYLOWER Function Searches a character string for a lowercase letter, and returns the first position at which the letter is found.
ANYNAME Function Searches a character string for a character that is valid in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
ANYPRINT Function Searches a character string for a printable character, and returns the first position at which that character is found.
ANYPUNCT Function Searches a character string for a punctuation character, and returns the first position at which that character is found.
ANYSPACE Function Searches a character string for a white-space character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
ANYUPPER Function Searches a character string for an uppercase letter, and returns the first position at which the letter is found.
ANYXDIGIT Function Searches a character string for a hexadecimal character that represents a digit, and returns the first position at which that character is found.
BYTE Function Returns one character in the ASCII or the EBCDIC collating sequence.
CALL CATS Routine Removes leading and trailing blanks, and returns a concatenated character string.
CALL CATT Routine Removes trailing blanks, and returns a concatenated character string.
CALL CATX Routine Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string.
CALL COMPCOST Routine Sets the costs of operations for later use by the COMPGED function
CALL MISSING Routine Assigns missing values to the specified character or numeric variables.
CALL SCAN Routine Returns the position and length of the nth word from a character string.
CAT Function Does not remove leading or trailing blanks, and returns a concatenated character string.
CATQ Function Concatenates character or numeric values by using a delimiter to separate items and by adding quotation marks to strings that contain the delimiter.
CATS Function Removes leading and trailing blanks, and returns a concatenated character string.
CATT Function Removes trailing blanks, and returns a concatenated character string.
CATX Function Removes leading and trailing blanks, inserts delimiters, and returns a character string.
CHAR Function Returns a single character from a specified position in a character string.
CHOOSEC Function Returns a character value that represents the results of choosing from a list of arguments.
CHOOSEN Function Returns a numeric value that represents the results of choosing from a list of arguments.
COALESCEC Function Returns the first non-missing value from a list of character arguments.
COLLATE Function Returns a character string in ASCII or EBCDIC collating sequence.
COMPARE Function Returns the position of the leftmost character by which two strings differ, or returns 0 if there is no difference.
COMPBL Function Removes multiple blanks from a character string.
COMPGED Function Returns the generalized edit distance between two strings.
COMPLEV Function Returns the Levenshtein edit distance between two strings.
COMPRESS Function Returns a character string with specified characters removed from the original string.
COUNT Function Counts the number of times that a specified substring appears within a character string.
COUNTC Function Counts the number of characters in a string that appear or do not appear in a list of characters.
COUNTW Function Counts the number of words in a character string.
DEQUOTE Function Removes matching quotation marks from a character string that begins with a quotation mark, and deletes all characters to the right of the closing quotation mark.
FIND Function Searches for a specific substring of characters within a character string.
FINDC Function Searches a string for any character in a list of characters.
FINDW Function Returns the character position of a word in a string, or returns the number of the word in a string.
FIRST Function Returns the first character in a character string.
IFC Function Returns a character value based on whether an expression is true, false, or missing.
INDEX Function Searches a character expression for a string of characters, and returns the position of the string’s first character for the first occurrence of the string.
INDEXC Function Searches a character expression for any of the specified characters, and returns the position of that character.
INDEXW Function Searches a character expression for a string that is specified as a word, and returns the position of the first character in the word.
LEFT Function Left-aligns a character string.
LENGTH Function Returns the length of a non-blank character string, excluding trailing blanks, and returns 1 for a blank character string.
LENGTHC Function Returns the length of a character string, including trailing blanks.
LENGTHM Function Returns the amount of memory (in bytes) that is allocated for a character string.
LENGTHN Function Returns the length of a character string, excluding trailing blanks.
LOWCASE Function Converts all letters in an argument to lowercase.
MD5 Function Returns the result of the message digest of a specified string.
MISSING Function Returns a numeric result that indicates whether the argument contains a missing value.
NLITERAL Function Converts a character string that you specify to a SAS name literal.
NOTALNUM Function Searches a character string for a non-alphanumeric character, and returns the first position at which the character is found.
NOTALPHA Function Searches a character string for a nonalphabetic character, and returns the first position at which the character is found.
NOTCNTRL Function Searches a character string for a character that is not a control character, and returns the first position at which that character is found.
NOTDIGIT Function Searches a character string for any character that is not a digit, and returns the first position at which that character is found.
NOTFIRST Function Searches a character string for an invalid first character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
NOTGRAPH Function Searches a character string for a non-graphical character, and returns the first position at which that character is found.
NOTLOWER Function Searches a character string for a character that is not a lowercase letter, and returns the first position at which that character is found.
NOTNAME Function Searches a character string for an invalid character in a SAS variable name under VALIDVARNAME=V7, and returns the first position at which that character is found.
NOTPRINT Function Searches a character string for a nonprintable character, and returns the first position at which that character is found.
NOTPUNCT Function Searches a character string for a character that is not a punctuation character, and returns the first position at which that character is found.
NOTSPACE Function Searches a character string for a character that is not a white-space character (blank, horizontal and vertical tab, carriage return, line feed, and form feed), and returns the first position at which that character is found.
NOTUPPER Function Searches a character string for a character that is not an uppercase letter, and returns the first position at which that character is found.
NOTXDIGIT Function Searches a character string for a character that is not a hexadecimal character, and returns the first position at which that character is found.
NVALID Function Checks the validity of a character string for use as a SAS variable name.
PROPCASE Function Converts all words in an argument to proper case.
QUOTE Function Adds double quotation marks to a character value.
RANK Function Returns the position of a character in the ASCII or EBCDIC collating sequence.
REPEAT Function Returns a character value that consists of the first argument repeated n+1 times.
REVERSE Function Reverses a character string.
RIGHT Function Right aligns a character expression.
SCAN Function Returns the nth word from a character string.
SOUNDEX Function Encodes a string to facilitate searching.
SPEDIS Function Determines the likelihood of two words matching, expressed as the asymmetric spelling distance between the two words.
STRIP Function Returns a character string with all leading and trailing blanks removed.
SUBPAD Function Returns a substring that has a length you specify, using blank padding if necessary.
SUBSTR (left of =) Function Replaces character value contents.
SUBSTR (right of =) Function Extracts a substring from an argument.
SUBSTRN Function Returns a substring, allowing a result with a length of zero.
TRANSLATE Function Replaces specific characters in a character string.
TRANSTRN Function Replaces all occurrences of a substring found in a character string, allowing a zero-length replacement string.
TRANWRD Function Replaces or removes all occurrences of a substring in a character string.
TRIM Function Removes trailing blanks from a character string, and returns one blank if the string is missing.
TRIMN Function Removes trailing blanks from character expressions, and returns a string with a length of zero if the expression is missing.
UPCASE Function Converts all letters in an argument to uppercase.
VERIFY Function Returns the position of the first character in a string that is not in any of several other strings.

日期和时间函数  Date and Time

CALL IS8601_CONVERT Routine Converts an ISO 8601 interval to datetime and duration values, or converts datetime and duration values to an ISO 8601 interval.
DATDIF Function Returns the number of days between two dates.
DATE Function Returns the current date as a SAS date value.
DATEJUL Function Converts a Julian date to a SAS date value.
DATEPART Function Extracts the date from a SAS datetime value.
DATETIME Function Returns the current date and time of day as a SAS datetime value.
DAY Function Returns the day of the month from a SAS date value.
DHMS Function Returns a SAS datetime value from date, hour, minute, and second values.
HMS Function Returns a SAS time value from hour, minute, and second values.
HOLIDAY Function Returns a SAS date value of a specified holiday for a specified year.
HOUR Function Returns the hour from a SAS time or datetime value.
INTCINDEX Function Returns the cycle index when a date, time, or datetime interval and value are specified.
INTCK Function Returns the count of the number of interval boundaries between two dates, two times, or two datetime values.
INTCYCLE Function Returns the date, time, or datetime interval at the next higher seasonal cycle when a date, time, or datetime interval is specified.
INTFIT Function Returns a time interval that is aligned between two dates.
INTFMT Function Returns a recommended SAS format when a date, time, or datetime interval is specified.
INTGET Function Returns a time interval based on three date or datetime values.
INTINDEX Function Returns the seasonal index when a date, time, or datetime interval and value are specified.
INTNX Function Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value.
INTSEAS Function Returns the length of the seasonal cycle when a date, time, or datetime interval is specified.
INTSHIFT Function Returns the shift interval that corresponds to the base interval.
INTTEST Function Returns 1 if a time interval is valid, and returns 0 if a time interval is invalid.
JULDATE Function Returns the Julian date from a SAS date value.
JULDATE7 Function Returns a seven-digit Julian date from a SAS date value.
MDY Function Returns a SAS date value from month, day, and year values.
MINUTE Function Returns the minute from a SAS time or datetime value.
MONTH Function Returns the month from a SAS date value.
NWKDOM Function Returns the date for the nth occurrence of a weekday for the specified month and year.
QTR Function Returns the quarter of the year from a SAS date value.
SECOND Function Returns the second from a SAS time or datetime value.
TIME Function Returns the current time of day as a numeric SAS time value.
TIMEPART Function Extracts a time value from a SAS datetime value.
TODAY Function Returns the current date as a numeric SAS date value.
WEEK Function Returns the week-number value.
WEEKDAY Function From a SAS date value, returns an integer that corresponds to the day of the week.
YEAR Function Returns the year from a SAS date value.
YRDIF Function Returns the difference in years between two dates.
YYQ Function Returns a SAS date value from year and quarter year values.

描述统计函数 Descriptive Statistics

CMISS Function Counts the number of missing arguments.
CSS Function Returns the corrected sum of squares.
CV Function Returns the coefficient of variation.
EUCLID Function Returns the Euclidean norm of the non-missing arguments.
GEOMEAN Function Returns the geometric mean.
GEOMEANZ Function Returns the geometric mean, using zero fuzzing.
HARMEAN Function Returns the harmonic mean.
HARMEANZ Function Returns the harmonic mean, using zero fuzzing.
IQR Function Returns the interquartile range.
KURTOSIS Function Returns the kurtosis.
LARGEST Function Returns the kth largest non-missing value.
LPNORM Function Returns the Lp norm of the second argument and subsequent non-missing arguments.
MAD Function Returns the median absolute deviation from the median.
MAX Function Returns the largest value.
MEAN Function Returns the arithmetic mean (average).
MEDIAN Function Returns the median value.
MIN Function Returns the smallest value.
MISSING Function Returns a numeric result that indicates whether the argument contains a missing value.
N Function Returns the number of non-missing numeric values.
NMISS Function Returns the number of missing numeric values.
ORDINAL Function Returns the kth smallest of the missing and nonmissing values.
PCTL Function Returns the percentile that corresponds to the percentage.
RANGE Function Returns the range of the nonmissing values.
RMS Function Returns the root mean square of the nonmissing arguments.
SKEWNESS Function Returns the skewness of the nonmissing arguments.
SMALLEST Function Returns the kth smallest nonmissing value.
STD Function Returns the standard deviation of the nonmissing arguments.
STDERR Function Returns the standard error of the mean of the nonmissing arguments.
SUM Function Returns the sum of the nonmissing arguments.
SUMABS Function Returns the sum of the absolute values of the non-missing arguments.
USS Function Returns the uncorrected sum of squares of the nonmissing arguments.
VAR Function Returns the variance of the nonmissing arguments.

数学函数 Mathematical

ABS Function Returns the absolute value.
AIRY Function Returns the value of the Airy function.
BETA Function Returns the value of the beta function.
CALL LOGISTIC Routine Applies the logistic function to each argument.
CALL SOFTMAX Routine Returns the softmax value.
CALL STDIZE Routine Standardizes the values of one or more variables.
CALL TANH Routine Returns the hyperbolic tangent.
CNONCT Function Returns the noncentrality parameter from a chi-square distribution.
COALESCE Function Returns the first non-missing value from a list of numeric arguments.
CONSTANT Function Computes machine and mathematical constants.
DAIRY Function Returns the derivative of the AIRY function.
DEVIANCE Function Returns the deviance based on a probability distribution.
DIGAMMA Function Returns the value of the digamma function.
ERF Function Returns the value of the (normal) error function.
ERFC Function Returns the value of the complementary (normal) error function.
EXP Function Returns the value of the exponential function.
FACT Function Computes a factorial.
FNONCT Function Returns the value of the noncentrality parameter of an F distribution.
GAMMA Function Returns the value of the gamma function.
GCD Function Returns the greatest common divisor for one or more integers.
IBESSEL Function Returns the value of the modified Bessel function.
JBESSEL Function Returns the value of the Bessel function.
LCM Function Returns the least common multiple.
LGAMMA Function Returns the natural logarithm of the Gamma function.
LOG Function Returns the natural (base e) logarithm.
LOG1PX Function Returns the log of 1 plus the argument.
LOG10 Function Returns the logarithm to the base 10.
LOG2 Function Returns the logarithm to the base 2.
LOGBETA Function Returns the logarithm of the beta function.
MOD Function Returns the remainder from the division of the first argument by the second argument, fuzzed to avoid most unexpected floating-point results.
MODZ Function Returns the remainder from the division of the first argument by the second argument, using zero fuzzing.
MSPLINT Function Returns the ordinate of a monotonicity-preserving interpolating spline.
SIGN Function Returns the sign of a value.
SQRT Function Returns the square root of a value.
TNONCT Function Returns the value of the noncentrality parameter from the Student’s t distribution.
TRIGAMMA Function Returns the value of the trigamma function.

分布密度函数、分布函数 Probability

CDF Function Returns a value from a cumulative probability distribution.
LOGCDF Function Returns the logarithm of a left cumulative distribution function.
LOGPDF Function Returns the logarithm of a probability density (mass) function.
LOGSDF Function Returns the logarithm of a survival function.
PDF Function Returns a value from a probability density (mass) distribution.
POISSON Function Returns the probability from a Poisson distribution.
PROBBETA Function Returns the probability from a beta distribution.
PROBBNML Function Returns the probability from a binomial distribution.
PROBBNRM Function Returns a probability from a bivariate normal distribution.
PROBCHI Function Returns the probability from a chi-square distribution.
PROBF Function Returns the probability from an F distribution.
PROBGAM Function Returns the probability from a gamma distribution.
PROBHYPR Function Returns the probability from a hypergeometric distribution.
PROBMC Function Returns a probability or a quantile from various distributions for multiple comparisons of means.
PROBNEGB Function Returns the probability from a negative binomial distribution.
PROBNORM Function Returns the probability from the standard normal distribution.
PROBT Function Returns the probability from a t distribution.
SDF Function Returns a survival function.

二进制逻辑操作符 Bitwise Logical Operations

BAND Function Returns the bitwise logical AND of two arguments.
BLSHIFT Function Returns the bitwise logical left shift of two arguments.
BNOT Function Returns the bitwise logical NOT of an argument.
BOR Function Returns the bitwise logical OR of two arguments.
BRSHIFT Function Returns the bitwise logical right shift of two arguments.
BXOR Function Returns the bitwise logical EXCLUSIVE OR of two arguments.

数组函数  Array

DIM Function Returns the number of elements in an array.
HBOUND Function Returns the upper bound of an array.
LBOUND Function Returns the lower bound of an array.

字符串配对函数 Character String Matching

CALL PRXCHANGE Routine Performs a pattern-matching replacement.
CALL PRXDEBUG Routine Enables Perl regular expressions in a DATA step to send debugging output to the SAS log.
CALL PRXFREE Routine Frees memory that was allocated for a Perl regular expression.
CALL PRXNEXT Routine Returns the position and length of a substring that matches a pattern, and iterates over multiple matches within one string.
CALL PRXPOSN Routine Returns the start position and length for a capture buffer.
CALL PRXSUBSTR Routine Returns the position and length of a substring that matches a pattern.
PRXCHANGE Function Performs a pattern-matching replacement.
PRXMATCH Function Searches for a pattern match and returns the position at which the pattern is found.
PRXPAREN Function Returns the last bracket match for which there is a match in a pattern.
PRXPARSE Function Compiles a Perl regular expression (PRX) that can be used for pattern matching of a character value.
PRXPOSN Function Returns a character string that contains the value for a capture buffer.

组合函数 Combinatorial

ALLCOMB Function Generates all combinations of the values of n variables taken k at a time in a minimal change order.
ALLPERM Function Generates all permutations of the values of several variables in a minimal change order.
CALL ALLCOMB Routine Generates all combinations of the values of n variables taken k at a time in a minimal change order.
CALL ALLCOMBI Routine Generates all combinations of the indices of n objects taken k at a time in a minimal change order.
CALL ALLPERM Routine Generates all permutations of the values of several variables in a minimal change order.
CALL GRAYCODE Routine Generates all subsets of n items in a minimal change order.
CALL LEXCOMB Routine Generates all distinct combinations of the non-missing values of n variables taken k at a time in lexicographic order.
CALL LEXCOMBI Routine Generates all combinations of the indices of n objects taken k at a time in lexicographic order.
CALL LEXPERK Routine Generates all distinct permutations of the non-missing values of n variables taken k at a time in lexicographic order.
CALL LEXPERM Routine Generates all distinct permutations of the non-missing values of several variables in lexicographic order.
CALL RANPERK Routine Randomly permutes the values of the arguments, and returns a permutation of k out of n values.
CALL RANPERM Routine Randomly permutes the values of the arguments.
COMB Function Computes the number of combinations of n elements taken r at a time.
GRAYCODE Function Generates all subsets of n items in a minimal change order.
LCOMB Function Computes the logarithm of the COMB function; that is, the logarithm of the number of combinations of n objects taken r at a time.
LEXCOMB Function Generates all distinct combinations of the non-missing values of n variables taken k at a time in lexicographic order.
LEXCOMBI Function Generates all combinations of the indices of n objects taken k at a time in lexicographic order.
LEXPERK Function Generates all distinct permutations of the non-missing values of n variables taken k at a time in lexicographic order.
LEXPERM Function Generates all distinct permutations of the non-missing values of several variables in lexicographic order.
LFACT Function Computes the logarithm of the FACT (factorial) function.
LPERM Function Computes the logarithm of the PERM function; that is, the logarithm of the number of permutations of n objects, with the option of including r number of elements.
PERM Function Computes the number of permutations of n items that are taken r at a time.

双曲线函数 Hyperbolic

ARCOSH Function Returns the inverse hyperbolic cosine.
ARSINH Function Returns the inverse hyperbolic sine.
ARTANH Function Returns the inverse hyperbolic tangent.
COSH Function Returns the hyperbolic cosine.
SINH Function Returns the hyperbolic sine.
TANH Function Returns the hyperbolic tangent.

宏函数 Macro

CALL EXECUTE Routine Resolves the argument, and issues the resolved value for execution at the next step boundary.
CALL SYMPUT Routine Assigns DATA step information to a macro variable.
CALL SYMPUTX Routine Assigns a value to a macro variable, and removes both leading and trailing blanks.
RESOLVE Function Returns the resolved value of the argument after it has been processed by the macro facility.
SYMEXIST Function Returns an indication of the existence of a macro variable.
SYMGET Function Returns the value of a macro variable during DATA step execution.
SYMGLOBL Function Returns an indication of whether a macro variable is in global scope to the DATA step during DATA step execution.
SYMLOCAL Function Returns an indication of whether a macro variable is in local scope to the DATA step during DATA step execution.

分位数函数 Quantile

BETAINV Function Returns a quantile from the beta distribution.
CINV Function Returns a quantile from the chi-square distribution.
FINV Function Returns a quantile from the F distribution.
GAMINV Function Returns a quantile from the gamma distribution.
PROBIT Function Returns a quantile from the standard normal distribution.
QUANTILE Function Returns the quantile from a distribution that you specify.
TINV Function Returns a quantile from the t distribution.

搜索函数 Search

WHICHC Function Searches for a character value that is equal to the first argument, and returns the index of the first matching value.
WHICHN Function Searches for a numeric value that is equal to the first argument, and returns the index of the first matching value.

排序函数Sort

CALL SORTC Routine Sorts the values of character arguments.
CALL SORTN Routine Sorts the values of numeric arguments.

外部例程 External Routines

CALL MODULE Routine Calls an external routine without any return code.
MODULEC Function Calls an external routine and returns a character value.
MODULEN Function Calls an external routine and returns a numeric value.

三角函数Trigonometric

ARCOS Function Returns the arccosine.
ARSIN Function Returns the arcsine.
ATAN Function Returns the arc tangent.
ATAN2 Function Returns the arc tangent of the ratio of two numeric variables.
COS Function Returns the cosine.
SIN Function Returns the sine.
TAN Function Returns the tangent.

截断函数 Truncation

CEIL Function Returns the smallest integer that is greater than or equal to the argument, fuzzed to avoid unexpected floating-point results.
CEILZ Function Returns the smallest integer that is greater than or equal to the argument, using zero fuzzing.
FLOOR Function Returns the largest integer that is less than or equal to the argument, fuzzed to avoid unexpected floating-point results.
FLOORZ Function Returns the largest integer that is less than or equal to the argument, using zero fuzzing.
FUZZ Function Returns the nearest integer if the argument is within 1E-12 of that integer.
INT Function Returns the integer value, fuzzed to avoid unexpected floating-point results.
INTZ Function Returns the integer portion of the argument, using zero fuzzing.
ROUND Function Rounds the first argument to the nearest multiple of the second argument, or to the nearest integer when the second argument is omitted.
ROUNDE Function Rounds the first argument to the nearest multiple of the second argument, and returns an even multiple when the first argument is halfway between the two nearest multiples.
ROUNDZ Function Rounds the first argument to the nearest multiple of the second argument, using zero fuzzing.
TRUNC Function Truncates a numeric value to a specified number of bytes.

变量控制函数Variable Control

CALL LABEL Routine Assigns a variable label to a specified character variable.
CALL SET Routine Links SAS data set variables to DATA step or macro variables that have the same name and data type.
CALL VNAME Routine Assigns a variable name as the value of a specified variable.

算术函数 Arithmetic

DIVIDE Returns the result of a division that handles special missing values for ODS output.

返回数值函数 Numeric

IFN Function Returns a numeric value based on whether an expression is true, false, or missing.

网络工具函数Web Tools

HTMLDECODE Function Decodes a string that contains HTML numeric character references or HTML character entity references, and returns the decoded string.
HTMLENCODE Function Encodes characters using HTML character entity references, and returns the encoded string.
URLDECODE Function Returns a string that was decoded using the URL escape syntax.
URLENCODE Function Returns a string that was encoded using the URL escape syntax.

外部文件函数 External Files

DCLOSE Function Closes a directory that was opened by the DOPEN function.
DCREATE Function Returns the complete pathname of a new, external directory.
DINFO Function Returns information about a directory.
DNUM Function Returns the number of members in a directory.
DOPEN Function Opens a directory, and returns a directory identifier value.
DOPTNAME Function Returns directory attribute information.
DOPTNUM Function Returns the number of information items that are available for a directory.
DREAD Function Returns the name of a directory member.
DROPNOTE Function Deletes a note marker from a SAS data set or an external file.
FAPPEND Function Appends the current record to the end of an external file.
FCLOSE Function Closes an external file, directory, or directory member.
FCOL Function Returns the current column position in the File Data Buffer (FDB).
FDELETE Function Deletes an external file or an empty directory.
FEXIST Function Verifies the existence of an external file that is associated with a fileref.
FGET Function Copies data from the File Data Buffer (FDB) into a variable.
FILEEXIST Function Verifies the existence of an external file by its physical name.
FILENAME Function Assigns or deassigns a fileref to an external file, directory, or output device.
FILEREF Function Verifies whether a fileref has been assigned for the current SAS session.
FINFO Function Returns the value of a file information item.
FNOTE Function Identifies the last record that was read, and returns a value that the FPOINT function can use.
FOPEN Function Opens an external file and returns a file identifier value.
FOPTNAME Function Returns the name of an item of information about a file.
FOPTNUM Function Returns the number of information items that are available for an external file.
FPOINT Function Positions the read pointer on the next record to be read.
FPOS Function Sets the position of the column pointer in the File Data Buffer (FDB).
FPUT Function Moves data to the File Data Buffer (FDB) of an external file, starting at the FDB’s current column position.
FREAD Function Reads a record from an external file into the File Data Buffer (FDB).
FREWIND Function Positions the file pointer to the start of the file.
FRLEN Function Returns the size of the last record that was read, or, if the file is opened for output, returns the current record size.
FSEP Function Sets the token delimiters for the FGET function.
FWRITE Function Writes a record to an external file.
MOPEN Function Opens a file by directory ID and member name, and returns either the file identifier or a 0.
PATHNAME Function Returns the physical name of an external file or a SAS library, or returns a blank.
RENAME Function Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
SYSMSG Function Returns error or warning message text from processing the last data set or external file function.
SYSRC Function Returns a system error number.

金融函数Financial

BLACKCLPRC Function Calculates call prices for European options on futures, based on the Black model.
BLACKPTPRC Function Calculates put prices for European options on futures, based on the Black model.
BLKSHCLPRC Function Calculates call prices for European options on stocks, based on the Black-Scholes model.
BLKSHPTPRC Function Calculates put prices for European options on stocks, based on the Black-Scholes model.
COMPOUND Function Returns compound interest parameters.
CONVX Function Returns the convexity for an enumerated cash flow.
CONVXP Function Returns the convexity for a periodic cash flow stream, such as a bond.
DACCDB Function Returns the accumulated declining balance depreciation.
DACCDBSL Function Returns the accumulated declining balance with conversion to a straight-line depreciation.
DACCSL Function Returns the accumulated straight-line depreciation.
DACCSYD Function Returns the accumulated sum-of-years-digits depreciation.
DACCTAB Function Returns the accumulated depreciation from specified tables.
DEPDB Function Returns the declining balance depreciation.
DEPDBSL Function Returns the declining balance with conversion to a straight-line depreciation.
DEPSL Function Returns the straight-line depreciation.
DEPSYD Function Returns the sum-of-years-digits depreciation.
DEPTAB Function Returns the depreciation from specified tables.
DUR Function Returns the modified duration for an enumerated cash flow.
DURP Function Returns the modified duration for a periodic cash flow stream, such as a bond.
FINANCE Function Computes financial calculations such as depreciation, maturation, accrued interest, net present value, periodic savings, and internal rates of return.
GARKHCLPRC Function Calculates call prices for European options on stocks, based on the Garman-Kohlhagen model.
GARKHPTPRC Function Calculates put prices for European options on stocks, based on the Garman-Kohlhagen model.
INTRR Function Returns the internal rate of return as a fraction.
IRR Function Returns the internal rate of return as a percentage.
MARGRCLPRC Function Calculates call prices for European options on stocks, based on the Margrabe model.
MARGRPTPRC Function Calculates put prices for European options on stocks, based on the Margrabe model.
MORT Function Returns amortization parameters.
NETPV Function Returns the net present value as a fraction.
NPV Function Returns the net present value with the rate expressed as a percentage.
PVP Function Returns the present value for a periodic cash flow stream (such as a bond), with repayment of principal at maturity.
SAVING Function Returns the future value of a periodic saving.
YIELDP Function Returns the yield-to-maturity for a periodic cash flow stream, such as a bond.

产生随机数函数 Random Number

CALL RANBIN Routine Returns a random variate from a binomial distribution.
CALL RANCAU Routine Returns a random variate from a Cauchy distribution.
CALL RANEXP Routine Returns a random variate from an exponential distribution.
CALL RANGAM Routine Returns a random variate from a gamma distribution.
CALL RANNOR Routine Returns a random variate from a normal distribution.
CALL RANPOI Routine Returns a random variate from a Poisson distribution.
CALL RANTBL Routine Returns a random variate from a tabled probability distribution.
CALL RANTRI Routine Returns a random variate from a triangular distribution.
CALL RANUNI Routine Returns a random variate from a uniform distribution.
CALL STREAMINIT Routine Specifies a seed value to use for subsequent random number generation by the RAND function.
NORMAL Function Returns a random variate from a normal, or Gaussian, distribution.
RANBIN Function Returns a random variate from a binomial distribution.
RANCAU Function Returns a random variate from a Cauchy distribution.
RAND Function Generates random numbers from a distribution that you specify.
RANEXP Function Returns a random variate from an exponential distribution.
RANGAM Function Returns a random variate from a gamma distribution.
RANNOR Function Returns a random variate from a normal distribution.
RANPOI Function Returns a random variate from a Poisson distribution.
RANTBL Function Returns a random variate from a tabled probability distribution.
RANTRI Function Returns a random variate from a triangular distribution.
RANUNI Function Returns a random variate from a uniform distribution.
UNIFORM Function Returns a random variate from a uniform distribution.

SAS文件IO函数 SAS File I/O

ATTRC Function Returns the value of a character attribute for a SAS data set.
ATTRN Function Returns the value of a numeric attribute for a SAS data set.
CEXIST Function Verifies the existence of a SAS catalog or SAS catalog entry.
CLOSE Function Closes a SAS data set.
CUROBS Function Returns the observation number of the current observation.
DROPNOTE Function Deletes a note marker from a SAS data set or an external file.
DSNAME Function Returns the SAS data set name that is associated with a data set identifier.
ENVLEN Function Returns the length of an environment variable.
EXIST Function Verifies the existence of a SAS library member.
FETCH Function Reads the next non-deleted observation from a SAS data set into the Data Set Data Vector (DDV).
FETCHOBS Function Reads a specified observation from a SAS data set into the Data Set Data Vector (DDV).
GETVARC Function Returns the value of a SAS data set character variable.
GETVARN Function Returns the value of a SAS data set numeric variable.
IORCMSG Function Returns a formatted error message for _IORC_.
LIBNAME Function Assigns or deassigns a libref for a SAS library.
LIBREF Function Verifies that a libref has been assigned.
NOTE Function Returns an observation ID for the current observation of a SAS data set.
OPEN Function Opens a SAS data set.
PATHNAME Function Returns the physical name of an external file or a SAS library, or returns a blank.
POINT Function Locates an observation that is identified by the NOTE function.
RENAME Function Renames a member of a SAS library, an entry in a SAS catalog, an external file, or a directory.
REWIND Function Positions the data set pointer at the beginning of a SAS data set.
SYSMSG Function Returns error or warning message text from processing the last data set or external file function.
SYSRC Function Returns a system error number.
VARFMT Function Returns the format that is assigned to a SAS data set variable.
VARINFMT Function Returns the informat that is assigned to a SAS data set variable.
VARLABEL Function Returns the label that is assigned to a SAS data set variable.
VARLEN Function Returns the length of a SAS data set variable.
VARNAME Function Returns the name of a SAS data set variable.
VARNUM Function Returns the number of a variable’s position in a SAS data set.
VARTYPE Function Returns the data type of a SAS data set variable.

特殊函数 Special

ADDR Function Returns the memory address of a variable on a 32-bit platform.
ADDRLONG Function Returns the memory address of a variable on 32-bit and 64-bit platforms.
CALL POKE Routine Writes a value directly into memory on a 32-bit platform.
CALL POKELONG Routine Writes a value directly into memory on 32-bit and 64-bit platforms.
CALL SLEEP Routine For a specified period of time, suspends the execution of a program that invokes this CALL routine.
CALL SYSTEM Routine Submits an operating environment command for execution.
DIF Function Returns differences between an argument and its nth lag.
GETOPTION Function Returns the value of a SAS system or graphics option.
INPUT Function Returns the value that is produced when SAS converts an expression using the specified informat.
INPUTC Function Enables you to specify a character informat at run time.
INPUTN Function Enables you to specify a numeric informat at run time.
LAG Function Returns values from a queue.
PEEK Function Stores the contents of a memory address in a numeric variable on a 32-bit platform.
PEEKC Function Stores the contents of a memory address in a character variable on a 32-bit platform.
PEEKCLONG Function Stores the contents of a memory address in a character variable on 32-bit and 64-bit platforms.
PEEKLONG Function Stores the contents of a memory address in a numeric variable on 32-bit and 64-bit platforms.
PTRLONGADD Function Returns the pointer address as a character variable on 32-bit and 64-bit platforms.
PUT Function Returns a value using a specified format.
PUTC Function Enables you to specify a character format at run time.
PUTN Function Enables you to specify a numeric format at run time.
SLEEP Function For a specified period of time, suspends the execution of a program that invokes this function.
SYSGET Function Returns the value of the specified operating environment variable.
SYSPARM Function Returns the system parameter string.
SYSPROCESSID Function Returns the process ID of the current process.
SYSPROCESSNAME Function Returns the process name that is associated with a given process ID, or returns the name of the current process.
SYSPROD Function Determines whether a product is licensed.
SYSTEM Function Issues an operating environment command during a SAS session, and returns the system return code.
UUIDGEN Function Returns the short or binary form of a Universal Unique Identifier (UUID).

变量信息函数 Variable Information

CALL VNEXT Routine Returns the name, type, and length of a variable that is used in a DATA step.
VARRAY Function Returns a value that indicates whether the specified name is an array.
VARRAYX Function Returns a value that indicates whether the value of the specified argument is an array.
VFORMAT Function Returns the format that is associated with the specified variable.
VFORMATD Function Returns the decimal value of the format that is associated with the specified variable.
VFORMATDX Function Returns the decimal value of the format that is associated with the value of the specified argument.
VFORMATN Function Returns the format name that is associated with the specified variable.
VFORMATNX Function Returns the format name that is associated with the value of the specified argument.
VFORMATW Function Returns the format width that is associated with the specified variable.
VFORMATWX Function Returns the format width that is associated with the value of the specified argument.
VFORMATX Function Returns the format that is associated with the value of the specified argument.
VINARRAY Function Returns a value that indicates whether the specified variable is a member of an array.
VINARRAYX Function Returns a value that indicates whether the value of the specified argument is a member of an array.
VINFORMAT Function Returns the informat that is associated with the specified variable.
VINFORMATD Function Returns the decimal value of the informat that is associated with the specified variable.
VINFORMATDX Function Returns the decimal value of the informat that is associated with the value of the specified variable.
VINFORMATN Function Returns the informat name that is associated with the specified variable.
VINFORMATNX Function Returns the informat name that is associated with the value of the specified argument.
VINFORMATW Function Returns the informat width that is associated with the specified variable.
VINFORMATWX Function Returns the informat width that is associated with the value of the specified argument.
VINFORMATX Function Returns the informat that is associated with the value of the specified argument.
VLABEL Function Returns the label that is associated with the specified variable.
VLABELX Function Returns the label that is associated with the value of the specified argument.
VLENGTH Function Returns the compile-time (allocated) size of the specified variable.
VLENGTHX Function Returns the compile-time (allocated) size for the variable that has a name that is the same as the value of the argument.
VNAME Function Returns the name of the specified variable.
VNAMEX Function Validates the value of the specified argument as a variable name.
VTYPE Function Returns the type (character or numeric) of the specified variable.
VTYPEX Function Returns the type (character or numeric) for the value of the specified argument.
VVALUE Function Returns the formatted value that is associated with the variable that you specify.
VVALUEX Function Returns the formatted value that is associated with the argument that you specify.

美国人专用函数 与地理位置有关的一些函数 美国人对美国人真好

函数名 作用
Distance

距离函数

GEODIST Function Returns the geodetic distance between two latitude and longitude coordinates.
ZIPCITYDISTANCE Function Returns the geodetic distance between two zip code locations.
State and Zip Code

州和邮政编码

FIPNAME Function Converts two-digit FIPS codes to uppercase state names.
FIPNAMEL Function Converts two-digit FIPS codes to mixed case state names.
FIPSTATE Function Converts two-digit FIPS codes to two-character state postal codes.
STFIPS Function Converts state postal codes to FIPS state codes.
STNAME Function Converts state postal codes to uppercase state names.
STNAMEL Function Converts state postal codes to mixed case state names.
ZIPCITY Function Returns a city name and the two-character postal code that corresponds to a zip code.
ZIPCITYDISTANCE Function Returns the geodetic distance between two zip code locations.
ZIPFIPS Function Converts zip codes to two-digit FIPS codes.
ZIPNAME Function Converts zip codes to uppercase state names.
ZIPNAMEL Function Converts zip codes to mixed case state names.
ZIPSTATE Function Converts zip codes to two-character state postal codes.

原创文章: ”最全的SAS9.2函数列表一“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/97


25 10月 10 2010年10月近期SAS职位招聘列表


接近年尾,各家大公司纷纷放出职位以储备人员,导致招聘信息爆发。

从学生到有工作经验人士,从本科到博士,从马上急需到年底各种需求一应俱全,地点分布主要在北京,上海,杭州等地。

以下均为最近发布消息由急到缓和信息完整程度排列职位:

1,SAS中国公司

职位:技术支持 售前客户分析

工作地点:北京

猎头联系方式:231650869@qq.com

有SAS基础,英文口语好,懂数据库、操作系统就行。

2,公司:东南融通

联系方式:zbvcnet@yahoo.com.cn

analysts needed(urgent) 急需

BS/MS in math/stat/econ/cs,

2-5 yrs of SAS experience,

preferrably in banking industry.

For currently employed,need to join Longtop(NYSE:LFT),

For graduating students,can start as interns.

First assignment in Shenzhen for a bank for a few months.

Longtop will train you to be risk analyts prior to and after this assignment.

salary:

junior 6k to 10k/mo, senior up to 15k.

Location:

Beijing or Shanghai.

3,ebay 贝宝

工作地点:上海
有效期:2010年底之前
联系人:shiyiming#bigfoot.com
来源:mysas.net
Business Analysis Manager, Customer Analytics
Job Responsibilities
Analytics support to measure customer value, predict customer lifetime value and optimize business initiatives to drive customer value.
Analytics support to Consumer Marketing initiatives and projects.
Collaborate with business teams across the world and champion Custom Lifecycle Value/CRM framework and findings.
Communicate insights and support executives in taking business decision.
Provide technical expertise in data mining, measuring business performance and running research using advance mathematical, statistical and experimental approach.
Manage ad-hoc projects, collaborate with global teams and take part in international projects.
Job Requirements
Graduate degree in quantitative fields such as statistics, economics, mathematics, computer science, operations research or MBA.
8 years of marketing and business analytics experience.
Good understanding of ecommerce, marketing, tracking and program measurement.
Great business sense and superior analytical skills with the ability of understanding business problems and developing innovative and practical solutions to solve complex problems and execute on solutions.
Proficient in SAS, SQL, VBA and Microsoft Office.
Working knowledge of advanced data mining tools such as SAS Enterprise Miner.
Extensive experience with large data sets and data manipulation.
Ability to manage, lead, and mentor junior data analysts to maximize productivity and deliver results.
Strong oral and written communication skills in both English and Mandarin.
Strong project management skills.
Ability to multi-task, handle multiple projects with demonstrated follow-through.
Able to handle ambiguous work environment and operate with little supervision.
A sense of humor, personal integrity, and an appreciation for team-work.

Senior Business Analyst, Internet Marketing Analytics
Job Responsibilities
Work with business partner to support global Internet Marketing tracking on measurement building, performance reporting and business insight.
Lead ad-hoc data request, issue fixing and business analysis to support international business partner.
Communicate insights and support executives in taking business decision.
Support on the analytic platform construction, maintaining and enhancing.
Develop and maintain the analytic tools and automation process to improve the consistency and efficiency.
Quality control and assurance.
Develop and document mitigation processes.
Job Requirements
Graduate degree in quantitative fields such as statistics, economics, mathematics, computer science, operations research or MBA.
5 years of marketing and business analytics experience.
Great business sense and superior analytical skills with the ability of understanding business problems and developing innovative and practical solutions to solve complex problems and execute on solutions.
Proficient in SAS, SQL, VBA, UNIX, Java programming and Microsoft Office. Working knowledge of advanced data mining tools such as SAS Enterprise Miner is a plus.
Extensive experience with large data sets and data manipulation.
Strong oral and written communication skills in both English and Mandarin.
Strong project management skills.
Ability to multi-task, handle multiple projects with demonstrated follow-through.
Able to handle ambiguous work environment and operate with little supervision.
A sense of humor, personal integrity, and an appreciation for team-work.

4,支付宝高薪招聘数据分析师

联系Email:flyeykof(@)163.com 或AlipayKDD(@)gmail.com

来源:中国统计论坛 http://bbs.itongji.cn/thread-6503-1-1.html

公司名称: 阿里巴巴旗下支付宝
岗位名称: 数据分析 数据挖掘工程师
工作类型: 全职
招聘人数: 10
工作地点: 杭州
工作年限: 2
专 业: 统计学 数学 计算机信息管理
学 历: 本科 硕士 博士

A. 工作职位 高级数据分析师
城市:杭州
子公司:支付宝
学历要求:硕士
工作经验:三年以上
职位描述:
1、根据对行业、竞争环境以及公司业务的了解,独自承担复杂分析任务,并形成分析报告

2、相关分析方向包括:重要产品相关、用户行为相关,业务逻辑相关;
职位要求:
1、3年以上数据分析领域相关工作经验;
2、硕士及以上学历;
3、具有深厚的数学、统计学和计算机相关知识,熟悉数据仓库和数据挖掘的相关技术,能
够够熟练使用SQL;精通office和至少一种以上的数据分析工具;具有良好的分析报告撰写
能力,能制作专业分析报告;
4、较强的学习及人际技巧、影响说服能力,能在一定压力下工作;

B. 工作职位 资深数据分析师
城市:杭州
子公司:支付宝
学历要求:硕士
工作经验:五年以上
职位描述:
1、 对海量业务数据进行分析挖掘,产出有效的模型供业务部门数据化运营使用;
2、 相关方向包括:用户行为和生命周期相关,风险控制相关,模型架构相关。
职位要求:
1、5年以上数据分析和挖掘领域相关工作经验;
2、数学、统计、计算机等相关专业硕士及以上学历;
3、具有深厚的统计学、数学、数据挖掘等相关知识,熟悉数据仓库和数据挖掘的相关技术
,能够熟练使用SQL;
4、精通一种及以上数据挖掘工具(精通开源数据挖掘软件者优先),具有海量数据挖掘、
分析相关项目实施经验,参加过完整的数据挖掘项目并有成功案例;有网站用户行为研究
和文本挖掘经验尤佳;
5、思维敏捷,良好的逻辑分析能力、良好的沟通及组织能力,能在一定压力下工作
***************************************************************************

上面工作岗位及职能仅做参考,走内部推荐,工作岗位及要求如下:

首先说明,这次主要招聘四种人士
a. 偏技术类并有数据分析倾向人士:精通SQL语言,熟悉数据仓库并有这方面的工作经验
,有往数据分析这个方向发展倾向的人士。
b. 曾从事业务分析人士:通过数据发现业务问题,并可得出结论形成分析报告,有从事类
似职业的人士。
c. 曾从事数据挖掘人士:有从事数据挖掘工作,具备建模能力,有过相关项目成果人士。
d. 特殊领域人士(对以上三种并不精通的特殊领域人士):在金融服务领域、电子商务领
域工作人士,若对以上三种职业并不精通,但对自身所在领域相当熟悉,也将从优考虑。
工作职位 数据分析师(对所有数据分析师的统称,目前内部并未划分高级或资深的职称概
念)
工作地点 杭州
学历要求 本科及本科以上(内部推荐不会有硕士学历的硬性要求,以能力为主)
工作经验 两年及以上(内部推荐的工作经验硬性要求较低,依然能力为主;当然同等条件
下经验越多者优先)
招聘人数 10人

职位描述
1、 对海量业务数据进行分析挖掘,产出有效的模型供业务部门数据化运营使用;
2、 通过业务数据分析,发现业务问题,并可得出结论形成分析报告;
职位要求
1、两年以上数据分析和挖掘领域相关工作经验(b、c类人士必须具备);
2、数学、统计、计算机等相关专业本科及以上学历(b、c类人士必须具备);
3、具有深厚的统计学、数学、数据挖掘等相关知识,熟悉数据仓库和数据挖掘的相关技术
,能够熟练使用SQL(b、c类人士必须具备);
4、精通一种及以上数据挖掘工具(精通开源数据挖掘软件者优先),具有海量数据挖掘、
分析相关项目实施经验,参加过完整的数据挖掘项目并有成功案例;有网站用户行为研究
和文本挖掘经验尤佳(b、c类人士必须具备);
5、思维敏捷,良好的逻辑分析能力、良好的沟通及组织能力,能在一定压力下工作
另外,本次也招聘1-2位市场研究专员,主要从事市场调研工作,需要有相关经验的人士。

5, SAS临床程序员

联系方式: MSN:selin04940@hotmail.com
也可以直接将简历发至:csh04940@sina.com

来源:mysas.net
工作地点在北京
要求:
1. 流行病卫生统计、计算机应用、数学等相关专业2010年毕业生
2. 有过SAS使用经验
3. 优秀的沟通能力和学习能力
4. 英文能基本交流即可

6 招聘SAS工程师

有兴趣的请发送简历到我的邮箱yyivani1984@hotmail.com。

根据零售业务发展和分析需要,对零售客户、产品和渠道进行分析,响应各项业务分析需求

,配合营销活动开展,统计相关绩效指标,配合系统项目开发。

负责团队报表平台,支持常规报表的自动化统计和输出;

负责及时响应业务需求,按需定制各种业务报表;

整合同一客户名下的各种基本属性、产品、帐户、接触记录等信息,生成各类客户分析报告;

配合业务的开展,对重点产品生成业务分析和跟踪报告;

统计绩效指标,生成绩效考核报表,支持有效卡的考核工作;

配合CRM系统项目的开发,参与项目的设计和开发过程;

开发模型并建立风险政策和程序;

通过分段,建立追踪机制去监控新在册客户信贷质量;

验证资产组合行为参数以确保其合适性及与资产组合策略一致;

利用冠军/挑战者方法,协助模型的实施,包括监控、分析测试结果,并在测试阶段提出下一步的建议。

任职要求:

掌握数据分析相关原理知识、掌握零售银行业务、产品、营销等综合知识.

掌握常用的数据挖掘建模方法,如Logistic回归、决策树、神经网络、聚类、关联等,并能通过SAS等数据挖掘软件实现。

很强的统计和分析能力,较强的协调沟通能力,扎实的计算机能力,熟练使用Excel, Word and PowerPoint.

有以下一项以上的工作知识: SAS, SPSS, Minitab.

良好的学习能力,强烈的责任心和解决问题的能力,以及良好的商业敏感性.

7 急招高级SAS分析员
联系方式:hr.interecruit@gmail.com
来源:mysas.net
***新成立数据服务事业部,急需SAS分析员若干。
部门雇员遍布北京、纽约、旧金山、芝加哥,同时还与银行、金融、风险管理、市场、
零售等业界的国内外专家保持密切合作。
我们的定位是成为国内领先,国际先进的智能营销方案提供商,从数据到研究进而到营销计划最终达到
多方获利,为顾客和社会创造更多价值。欢迎你加入成为我们一员。
公司地址: 北京市CBD燕莎商区 (交通便捷)
岗位职责:
对实际业务数据进行分析以及统计建模
与客户会谈沟通以了解项目需要
表现优秀者有机会短期获得管理经验
岗位要求:
本科及以上学历,理工科/统计专业优先
一年以上工作经验,金融背景优先
熟练使用Server和PC版SAS,包括数据处理,宏命令,统计建模,树, enterprise miner
具备敏锐的市场洞察能力,良好的逻辑分析能力,书面及口头表达能力
良好工作态度,优秀团队精神

8 某世界500强医药公司招SAS Programmer

来源:mysas.net

有意者请尽快发简历至:125366522@qq.com,并注明在SAS中文论坛中看到招聘,谢谢!

Job Title: SAS Programmer

Location: Beijing
KEY ACCOUNTABILITIES:
1.Provide timely programming support to data review report and patient profiles by using SAS,

develop and execute validation plans
2.Provide primary programming support for the development of efficient data processing and analysis tools
3.Provide programming support for the implementation of data review plans
4.Provide programming support on phase I study PK analysis.
Experience & knowledge:
Good SAS programming, and other computer programming skill required

Core competencies:
1.Effective English verbal and written communication skills in relating to colleagues and

associates both inside and outside the organization control approach to work.
2.Ability to work effectively in a multi-cultural context as a good team member.
Salary: negotiable

原创文章: ”2010年10月近期SAS职位招聘列表“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/91


08 10月 10 2010年美国百佳雇主公司


这列表里面中熟悉的公司不多,有google,卡西欧,微软排51,没找到apple,没有IBM,也没有惠普。当然,这只能是反映某一个方面的问题,不能代表公司全部。尽管SAS公司总是被评为100佳雇主,跳槽率很低,但是还是会有人跳槽,说明公司就算提供了非常好的环境待遇,也不能满足所有人愿望。

排名100的最佳雇主列表:

排名 公司名称 2010年增加岗位 美国员工人数
1 SAS 2% 5,487
2 Edward Jones 8% 37,079
3 Wegmans Food Markets 0% 36,770
4 Google N.A.% N.A.
5 Nugget Market -16% 1,342
6 DreamWorks Animation SKG 13% 1,825
7 NetApp 0% 5,033
8 Boston Consulting Group 3% 1,737
9 Qualcomm 3% 12,255
10 Camden Property Trust -6% 1,743
11 Robert W. Baird & Co. 6% 2,286
12 Bingham McCutchen -7% 1,859
13 W. L. Gore & Associates 5% 5,764
14 Recreational Equipment -6% 8,640
15 Zappos.com -21% 1,300
16 Cisco 0% 37,276
17 Methodist Hospital System 6% 11,145
18 Whole Foods Market -9% 47,478
19 Genentech 2% 11,146
20 Devon Energy 4% 3,912
21 NuStar Energy 4% 1,375
22 Johnson Financial Group 1% 1,316
23 Umpqua Bank 8% 1,836
24 Goldman Sachs Group -13% 12,243
25 Novo Nordisk 10% 3,360
26 CHG Healthcare Services -12% 1,142
27 Scottrade 22% 2,409
28 JM Family Enterprises -18% 3,772
29 Quicken Loans 0% 2,893
30 Alston & Bird 7% 1,842
31 PCL Construction Enterprises -10% 3,970
32 Baptist Health South Florida 11% 11,729
33 Shared Technologies -21% 1,243
34 Chesapeake Energy 20% 7,720
35 American Fidelity Assurance Co. -1% 1,502
36 Container Store -9% 3,233
37 Aflac -3% 4,353
38 Scooter Store 51% 2,173
39 TDIndustries 7% 1,588
40 Scripps Health 15% 11,444
41 QuikTrip 5% 10,311
42 Adobe Systems -4% 4,065
43 Salesforce.com 21% 2,361
44 Ernst & Young -4% 24,815
45 USAA -1% 21,999
46 OhioHealth 3% 12,128
47 J. M. Smucker 44% 4,521
48 FactSet Research Systems 9% 1,322
49 Mercedes-Benz USA 0% 1,612
50 King’s Daughters Medical Center 7% 3,263
51 Microsoft 2% 54,923
52 Booz Allen Hamilton 13% 21,303
53 Nordstrom -8% 45,853
54 Paychex 2% 12,456
55 Mayo Clinic 0% 41,839
56 CarMax -16% 13,030
57 DPR Construction -2% 1,142
58 Four Seasons Hotels -9% 12,345
59 Monsanto 5% 10,772
60 Indiana Regional Medical Center 3% 1,200
61 Brocade Communications Systems 39% 2,873
62 Kimley-Horn -19% 1,808
63 Southern Ohio Medical Center 8% 2,286
64 Stew Leonard’s -6% 2,037
65 Arnold & Porter 1% 1,295
66 Plante & Moran 1% 1,547
67 EOG Resources -4% 1,725
68 Men’s Wearhouse -9% 14,764
69 MITRE 2% 6,572
70 Deloitte 1% 39,065
71 PricewaterhouseCoopers 1% 29,387
72 McCormick and Company 2% 2,799
73 American Express -10% 27,265
74 Children’s Healthcare of Atlanta 13% 6,536
75 Perkins Coie -3% 1,680
76 Balfour Beatty Construction -12% 1,514
77 Baker Donelson -1% 1,127
78 Mattel -9% 5,293
79 Meridian Health 12% 7,099
80 Build-A-Bear Workshop -14% 4,588
81 Atlantic Health 2% 7,114
82 Marriott International -10% 110,091
83 S. C. Johnson & Son 0% 3,343
84 Accenture -7% 30,000
85 Arkansas Children’s Hospital 8% 3,733
86 Publix Super Markets 2% 139,578
87 National Instruments 2% 2,568
88 KPMG -7% 20,972
89 Bright Horizons 0% 14,497
90 General Mills -2% 16,681
91 FedEx -4% 218,770
92 Gilbane -11% 1,934
93 Starbucks Coffee -27% 116,357
94 Intuit -7% 6,710
95 Orrick Herrington & Sutcliffe -8% 1,481
96 LifeBridge Health 5% 6,350
97 Herman Miller -8% 5,186
98 Intel 0% 43,905
99 Winchester Hospital 4% 2,027
100 Colgate-Palmolive 2% 5,366

在美国地图上分布情况,发现很明显东部居多。目前看来,美国的公司的在经济、工作环境上也存在地域性不均衡现象。

前100公司分布

注:《财富》杂志的年度“百佳雇主”由《财富》杂志联合Great Place to Work Institute(理想工作场所协会)对美国工商企业界进行了大量的员工调查。公司得分的三分之二基于该协会的“信任指数”(Trust Index)调查结果,该调查的问卷被发送给从各企业随机抽选出来的员工。问卷问题涉及员工对管理层的信誉、工作满意度及同事关系的态度。公司得分的余下三分之一基于企业对该协会的“文化调查”(Culture Audit)问卷的回答,该调查包括有关员工薪酬和福利计划的详细问题以及一系列有关员工聘用、沟通及多样化的开放性问题。

来源:CNN: http://money.cnn.com/magazines/fortune/bestcompanies/2010/full_list/

科技资讯网http://www.cnetnews.com.cn/2010/0204/1624623.shtml

原创文章: ”2010年美国百佳雇主公司“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/89


07 10月 10 七个SAS公司员工博客


尽管目前大型博客站点纷纷倒闭,但是博客这种非常个性化的形式,不会过时,还是非常适合技术人员来分享技术。我觉得很多大型综合性的博客站不容易个性化,不好定位而导致关门,而个人博客如果定位某一门技术,也许受众很小,但也是能提高所在行业知名度的。当然写博客是件辛苦的事情,大部分都是义务劳动,汗水换荣誉。不过这次推出的是有公司给博主付费的博客,那就是SAS公司。                http:// saslist.net

SAS公司博客最近新增了两位员工博客,一个是关于IML主题,一个是关于JMP主题。毫无疑问,他们是日常工作就是与这些内容打交道,通俗点,他们就是专门干这个的,当然他们的技术博客也值得订阅学习,也可以在博客留言问问题交流,提供技术支持本来就是他们的工作一部分。下面除了给出新开了两个博客,我另外挑选了5个技术性非常强的博客,一个7个,如下:                             http://saslist.net

Rick Wicklin 新开博客

IML模块/studio开发者  Statistical Programming with SAS/IML Software 作者  http://blogs.sas.com/iml/

JMP 新开博客
有关JMP软件 数据展现、six sigma、实验设计及统计            http://blogs.sas.com/jmp/
负责support.sas.com更新                        http://blogs.sas.com/supportnews/
内容为Enterprise Guide, 微软办公 Add-In 和EM. SAS for Dummies作者 http://blogs.sas.com/sasdummy/
SAS用户全球论坛  http://blogs.sas.com/sgf/
SAS培训、认证,一些技巧建议 http://blogs.sas.com/sastraining/
文本挖掘,非结构性文本 团体博客 http://blogs.sas.com/text-mining/
————————————————
SAS公司陆续推出员工博客,值得我们关注。

原创文章: ”七个SAS公司员工博客“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/88


04 10月 10 SAS语言管窥 SAS_Dream 2004


这个文章最早见于2004年的sasor论坛,现在读来,仍然感觉经典。

尽管SAS经过这么多年发展,并且现在版本更新越来快,新模块和新功能如雨后春笋般冒出来,但是经典的文章仍值得再读一遍,哪怕是你读过很多遍。前一文转载了SAS的零碎印象一文,这两文每次读来都感到自己见识局限。因此,“精通“一词不管用于形容一个人的SAS技术,还是用来作为书名,值得谨慎考虑,再此,重读一些这些经典文章来提醒自己。因此,本博虽崇尚原创,并且网上的转载无数到连作者和出处都变更无数或者干脆没有,但是这里仍推荐大家重读一次经典。          saslist.net

另外,我很迷惑一点,为什么时隔五六年,还没有超过这两篇的关于SAS的中文评论出现,是没有像SAS_DREAM这样的技术高手,还是技术高手很忙?

附:

SAS语言管窥

由 SAS_Dream » 2004-3月-28 00:15

感觉SAS语言体系是庞杂多于宏大。因为很多可以称得上宏大的语系例如微软系或者现在的Java系,多是先有一个比较周全的架构,通过有序的新生、继承和变异,逐渐扩展膨胀的,语言元素之间有比较规范的关联。而SAS的语系虽有局部的架构,但就全局而言,主要是自发形成,也就是20多年的堆积和承袭。其实这也自然,SAS的应用领域靠近最终用户,模式千变万化,很难现有周全架构,只要有可行解就行了,而很多有组织的语系比较靠近系统底层,实际范畴比较集中,比较容易研究出架构。

因此,SASOR们的武艺和兵器往往是门派繁多,千变万化,但是很难有那种18般兵刃样样精通的武林宗师(如果那位知道有,麻烦通知一下,我们好沐浴焚香去拜)。

粗浅的印象是,SAS语系可以大致如下划分:

国语:Base语系

这是SASOR们不分阶级不分贫富都可以讲的话,里面就包含了常说的Data Step,Proc Step和Macro。SAS的基础语言元素主要是在这里演进而来。这个语言可以说是七十和八十年代面向过程处理语言的扛鼎之作,甚至还带有浓郁的非结构化色彩;难得的是SAS公司作为偏重技术的私人公司,二十多年以继承发展而非不断否定的方式打造Base,使得一些二十多岁“高龄”的函数和过程历久弥新,在如今面向对象的强势群体中仍以面向过程的独特魅力占有一席之地。

Data Step为处理与数据存储引擎的交互提供了规范,可以处理大量复杂的数据操作和变量操作,Data Step的底层是用C语言开发的。而Proc Step的出现则具有两重含义,一是将一些常用的过程组合归整为固定的过程调用,在语言书写上或处理效率上起到提升作用;二是确定了今后很多SAS模块语言的规范,比如PROC 的调用格式,CLASS, VAR, BY等语句,被广泛地应用在统计模块(如Proc Reg),数据访问模块(如Proc DBLoad),多维模块(Proc MDDB),数据共享模块(如Proc Server)以及很多GUI驱动的模块的shell命令(如EM中的Proc Neural)。Proc Step用Data Step和C语言结合开发而成。

Macro是Base中增强程序流程控制的语言机制。Macro并不是函数封装的概念,它的核心思路是文本替换,同操作系统shell脚本的机制相似。因此,macro的执行是依据macro定义首先进行文本替换,得出最终程序语句后再解释执行。所以在内存分配中,并不像其它语言中那样形成函数调用堆栈。所以在Macro开发中,不能像函数调用那样实现调用现场退栈式的参数传递。虽然这种机制不像函数调用那样带来更多的编程灵活性,但是由于文本替换不涉及复杂的内存分配管理,所以即使用很复杂的macro,替换的效率也很高,同时出现内存管理错误的概率也较小。由于Macro的设计含有大量的非结构性元素,所以编程的流程管理要多加注意,否则很容易造成程序可读性差的现象(事实上,看到%就想吐的现象是普遍存在的)。

Base中有一个过程值得单独加以考察,就是Proc SQL。事实上,它实现了对SQL的兼容,给很多熟悉SQL的编程者多了一个选择。截至V8系列,Proc SQL使用的SQL是基于SQL92标准的SAS SQL超集,有很多SAS特点的语法。关于同样的处理是使用SQL还是Data / Proc Step效率高的问题可以另行讨论,简单的说,从设计思路上,SQL是基于集合的语言,而SAS是基于记录的语言;SAS的开发在SQL和Data / Proc Step上并不是协调一致的,在V6的SAS中,很多SQL操作明显比Data / Proc Step低效,在V8中,SQL有了明显改善,有些情况下会超过Data / Proc Step,但是也需具体情况具体分析,随着数据量的增长,Proc SQL不如Data / Proc Step内存管理稳定的现象会渐渐明显,效率会有较大差距;在V9开发中,SQL的势力进一步增强,提升幅度也会比以前大。

Base语言的技能和思路是SAS的基本功,也是进入至高境界的重要途径。对于初入江湖的少侠,Base语言像马步冲拳非连不可,而到了“手中无剑,心中有剑”境界的大侠,也往往只用SAS摆平一切,代码思路之惊艳让人叹为观止。

官方语言:分析语系

分析语系是以PROC STEP架构扩展一些分析模块的语言,包括STAT,OR,QC,ETS,Insight和EM的shell过程,还有用于算法扩展的IML等。

分析语言有些贵族,因为需要有相应的背景特别是统计背景的人才能讲好。换句话说,SAS的贵族气质,主要也是靠分析语言表达。

经典统计语言STAT是名门望族的常用语,每个过程都是多年的功力积累,所以即便是极为常见的过程,也是在性能、精度特别是边界条件处理上表现出众,任何一个竞争对手,如果有机会去看到STAT开发组的豪华阵容和深厚积淀,都应该知道想要技术上超越STAT要承受的压力。

经济时间序列语言ETS也是在一个专门领域练透内功的产物,支持的算法种类和可定制性十分突出。

QC和OR语言是在专门学科应用领域的力作,尤其QC,是大型分析套件中,位置十分突出,不过这个领域里竞争对手的研究也很深入,做到关键功能不逊于SAS的也有。

Insight的语言主体是PROC Insight,可以以后台批量方式完成Insight操作。

EM的语言是针对EM中的各个处理节点,提供相应的PROC集合,例如PROC DMDB来生成数据挖掘数据库,PROC TREE实现决策树,PROC NEURAL实现神经元网络,等等;这种语言扩展有很重要的意义,很多厂家在炒“in database mining”的概念,实质上就是可以用一些挖掘语言直接对数据库进行挖掘操作,而EM语言与SAS数据引擎和其它SAS语言本身就是浑然天成,优势独到。

IML是针对矩阵定义和运算的语言扩展,有些另类,但是用好了可以写出很多复杂的算法。并不是所有的人都能或者都需要学好分析语言,而且把所有分析语言都精通和熟练也非易事,但是结合实际问题和统计知识,多理解一些对于思路的发展益处多多。其实数据库领域本身是非常适合统计知识的应用的,经常为数据库管理所累的设计开发者,借助SAS实地操练一些统计知识,会发现另外一片天地,比如数据库的查询命中率优化和结果数估算,数据量推算,数据仓库里的数据质量评估和提升,数据库厂家的很多方法知识含量少得可怜,用上SAS的分析语言,往往是迎刃而解。

形体语言:Graph

SAS Graph的强项不在于免编程的易用性,而在编程语句的完备。真正掌握了Graph编程会获得极大的自由,尤其是会熟练运用Annotate之后。有两大类方向上可以施展Graph功力,一是统计分析,当年SAS的数据挖掘大师Will Potts(现在在Data-miners,与Gordon Linoff等大师共事)讲解神经元网络的时候,就是自如运用Graph语句观看效果,辅助分析,熟稔程度令人叹为观止;一是应用展示,Graph对于图形种类的支持、定制的变化、比例的调配、边界条件的处理以及大数据量绘图的优化处理上均有不俗表现,很多时候Graph结果会给应用展示增添耀眼的亮点。

Graph技能出色的SASOR,像是轻功超卓的大侠,挥洒之间,偶像感十足。

时尚语言:SCL(AF)

SCL隶属于AF模块,是SAS语言中具有面向对象特征的开发语言。它的主创人之一据说是在SAS总部的一位台湾设计师,而且是OOP里还算开始比较早的开发语言。SAS一度想利用SCL与业界的流行开发语言体系接轨,其间加大投入,但是由于这个领域自身变幻莫测,SAS又不是领头羊,因而SCL在最近版本中具有极强的“时尚色彩”,所谓“时尚”,就是容易张扬也容易过气。SCL的名字也经历着变化,原先叫Screen Control Language,老老实实地想做GUI,后来叫SAS Component Language,俨然一副改天换地挑大梁的架势。而现在,Java在研发中的呼声很高,SCL的前景就很微妙,因为新派的Java系开发者对SCL和Base知道得相对较少,而传统的了解Base的SCL开发者转型Java也并非易事,SCL逐渐从前台退到后台,甚至重点集中到了通信接口层。因此,SCL是否会就此过气,很多人在怀疑中… ….

个人的观点是,SCL还是一套很漂亮的开发语言,自己建立了一套变量规范和流控体系,特别是OOP的体系,虽然C或者Java的熟手会看着怪怪的,但是实用性和效率上还是有自己的特点。SCL中的最重要的数据结构是SCL List,这是一种类似于Java数组的树形数据结构,这是一个兼顾灵活性和处理效率的设计,整个对象体系在这个结构上做文章,核心思路简明精炼;同时在与SAS数据引擎的交互上有突出的便利性。

至于SCL中的一些可视控件,也就是众多的FRAME元素,虽然在某些方面有特点,但总体上是乏善可陈。

SCL的使用主要集中在应用开发特别是一些前端开发上,但是AF,以及利用AF开发的EIS等模块都有些前景未卜,到底如何投入精力去掌握SCL,是个值得思考的问题。

劳工号子:引擎类语言MDDB和SPDS

这里没有丝毫贬义,因为使用多维引擎MDDB或者并行引擎SPDS的开发者,多是责任多于成就感,劳累多于飘逸的苦行者。

SAS MDDB是SAS用于多维处理的模块,现在有更时髦的名字SAS OLAP Server,后台的核心语言元素是Proc MDDB,这是个处理多维存储的功能强大的过程,想充分发挥SAS多维引擎优势的开发者,不妨着力修炼一下这个过程步。

SPDS是SAS用于并行处理的数据引擎,其实是SAS的数据引擎宗师Ami自创的一套独立的并行数据库,和Base SAS特点迥异。Base SAS对于SPDS的处理就像连接Oracle等外部数据库,Base语法用于SPDS很大程度是为了程序书写形式的兼容,而要想真正发挥SPDS的并行优势,需要掌握一套基于SPDS的SQL,和SQL Pass Through的连接语法。SPDS的名气不是很大,但在有经验的设计师调配之下,它发挥的性能是惊人的。

但是这两个语言的问题是,当劳工渐渐转变为白领以后,劳工号子就可能变了… …OLAP和SPDS是SAS V9和以后版本表面封装的重点,语法变化和依附性变化都会很大,所以旧船票是否能登上明天的客船还是一个谜… …

外地语言 Connect / Share和外语Access

Connect和Share是本地SAS调用远程SAS进程的通讯机制,SAS的C/S架构使用对等主机的概念,SAS主机之间可以通过Connect语言中的Rsubmit块、Proc Upload/Proc Download等语言元素互相提交任务,反馈结果。Share语言的主体是Proc Server,通过这个过程,将SAS数据和计算共享给远程SAS主机或是ODBC,JDBC接口。

ACCESS模块的功能是使SAS可以和很多异构数据库进行双向透明的交互。V8以后的ACCESS可以通过Base语言中Libname的扩展节省编程语句的复杂度,但是在必要的时候,仍可以通过ACCESS、DBLoad等过程来处理灵活复杂的要求。

其它边远地区的方言

还有很多模块可以通过Proc Step扩展或SAS函数的形式拓展SAS语系的范围。这里不再赘述。

原创文章: ”SAS语言管窥 SAS_Dream 2004“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/87


02 10月 10 一本得不到的SAS书


书名为: Professional SAS Programming Shortcuts – Over 1,000 Ways To Improve Your SAS Programs

这本书是老少通吃的书,不管你是新手,还是多年的老手程序员,这本书都是书架必备,不可多得的。但是这本书在大陆没有买的,网上不可求的。中国大陆图书馆没有收藏,香港中文大学和香港大学图书馆有藏; 台湾国立成功大学和台湾中原大学图书馆有藏。saslist.net

Amazon上的作者摘要和图书信息

Summary:
In just three years, Professional SAS Programming Shortcuts became SAS programmers’ favorite book of tips, techniques, and algorithms. The new 2nd edition is updated and redesigned to provide quicker access to how-to instruction and thousands of examples of common data processing techniques done in SAS, including many not described in any other book.

Author : Rick Aster
Binding : Paperback
BISAC Subject : COMPUTERS / Programming Languages / General
Book Type : NON-FICTION
Dewey : 005
Edition : 2 Updated
Language : English
LCCN : oc2007025008
Library Subject : SAS (Computer file)
Pages : 448, 448 p. :
Publication Date : 04/30/2005

下面是书的目录清单:对SAS BASE部分有非常详细细节讲解。saslist.net

Lists
12 (1)
Introduction 13 (2)
The Log
15 (8)
Running a SAS Program
Messages and Debugging
Program Files
23 (4)
Startup
27 (6)
Batch Mode
Interactive Mode
Special Modes
SAS Processes
System Options
33 (12)
Setting System Options
Obtaining Values of System Options
Libraries
45 (4)
Dataset Options
49 (4)
Selecting Data
Other Uses for Dataset Options
Errors
Indexes
53 (4)
Actions on SAS Datasets
57 (10)
Creating
Describing
Changing
Copying
Deleting
Data Type and Length
67 (6)
Data Type
Length
Setting Data Type and Length
Using Data Types
Determining Lengths for Variables
Text Data Files
73 (6)
Filerefs
Input Text Data
Output Text Data
Data Fields
79 (8)
Scientific Notation
Signed Numerals
Implied Decimal Points
Measured Strings
Variable Number of Fields
Continuation Character
Delimited Files
87 (6)
Hierarchical Files
93 (6)
Input
Output
Binary Files
99 (6)
Binary Files
Binary Fields
Binhex
Value Formats
105 (4)
Value Informats
109 (4)
Picture Formats for Numbers
113 (4)
Format Catalogs and Control Datasets
117 (10)
Format Catalogs
Control Datasets
Time
127 (6)
Informats and Formats for Time
133 (4)
International Date Formats
137 (2)
Picture Formats for Time
139 (4)
Validation
143 (10)
Informats and Error Controls
Validation Logic and Exception Reporting
Integrity Constraints
Strings
153 (14)
Testing Strings
String Transformations
Substrings
Translation and Encoding
Measuring Strings
Advanced String Processing
Parsing
167 (4)
Variable-Length Strings
171 (4)
Terminated Strings
Measured Strings
Pascal Strings
Foreign Data Types
175 (8)
Binary Integers
Union
Structure
Pseudo-Array
Set of Characters
Codes
183 (10)
Code I/O
Digit Strings as Packed Hexadecimal
Punctuation
Parts of Codes
Conversions
Serial Numbers
Check Digits
Text Encryption
193 (4)
Character Substitution
Transposition
Discrete Binary Encoding
197 (6)
Bitfields
203 (6)
Bit Testing
Numeric Bitfields
Numeric Bit Testing
Bitwise Functions
Numeric Effects
209 (6)
Rounding
Range Effects
Percents
Testing Numbers
Missing Values
215 (6)
Boolean Values
221 (8)
Financial Calculations
229 (6)
Time Conversions
235 (10)
Points in Time
Duration
Clock Issues
Spherical Coordinates
Time Arithmetic
245 (8)
Extending the Observation Loop
253 (4)
Comparisons
Rounding
Time Loops
Time Interval Arithmetic
Age
Loops
257 (6)
Character Loops
263 (6)
Subsetting and Sampling
269 (8)
Subsetting
Sampling
SQL
277 (4)
Sorting
281 (8)
Groups
289 (8)
By Groups in Proc Steps
Formatted Grouping
Class Groups
Processing Groups in a Data Step
Incomplete Data
297 (6)
Key Combinations and Sequences
Interpolation
Transposing
303 (8)
Transposing in a Data Step
The Transpose Proc
Frequency Tables
311 (10)
Descriptive Statistics
321 (8)
Creating Summary Data
Degrees of Freedom, Weights, and the Variance Divisor
Summary Statistics in Computations
329 (4)
Type Conversion
333 (4)
Automatic Type Conversion
Functions for Type Conversion
Changing the Data Type of a Variable
Combining Data
337 (6)
Table Lookup
343 (6)
Boolean Lookup
Comparison Lookup
Lookup Based on Index Value
Lookup Functions
Table Lookup From SAS Data Files
349 (8)
Indexed Lookup
Lookup Based on Observation Numbers
Sort-Merge
Other Lookup Techniques
Value Formats for Table Lookup
357 (6)
Validation
Control Dataset
Multiple Variables
Calendars
363 (10)
Multiple Text Files
373 (8)
Input
Output
Single-Step Techniques for Input
Print Files
381 (10)
Print Files in the SAS Environment
Title and Footnote Lines
Print Output in Data Steps
Print Output in Proc Steps
Table Reports
391 (10)
Data Step Report Programming
401 (10)
Data Step Views
411 (4)
Macro Variables
415 (6)
Assigning Values
Obtaining Values
Macros
421 (10)
Parameters
Macro Control Flow
Managing Macros
Macro Programming
431 (6)
Macro Expressions
Macro Functions
Macro Statements
Avoiding Errors in Macro Programming
Program Parameters
437 (4)
Generating Program Statements
441 (6)
Control Reports
447 (4)
Cleaning Up a Program
451 (8)
Macro Cleanup
459 (4)
Efficiency
463 (14)
Priorities
Run Time
Memory
Sorting
Saving Storage Space
477 (8)
Observation Length
Number of Observations
Saving and Deleting Data
Compression
485 (4)
Porting Files and Data
489 (6)
Porting SAS Programs
495 (6)
Dependencies
Isolating Nonportable Code
Translating Programs
501 (8)
Translating to C
Translating From Other Languages to SAS
Style
509 (4)
Data Step Windows
513 (12)
Defining a Window
Displaying a Window
Fields
Interaction
Data Entry and Editing
Status Dialog
Animated Progress Bar
Macro Windows
525 (4)
Interactive Line Mode
529 (2)
Menu Bars
531 (8)
Command Processing
539 (2)
Text Processing
541 (12)
Text Expressions
Names and Alphabetic Keys
Words
Name Matching
Text Analysis
553 (6)
Random Numbers
559 (4)
Random Number Generators, Streams, and Seeds
Random Number Functions and Call Routine
Distributions for Random Numbers
Simulations
563 (6)
Legacy Systems
569 (6)
Data Center Files
Y2K
Other SAS Versions
Database Applications
575 (4)
Database Design
Database Programming
Metadata
Client-Server Design
579 (4)
SAS/Connect
Control Level
Classic Problems
583 (8)
Prime Number Sieve
Life
Global Distances
Afterword 591 (2)
Index 593

需要说明的是,这本书是2005年出的,那时候只有SAS9,随着新的SAS版本9.1,9.2的推出,很多功能在新版本里面有更容易简单的做法,期待此本书新版并且在中国大陆可以购买。saslist.net

原创文章: ”一本得不到的SAS书“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/84


20 9月 10 SAS中文书籍清单 1991-2010年


目前在中国出版的1991至2010年出版的SAS中文书籍(部分列表)

序 号 出版年份 题 名 著 者

1 2010 SAS统计分析标准教程 杜强

2 2010 SAS统计分析与应用从入门到精通 汪海波

3 2010 SAS编程与数据挖掘商业案例 姚志勇

4 2010 SAS统计分析教程 胡良平

5 2010 SAS实验设计与统计分析 胡良平

6 2009 SAS统计分析从入门到精通 阮敬

7 2009 多层统计分析模型:SAS与应用 王济川,谢海义,Fisher.J.

8 2009 金融计量学: 基于SAS的金融实证研究 宋军

9 2009 时间序列分析与SAS应用 肖枝洪

10 2009 SAS与现代经济统计分析 岳朝龙

11 2009 SAS软件实用教程 张瑛

12 2008 社会统计分析及SAS应用教程 蔡建瓴

13 2008 SAS数据分析系统教程 陈颖

14 2008 SAS统计分析应用 董大钧

15 2008 统计分析系统SAS与SPSS 何宁

16 2008 多元统计及SAS应用 余家林

17 2008 SAS数据分析范例 范金城

18 2008 SAS数据挖掘与分析 周爽

19 2007 SAS与统计分析 胡希远

20 2007 经验会计与财务研究方法: 原理、应用及SAS实现 鲁桂华

21 2007 SAS软件与统计应用教程 汪远征

22 2007 医学统计学及SAS应用 王炳顺

23 2007 概率统计及SAS应用 余家林

24 2007 金融计算与建模: 理论、算法与SAS程序 朱世武

25 2007 SAS统计软件 周仁郁

26 2006 SAS8.2统计软件应用教程 贺佳,陆健

27 2006 SAS社会统计应用教程 蔡建琼,朱志海,朱秀萍,阮桂海

28 2006 SAS应用统计实验 邵建利

29 2006 SAS统计分析教程 唐燕琼

30 2006 医用SAS统计分析 金丕焕,苏炳华,贺佳

31 2006 SAS社会统计实用教程 蔡建平

32 2006 数据分析方法和SAS系统 邓祖新

33 2006 SAS统计分析及应用 黄燕

34 2006 统计软件教程: SAS系统与S语言 李东风

35 2006 管理统计学和SAS软件应用 刘顺忠

36 2006 SAS社会统计应用教程 阮桂海

37 2005 统计分析系统SAS 何宁

38 2005 计量经济分析软件: EViews SAS简明上机指南 潘省初

39 2005 统计分析与SAS软件 黄平,梁满发

40 2005 SAS统计分析 沈其君

41 2004 SAS for Windows (v8) 统计分析系统教程新编 洪楠

42 2004 统计分析方法: SAS实例精选 曲庆云

43 2004 SAS 8.2统计应用教程 薛富波

44 2004 重复测量资料分析方法与SAS程序 余松林

45 2004 中医临床研究设计与SAS编程统计分析 胡立胜,周强

46 2004 基于SAS系统的金融计算 朱世武

47 2003 SAS8.X经济统计 樊欣,邵谦谦

48 2003 医学统计学习题与SAS实验 郭秀花

49 2003 SAS统计分析实用大全 阮桂海

50 2003 统计分析应用教程: SPSS, LISREL&SAS实例精选 阮桂海

51 2003 SAS系统与经济统计分析 岳朝龙

52 2003 SAS编程技术与金融数据处理 朱世武

53 2002 分类数据的统计分析及SAS编程 刘勤,金丕焕

54 2002 SAS系统和数据分析 邓祖新

55 2002 社会经济定量研究与SPSS和SAS的应用 骆克任

56 2002 SAS程序设计 王惠群

57 2002 统计应用软件: EXCEL和SAS 朱建中

58 2001 SAS系统•Base_SAS软件使用手册 高惠璇

59 2001 SAS基础及统计实例教程 胡小平,王长发

60 2001 实用统计方法与SAS系统 高惠璇

61 2001 Windows SAS 6.12 & 8.0实用统计分析教程 胡良平

62 2001 SAS统计分析 沈其君

63 2000 SAS软件与应用统计 王吉利,张尧庭

64 2000 世界统计与分析全才SAS系统应用开发指南 彭昭英

65 2000 现代统计学与SAS应用 胡良平

66 1999 多元统计分析与软件SAS 朱道元等

67 1998 SAS系统SAS/ETS软件使用手册 高惠璇

68 1998 SAS最优化软件速成 倪勤

69 1998 SAS及应用 裴喜春

70 1997 SAS系统BaseSAS软件使用手册 高惠璇

71 1997 SAS系统. SAS/STAT软件使用手册 高惠璇

72 1997 SAS基础教程 美国SAS软件研究所

73 1996 统计分析系统SAS软件实用教程 惠大丰

74 1996 SAS/PC统计分析软件实用技术 卢纹岱,金水高

75 1996 现代统计学与SAS应用 胡良平

76 1996 SAS应用程式之资料处理 梁德馨

77 1995 SAS系统与基础统计分析 高惠璇

78 1995 SAS/PC统计分析与实务应用 林秀娟

79 1995 SAS for Windows统计分析入门: SAS/ASSIST自动程式产生的视窗 张绍勋

80 1995 SAS for Windows统计分析: 高等统计 张绍勋

81 1995 SAS for Windows程序语法 张绍勋

82 1995 SAS For Windows统计分析: 初等统计 张绍勋

83 1993 SAS–统计分析软件应用指南 董大钧

84 1992 SAS统计过程指导 (美)SAS研究所

85 1991 医学统计方法与SAS应用技巧 胡良平

以上列出来部分1991年至2010年中国出版的SAS中文书籍目录,一共85本。上面的书,大部分在国内学SAS的人估计都读过一两本,我有幸见过一部分的书,质量不好评论,但在内容上感觉统计应用比例非常高,且雷同的颇多。通览这个目录,我有如下的几个大致印象:
  • 纯编程仅仅是那本2002年台湾作者王惠群的《SAS程式设计》,大陆名为《SAS程序设计》的那本。1996年的梁德馨《 SAS应用程式之资料处理》,应该也是台湾作者,无缘看到真本,从名字推算应该也属于纯SAS编程。《SAS程序设计》有关SAS编程,内容较浅显,适合初学者学习使用。
  • 最新和2010年出版的姚志勇《 SAS编程与数据挖掘商业案例 》也算得上是一本介绍SAS编程的书,后几章结合实际讲了商业案例内容。
  • 涉及到SAS编程知识比例较高的有2003年出版的朱世武编著的《 SAS编程技术与金融数据处理》和他的其他几本书,所有内容都是围绕金融数据展开的,学金融的不要错过;
  • 1998年倪勤编著科学出版社出版的《SAS最优化软件速成》介绍OR优化模块,里面是倪勤论文的一部分,对于搞优化的人是本难得到好书;
  • 其他多为涉及到SAS/STAT模块,着重于用于多元统计分析在各行各业中应用,这部分书籍尽管有很多雷同部分,但也不乏好书,比如作者黄燕2006年出版的 《SAS统计分析及应用 》,2008余家林出版的《多元统计及SAS应用 》,和胡良平老师的几本书讲到用SAS如何进行统计分析应用,如果你正好需要学习这方面的知识,这几本书是非常值得推荐。老的书如高惠璇编著的几本恐怕是国内SAS统计早期启蒙书了,很经典,可惜太老了,不容易得到。

从目前SAS中文书籍来说,如果你想做一名SAS程序员或者以SAS编程作为你的职业的话,仅仅看中文书是远远不够的,熟读外文书是不可避免的(外文书籍介绍推荐将在后面给出)。因此对于英文不是很好的人来说,学SAS确实是件痛苦的事情。

2011年8月26日补充:  84 1992 SAS统计过程指导 (美)SAS研究所 这本书就是 《SAS User‘s Guide:Statistics》原版的部分翻译。

原创文章: ”SAS中文书籍清单 1991-2010年“,转载请注明: 转自SAS资源资讯列表

本文链接地址: http://saslist.net/archives/79