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