Data Set Options by Category

Categories and Descriptions of Data Set Options
Category Data Set Option Description

Data Set Control ALTER= Assigns an alter password to a SAS file and enables access to a password-protected SAS file

BUFNO= Specifies the number of buffers for processing a SAS data set

BUFSIZE= Specifies a permanent buffer size for output SAS data sets

CNTLLEV= Specifies the level of shared access to SAS data sets

COMPRESS= Compresses observations in an output SAS data set

DLDMGACTION= Specifies what type of action to take when a SAS data set in a SAS data library is detected as damaged

ENCRYPT= Encrypts SAS data files

GENMAX= Requests generations for a data set and specifies the maximum number of versions

GENNUM= References a specific generation of a data set

INDEX= Defines indexes when a SAS data set is created

LABEL= Specifies a label for the data set

OUTREP= Specifies an operating environment's requirements vector for an output file

PW= Assigns a read, write, or alter password to a SAS file and enables access to a password-protected SAS file

PWREQ= Controls the pop up of a requestor window for a data set password

READ= Assigns a read password to a SAS file and enables access to a read-protected SAS file

REPEMPTY= Controls replacement of like-named temporary or permanent SAS data sets when the new one is empty.

REPLACE= Controls replacement of like-named temporary or permanent SAS data sets

REUSE= Specifies whether new observations are written to free space in compressed SAS data sets

SORTEDBY= Specifies how the data set is currently sorted

TOBSNO= Specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server

TRANTAB= Specifies a translation table for character conversions

TYPE= Specifies the data set type for a specially structured SAS data set

WRITE= Assigns a write password to a SAS file and enables access to a write-protected SAS file

Miscellaneous FILECLOSE= Specifies how a tape is positioned when a SAS file on the tape is closed

Observation Control FIRSTOBS= Causes processing to begin at a specified observation

IN= Creates a variable that indicates whether the data set contributed data to the current observation

OBS= Causes processing to end with the nth observation

POINTOBS= Controls whether a compressed data set may be processed with random access (by observation number) rather than sequential access only

WHERE= Selects observations that meet the specified condition

WHEREUP= Specifies whether to evaluate added observations and modified observations against a WHERE expression

User Control of SAS Index Usage IDXNAME= Directs SAS to use a specific index to satisfy the conditions of a WHERE expression

IDXWHERE= Overrides the SAS System decision about whether to use an index to satisfy the conditions of a WHERE expression

Variable Control DROP= Excludes variables from processing or from output SAS data sets

KEEP= Specifies variables for processing or for writing to output SAS data sets

RENAME= Changes the name of a variable

***Categories and Descriptions of Data Set Options***
Category	Data Set Option	Description
Data Set Control	ALTER=	Assigns an alter password to a SAS file and enables access to a password-protected SAS file
	BUFNO=	Specifies the number of buffers for processing a SAS data set
	BUFSIZE=	Specifies a permanent buffer size for output SAS data sets
	CNTLLEV=	Specifies the level of shared access to SAS data sets
	COMPRESS=	Compresses observations in an output SAS data set
	DLDMGACTION=	Specifies what type of action to take when a SAS data set in a SAS data library is detected as damaged
	ENCRYPT=	Encrypts SAS data files
	GENMAX=	Requests generations for a data set and specifies the maximum number of versions
	GENNUM=	References a specific generation of a data set
	INDEX=	Defines indexes when a SAS data set is created
	LABEL=	Specifies a label for the data set
	OUTREP=	Specifies an operating environment's requirements vector for an output file
	PW=	Assigns a read, write, or alter password to a SAS file and enables access to a password-protected SAS file
	PWREQ=	Controls the pop up of a requestor window for a data set password
	READ=	Assigns a read password to a SAS file and enables access to a read-protected SAS file
	REPEMPTY=	Controls replacement of like-named temporary or permanent SAS data sets when the new one is empty.
	REPLACE=	Controls replacement of like-named temporary or permanent SAS data sets
	REUSE=	Specifies whether new observations are written to free space in compressed SAS data sets
	SORTEDBY=	Specifies how the data set is currently sorted
	TOBSNO=	Specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server
	TRANTAB=	Specifies a translation table for character conversions
	TYPE=	Specifies the data set type for a specially structured SAS data set
	WRITE=	Assigns a write password to a SAS file and enables access to a write-protected SAS file
Miscellaneous	FILECLOSE=	Specifies how a tape is positioned when a SAS file on the tape is closed
Observation Control	FIRSTOBS=	Causes processing to begin at a specified observation
	IN=	Creates a variable that indicates whether the data set contributed data to the current observation
	OBS=	Causes processing to end with the nth observation
	POINTOBS=	Controls whether a compressed data set may be processed with random access (by observation number) rather than sequential access only
	WHERE=	Selects observations that meet the specified condition
	WHEREUP=	Specifies whether to evaluate added observations and modified observations against a WHERE expression
User Control of SAS Index Usage	IDXNAME=	Directs SAS to use a specific index to satisfy the conditions of a WHERE expression
	IDXWHERE=	Overrides the SAS System decision about whether to use an index to satisfy the conditions of a WHERE expression
Variable Control	DROP=	Excludes variables from processing or from output SAS data sets
	KEEP=	Specifies variables for processing or for writing to output SAS data sets
	RENAME=	Changes the name of a variable

Chapter Contents
Previous
Next
Top of Page