This appendix provides summary descriptions and
syntax for selected functions that can be used with the %SYSFUNC function.
These functions are documented in the
SAS Language Reference: Dictionary.
The following table shows the syntax for selected functions that can
be used with the %SYSFUNC function. This is not a complete list of the functions
that can be used with %SYSFUNC. For a list of functions that cannot be used
with %SYSFUNC, see SAS Functions Not Available with %SYSFUNC and %QSYSFUNC.
Functions and Arguments for %SYSFUNC
Function |
Description and Syntax |
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 specified information items 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))
|
DREAD |
returns the name of a directory member. %SYSFUNC(DREAD(directory-id,nval))
|
DROPNOTE |
deletes a note marker from a SAS data set or an external file. %SYSFUNC(DROPNOTE(data-set-id|file-id,note-id))
|
DSNAME |
returns the data set name associated with a data set identifier.
%SYSFUNC(DSNAME(<data-set-id>))
|
EXIST |
verifies the existence of a SAS library member. %SYSFUNC(EXIST(member-name<,member-type>))
|
FAPPEND |
appends a record to the end of an external file. %SYSFUNC(FAPPEND(file-id<,cc>))
|
FCLOSE |
closes an external file, directory, or directory member. %SYSFUNC(FCLOSE(file-id))
|
FCOL |
returns the current column position in the File Data Buffer (FDB)
%SYSFUNC(FCOL(file-id))
|
FDELETE |
deletes an external file. %SYSFUNC(FDELETE(fileref))
|
FETCH |
reads the next nondeleted observation from a SAS data set into the Data
Set Data Vector (DDV). %SYSFUNC(FETCH(data-set-id<,NOSET>))
|
FETCHOBS |
reads a specified observation from a SAS data set into the DDV.
%SYSFUNC(FETCHOBS(data-set-id,obs-number<,options>))
|
FEXIST |
verifies the existence of an external file associated with a fileref.
%SYSFUNC(FEXIST(fileref))
|
FGET |
copies data from the FDB. %SYSFUNC(FGET(file-id,cval<,length>))
|
FILEEXIST |
verifies the existence of an external file by its physical name.
%SYSFUNC(FILEEXIST(file-name))
|
FILENAME |
assigns or deassigns a fileref for an external file, directory, or output
device. %SYSFUNC(FILENAME(fileref,file-name<,device<,host-options<,dir-ref>>>))
|
FILEREF |
verifies that a fileref has been assigned for the current SAS session.
%SYSFUNC(FILEREF(fileref))
|
FINFO |
returns a specified information item for a file. %SYSFUNC(FINFO(file-id,info-item))
|
FNOTE |
identifies the last record that was read. %SYSFUNC(FNOTE(file-id))
|
FOPEN |
opens an external file. %SYSFUNC(FOPEN(fileref<,open-mode<,record-length<,record-format>>>))
|
FOPTNAME |
returns the name of an information item for an external file. %SYSFUNC(FOPTNAME(file-id,nval))
|
FOPTNUM |
returns the number of information items available for an external file.
%SYSFUNC(FOPTNUM(file-id))
|
FPOINT |
positions the read pointer on the next record to be read. %SYSFUNC(FPOINT(file-id,note-id))
|
FPOS |
sets the position of the column pointer in the FDB. %SYSFUNC(FPOS(file-id,nval))
|
FPUT |
moves data to the FDB of an external file starting at the current column
position. %SYSFUNC(FPUT(file-id,cval))
|
FREAD |
reads a record from an external file into the FDB. %SYSFUNC(FREAD(file-id))
|
FREWIND |
positions the file pointer at the first record. %SYSFUNC(FREWIND(file-id))
|
FRLEN |
returns the size of the last record read, or the current record size
for a file opened for output. %SYSFUNC(FRLEN(file-id))
|
FSEP |
sets the token delimiters for the FGET function. %SYSFUNC(FSEP(file-id,cval))
|
FWRITE |
writes a record to an external file. %SYSFUNC(FWRITE(file-id<,cc>))
|
GETOPTION |
returns the value of a SAS system or graphics option. %SYSFUNC(GETOPTION(option-name<,reporting-options<,...>>))
|
GETVARC |
assigns the value of a SAS data set variable to a character DATA step
or macro variable. %SYSFUNC(GETVARC(data-set-id,var-num))
|
GETVARN |
assigns the value of a SAS data set variable to a numeric DATA step
or macro variable. %SYSFUNC(GETVARN(data-set-id,var-num))
|
LIBNAME |
assigns or deassigns a libref for a SAS library. %SYSFUNC(LIBNAME(libref<,SAS-data-library<,engine<,options>>>))
|
LIBREF |
verifies that a libref has been assigned. %SYSFUNC(LIBREF(libref))
|
MOPEN |
opens a directory member file. %SYSFUNC(MOPEN(directory-id,member-name<open-mode<,record-length<,record-format>>>))
|
NOTE |
returns an observation ID for current observation of a SAS data set.
%SYSFUNC(NOTE(data-set-id))
|
OPEN |
opens a SAS data file. %SYSFUNC(OPEN(<data-file-name<,mode>>))
|
PATHNAME |
returns the physical name of a SAS library or an external file.
%SYSFUNC(PATHNAME(fileref))
|
POINT |
locates an observation identified by the NOTE function. %SYSFUNC(POINT(data-set-id,note-id))
|
REWIND |
positions the data set pointer to the beginning of a SAS data set.
%SYSFUNC(REWIND(data-set-id))
|
SPEDIS |
returns a number for the operation required to change an incorrect
keyword in a WHERE clause to a correct keyword. %SYSFUNC(SPEDIS(query,keyword))
|
SYSGET |
returns the value of the specified host environment variable. %SYSFUNC(sysget(host-variable))
|
SYSMSG |
returns the error or warning message produced by the last function
that attempted to access a data set or external file. %SYSFUNC(SYSMSG())
|
SYSRC |
returns the system error number or exit status of the entry most recently
called. %SYSFUNC(SYSRC())
|
VARFMT |
returns the format assigned to a data set variable. %SYSFUNC(VARFMT(data-set-id,var-num))
|
VARINFMT |
returns the informat assigned to a data set variable. %SYSFUNC(VARINFMT(data-set-id,var-num))
|
VARLABEL |
returns the label assigned to a data set variable. %SYSFUNC(VARLABEL(data-set-id,var-num))
|
VARLEN |
returns the length of a data set variable. %SYSFUNC(VARLEN(data-set-id,var-num))
|
VARNAME |
returns the name of a data set variable. %SYSFUNC(VARNAME(data-set-id,var-num))
|
VARNUM |
returns the number of a data set variable. %SYSFUNC(VARNUM(data-set-id,var-name))
|
VARTYPE |
returns the data type of a data set variable. %SYSFUNC(VARTYPE(data-set-id,var-num))
|