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中新增和变动的函数列表（中文）：

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