Functions and Arguments for %SYSFUNC

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))