Data Set Options Syntax Listed by Category

Data Set Control

A B C D E F G I L O P R S T U W

Name
Syntax and Description
AGGREGATE= YES | NO
Specifies whether detailed data or aggregated data should be retrieved.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
ALTER=alter-password
Specifies a password for a SAS file that prevents users from replacing or deleting the file, but permits Read and Write access.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
ALTER= alter-password
Specifies a password for a SAS file that prevents users from replacing or deleting the file, but permits read and write access.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
ALTER= alter-password
Assigns an ALTER password to a SAS file that prevents users from replacing or deleting the file, and enables access to a read- and write-protected file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
BUFNO=n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated for processing a SAS data set.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
BUFNO= n | nK | hexX | MIN | MAX
Specifies the number of buffers to be allocated for processing a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
BUFSIZE=n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
BUFSIZE= 0 | n | nK
Specifies the size of a permanent buffer page for an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
BUFSIZE= n | nK | nM | nG | hexX | MAX
Specifies the size of a permanent buffer page for an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
CNTLLEV=LIB | MEM | REC
Specifies the level of shared access to a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
COMPRESS=NO | YES | CHAR | BINARY
Specifies how observations are compressed in a new output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
DLDMGACTION=FAIL | ABORT | REPAIR | NOINDEX | PROMPT
Specifies the action to take when a SAS data set in a SAS library is detected as damaged.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
ENCODING= ANY | ASCIIANY | EBCDICANY | encoding-value
Overrides the encoding to use for reading or writing a SAS data set.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
ENCRYPT=YES | NO
Specifies whether to encrypt an output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
EXPCOLUMNLEN= column-length
Specifies the default length of the SAS character column when a data item defined with expressions is encountered.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
EXTENDOBSCOUNTER=NO | YES
Specifies whether to extend the maximum observation count in a new output SAS data file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
FILTER=(<NOT> filter-1 < ... Boolean-operator <NOT> filter-n >)
Uses the filters that are defined in an information map to specify criteria for subsetting a result set.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
GENMAX= number-of-generations
Requests generations for a new data set, modifies the number of generations for an existing data set, and specifies the maximum number of versions.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
GENNUM= integer
Specifies a particular generation of a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
INDEX=(index-specification-1 ...< index-specification-n > )
Defines an index for a new output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
LABEL='label'
Specifies a label for a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
OBSBUF= n
Determines the size of the view buffer for processing a DATA step view.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
OUTREP= format
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
Specifies the data representation for the output SAS data set.
Product: Base SAS
Document: SAS 9.3 National Language Support (NLS): Reference Guide
PW=password
Assigns a READ, WRITE, or ALTER password to a SAS file, and enables access to a password-protected SAS file.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
PW= password
Assigns a READ, WRITE, and ALTER password to a SAS file, and enables access to a password-protected SAS file.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
PWREQ=YES | NO
Specifies whether to display a dialog box to enter a SAS data set password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
READ= read-password
Assigns a READ password to a SAS file that prevents users from reading the file, unless they enter the password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
READBUFF= integer
Specifies the number of rows to hold in memory for input into SAS.
Product: Base SAS
Document: Base SAS 9.3 Guide to Information Maps
REPEMPTY=YES | NO
Specifies whether a new, empty data set can overwrite an existing SAS data set that has the same name.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
REPLACE=NO | YES
Specifies whether a new SAS data set that contains data can overwrite an existing data set that has the same name.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
REUSE=NO | YES
Specifies whether new observations can be written to freed space in compressed SAS data sets.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
ROLE= FACT | DIMENSION | DIM
Identifies the fact table for a star schema join.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
SORTEDBY= by-clause </ collate-name > | _NULL_
Specifies how a data set is currently sorted.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
SPILL=YES | NO
Specifies whether to create a spill file for non-sequential processing of a DATA step view.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
TOBSNO= n
Specifies the number of observations to send in a client/server transfer.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
TYPE= data-set-type
Specifies the data set type for a specially structured SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
USEDIRECTIO=
Turns on direct file I/O for a library that contains the file to which the ENABLEDIRECTIO option has been applied.
Product: Base SAS
Document: SAS 9.3 Companion for UNIX Environments
WRITE= write-password
Assigns a WRITE password to a SAS file that prevents users from writing to a file, unless they enter the password.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference

Miscellaneous

F

Name
Syntax and Description
FILECLOSE= DISP | LEAVE | REREAD | REWIND | FREE
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS 9.3 Companion for z/OS
FILECLOSE=DISP | LEAVE | REREAD | REWIND
Specifies how a tape is positioned when a SAS data set is closed.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference

Observation Control

F I O P W

Name
Syntax and Description
FIRSTOBS= n| nK | nM | nG | hexX | MIN | MAX
Specifies the first observation that SAS processes in a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
IN= variable
Creates a Boolean variable that indicates whether the data set contributed data to the current observation.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
OBS= n | nK | nM | nG | nT | hexX | MIN | MAX
Specifies the last observation that SAS processes in a data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
POINTOBS=YES | NO
Specifies whether SAS creates compressed data sets whose observations can be randomly accessed or sequentially accessed.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
WHERE=(where-expression-1<logical-operator where-expression-n>)
Specifies specific conditions to use to select observations from a SAS data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
WHEREUP=NO | YES
Specifies whether to evaluate new observations and modified observations against a WHERE expression.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference

User Control of SAS Index Usage

I

Name
Syntax and Description
IDXNAME= index-name
Directs SAS to use a specific index to match the conditions of a WHERE expression.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
IDXWHERE=YES | NO
Specifies whether SAS uses an index search or a sequential search to match the conditions of a WHERE expression.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference

Variable Control

D K R

Name
Syntax and Description
DROP= variable-1 <...variable-n>
For an input data set, excludes the specified variables from processing; for an output data set, excludes the specified variables from being written to the data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
KEEP= variable-1 <...variable-n>
For an input data set, specifies the variables to process; for an output data set, specifies the variables to write to the data set.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference
RENAME=(old-name-1=new-name-1 < ...old-name-n=new-name-n > )
Changes the name of a variable.
Product: Base SAS
Document: SAS 9.3 Data Sets: Reference