可以在%SYSFUNC中使用的SAS函数一览表-经管之家官网！

本文来源于西铁房临床试验爱好者中心（本帖最后发表人：西铁房版主Stanley)
转载请保留此链接:
http://www.clinicaltrialfans.com/posts/list/470.page
ATTRC returns the value of a character attribute for a SAS data set. %SYSFUNC(ATTRC(data-set-id,attr-name))
ATTRN returns the value of a numeric attribute for specified SAS data set. %SYSFUNC(ATTRN(data-set_id,attr-name))
CEXIST verifies the existence of a SAS catalog or SAS catalog entry. %SYSFUNC(CEXIST(entry <, 'U'>))
CLOSE closes a SAS data set. %SYSFUNC(CLOSE(data-set-id))
CUROBS returns the number of the current observation. %SYSFUNC(CUROBS(data-set-id))
DCLOSE closes a directory. %SYSFUNC(DCLOSE(directory-id))
DINFO returns a specified information item for a directory. %SYSFUNC(DINFO(directory-id,info-items))
DNUM returns the number of members in a directory. %SYSFUNC(DNUM(directory-id))
DOPEN opens a directory. %SYSFUNC(DOPEN(fileref))
DOPTNAME returns a specified directory attribute. %SYSFUNC(DOPTNAME(directory-id,nval))
DOPTNUM returns the number of information items available for a directory. %SYSFUNC(DOPTNUM(directory-id))
DREADreturns the name of a directory member. %SYSFUNC(DREAD(directory-id,nval))
DROPNOTEdeletes a note marker from a SAS data set or an external file. %SYSFUNC(DROPNOTE(data-set-id|file-id,note-id))
DSNAMEreturns the data set name associated with a data set identifier. %SYSFUNC(DSNAME(<dsid>))
EXISTverifies the existence of a SAS data library member. %SYSFUNC(EXIST(member-name<,member-type>))
FAPPENDappends a record to the end of an external file. %SYSFUNC(FAPPEND(file-id<,cc>))
FCLOSEcloses an external file, directory, or directory member. %SYSFUNC(FCLOSE(file-id))
FCOLreturns the current column position in the File Data Buffer (FDB) %SYSFUNC(FCOL(file-id))
FDELETEdeletes an external file. %SYSFUNC(FDELETE(fileref))
FETCHreads the next nondeleted observation from a SAS data set into Data Set Data Vector (DDV). %SYSFUNC(FETCH(data-set-id<,'NOSET'>))
FETCHOBSreads a specified observation from a SAS data set into the DDV. %SYSFUNC(FETCHOBS(data-set-id,obs-number<,options>))
FEXISTverifies the existence of an external file associated with a fileref. %SYSFUNC(FEXIST(fileref))
FGETcopies data from the FDB. %SYSFUNC(FGET(file-id,cval<,length>))
FILEEXISTverifies the existence of an external file by its physical name. %SYSFUNC(FILEEXIST(file-name))
FILENAMEassigns or deassigns a fileref for an external file, directory, or output device. %SYSFUNC(FILENAME(fileref,filename<,device<,hostoptions<,dir-ref>>>))
FILEREFverifies that a fileref has been assigned for the current SAS session. %SYSFUNC(FILEREF(fileref))
FINFOreturns a specified information item for a file. %SYSFUNC(FINFO(file-id,info-item))
FNOTEidentifies the last record that was read. %SYSFUNC(FNOTE(file-id))
FOPENopens an external file. %SYSFUNC(FOPEN(fileref<,open-mode<,record-length<,record-format>>>))
FOPTNAMEreturns the name of an information item for an external file. %SYSFUNC(FOPTNAME(file-id,nval))
FOPTNUMreturns the number of information items available for an external file. %SYSFUNC(FOPTNUM(file-id))
FPOINTpositions the read pointer on the next record to be read. %SYSFUNC(FPOINT(file-id,note-id))
FPOSsets the position of the column pointer in the FDB. %SYSFUNC(FPOS(file-id,nval))
FPUTmoves data to the FDB of an external file starting at the current column position. %SYSFUNC(FPUT(file-id,cval))
FREADreads a record from an external file into the FDB. %SYSFUNC(FREAD(file-id))
FREWINDpositions the file pointer at the first record. %SYSFUNC(FREWIND(file-id))
FRLENreturns the size of the last record read, or the current record size for a file opened for output. %SYSFUNC(FRLEN(file-id))
FSEPsets the token delimiters for the FGET function. %SYSFUNC(FSEP(file-id,cval))
FWRITEwrites a record to an external file. %SYSFUNC(FWRITE(file-id<,cc>))
GETOPTIONreturns the value of a SAS system or graphics option. %SYSFUNC(GETOPTION(option-name<,reporting-options<,...>>))
GETVARCassigns the value of a SAS data set variable to a character DATA step or macro variable. %SYSFUNC(GETVARC(data-set-id,var-num))
GETVARNassigns the value of a SAS data set variable to a numeric DATA step or macro variable. %SYSFUNC(GETVARN(data-set-id,var-num))
LIBNAMEassigns or deassigns a libref for a SAS data library. %SYSFUNC(LIBNAME(libref<,SAS-data-library<,engine<,options>>>))
LIBREFverifies that a libref has been assigned. %SYSFUNC(LIBREF(libref))
MOPENopens a directory member file. %SYSFUNC(MOPEN(directory-id,member-name<open-mode<,record-length<,record-format>>>))
NOTEreturns an observation ID for current observation of a SAS data set. %SYSFUNC(NOTE(data-set-id))
OPENopens a SAS data file. %SYSFUNC(OPEN(<data-file-name<,mode>>))
PATHNAMEreturns the physical name of a SAS data library or an external file. %SYSFUNC(PATHNAME(fileref))
POINTlocates an observation identified by the NOTE function. %SYSFUNC(POINT(data-set-id,note-id))
REWINDpositions the data set pointer to beginning of a SAS data set. %SYSFUNC(REWIND(data-set-id))
SPEDISreturns a number for the operation required to change an incorrect keyword in a WHERE clause to a correct keyword. %SYSFUNC(SPEDIS(query,keyword))
SYSGETreturns the value of the specified host environment variable. %SYSFUNC(sysget(host-variable))
SYSMSGreturns the error or warning message produced by the last function that attempted to access a data set or external file. %SYSFUNC(SYSMSG())
SYSRCreturns the system error number or exit status of the entry most recently called. %SYSFUNC(SYSRC())
VARFMTreturns the format assigned to a data set variable. %SYSFUNC(VARFMT(data-set-id,var-num))
VARINFMTreturns the informat assigned to a data set variable. %SYSFUNC(VARINFMT(data-set-id,var-num))
VARLABELreturns the label assigned to a data set variable. %SYSFUNC(VARLABEL(data-set-id,var-num))
VARLENreturns the length of a data set variable. %SYSFUNC(VARLEN(datasetid,var-num))
VARNAMEreturns the name of a data set variable. %SYSFUNC(VARNAME(data-set-id,var-num))
VARNUMreturns the number of a data set variable. %SYSFUNC(VARNUM(data-set-id,var-name))
VARTYPEreturns the data type of a data set variable. %SYSFUNC(VARTYPE(data-set-id,var-num))
西铁房国际临床试验爱好者中心
http://www.clinicaltrialfans.com