SAS Companion for the OpenVMS Operating Environment

Summary Table of SAS Data Set Options

Summary of SAS Data Set Options lists both the portable data set options and the data set options that are specific to OpenVMS. It describes each option and tells whether the option can be used for a data set that has been opened for input, output, or update. The See column tells you where to look for more detailed information about an option, for example:

COMP See the description of the data set option in this section.

LR See SAS Language Reference: Dictionary.

RDB See SAS/ACCESS Software for Relational Databases: Reference (Oracle Rdb Chapter).

The table also lists the engines with which the option is valid.

Summary of SAS Data Set Options
Data Set Option Description Where Used Engines See

ALQ= specifies the allocation quantity for a data set output V6, V7, V8, CONCUR COMP

ALQMULT= specifies the multiple of pages allocated for a data set output V6, V7, V8, CONCUR COMP

ALTER= assigns an alter password to a SAS file and enables access to a password-protected SAS file input, output, update V6, V7, V8, CONCUR LR

BKS= specifies the bucket size for a data set output CONCUR COMP

BUFNO= specifies the number of buffers for processing a SAS data set input, output, update V6, V6TAPE, V7, V7TAPE, V8, V8TAPE LR

BUFSIZE= specifies permanent buffer size for output SAS data sets output V6, V6TAPE, V7, V7TAPE, V8, V8TAPE LR, COMP

CACHENUM= specifies the number of I/O data caches input, output, update V6, V7, V8 COMP

CACHESIZ= specifies the size of each I/O data cache allocated for a file input, output, update V6, V7, V8 COMP

CNTLLEV= specifies the level of shared access allowed to a SAS data set input, update V6, V7, V8, CONCUR LR, COMP

COMPRESS= compresses observations in an output SAS data set output V6, V7, V8 LR

DEQ= specifies the default file-extension quantity for a data set output, update V6, V7, V8, CONCUR COMP

DEQMULT= specifies the number of pages to extend output, update V6, V7, V8, CONCUR COMP

DLDMGACTION= specifies what type of action to take when a SAS catalog in a SAS data library is detected as damaged input, output, update
LR

DROP= excludes variables from processing or from output SAS data sets input, output, update all LR

ENCRYPT= encrypts SAS data files input, output, update V6, V6TAPE, V7, V7TAPE, V8, V8TAPE LR

FILECLOSE= specifies the volume positioning to be performed when a SAS file residing on tape is closed input, output V6TAPE, V7TAPE, V8TAPE LR, COMP

FIRSTOBS= begins processing at a specified observation input, output, update all LR

IDXNAME= directs the SAS System to use a specific index to satisfy the conditions of a WHERE expression input, output, update V7, V7TAPE, V8, V8TAPE LR

IDXWHERE= overrides the SAS System decision about whether to use an index to satisfy the conditions of a WHERE expression input, output, update V7, V7TAPE, V8, V8TAPE LR

IN= creates a variable that indicates whether a data set contributed data to the current observation input all LR

INDEX= defines indexes when creating a SAS data set input, output, update V6, V6TAPE, V7 , V7TAPE, V8, V8TAPE LR

KEEP= specifies variables for processing or writing to output SAS data sets input, output, update all LR

LABEL= specifies a label for a data set input, output, update all LR

LOCKREAD= specifies whether to read a record if a lock cannot be obtained for the record input CONCUR COMP

LOCKWAIT= indicates whether the SAS System should wait for a locked record input CONCUR COMP

MBF= specifies the multibuffer count for a data set input, output, update CONCUR COMP

OBS= specifies the last observation of a data set to process input, output, update all LR

OUTREP= specifies an operating environment's requirements vector for an output file input, output, update V7, V7TAPE, V8, V8TAPE LR

PW= assigns a read, write, or alter password to a SAS file and enables access to a password-protected SAS file input, output, update V6, V7, V8, CONCUR LR

PWREQ= controls the pop-up menu of a requestor window for a data set password input, output, update V6, V7, V8 LR

RDBLOCK= specifies whether record-level locking or table-level locking is used when updating Oracle Rdb data update V7, V8 RDB

RDBCONST= specifies when to evaluate constraints on Oracle Rdb data input, update V7, V8 RDB

READ= assigns a read password to a SAS file and enables access to a read-protected SAS file input, output, update V6, V7, V8, CONCUR LR

RENAME= changes the name of a variable input, update all LR

REPLACE= overrides the REPLACE system option output all LR

REUSE= specifies reuse of space when observations are added to a compressed data set output V6, V7, V8 LR

SORTEDBY= specifies how the data set is currently sorted input, output, update V6, V7, V8 LR

TOBSNO= specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server input, output, update V7, V8 LR

TRANTAB= specifies a translation table for character conversions input, output, update V7, V7TAPE, V8, V8TAPE LR

TYPE= specifies the data set type for input, update, and output data input output update all LR

WHERE= selects observations that meet the specified condition input all LR

WHEREUP= specifies whether to evaluate added observations and modified observations against a WHERE clause input, output, update V7, V7TAPE, V8, V8TAPE LR

WRITE= assigns a write password to a SAS file and enables access to a write-protected SAS file input, output, update V6, V7, V8, CONCUR LR

***Summary of SAS Data Set Options***
Data Set Option	Description	Where Used	Engines	See
ALQ=	specifies the allocation quantity for a data set	output	V6, V7, V8, CONCUR	COMP
ALQMULT=	specifies the multiple of pages allocated for a data set	output	V6, V7, V8, CONCUR	COMP
ALTER=	assigns an alter password to a SAS file and enables access to a password-protected SAS file	input, output, update	V6, V7, V8, CONCUR	LR
BKS=	specifies the bucket size for a data set	output	CONCUR	COMP
BUFNO=	specifies the number of buffers for processing a SAS data set	input, output, update	V6, V6TAPE, V7, V7TAPE, V8, V8TAPE	LR
BUFSIZE=	specifies permanent buffer size for output SAS data sets	output	V6, V6TAPE, V7, V7TAPE, V8, V8TAPE	LR, COMP
CACHENUM=	specifies the number of I/O data caches	input, output, update	V6, V7, V8	COMP
CACHESIZ=	specifies the size of each I/O data cache allocated for a file	input, output, update	V6, V7, V8	COMP
CNTLLEV=	specifies the level of shared access allowed to a SAS data set	input, update	V6, V7, V8, CONCUR	LR, COMP
COMPRESS=	compresses observations in an output SAS data set	output	V6, V7, V8	LR
DEQ=	specifies the default file-extension quantity for a data set	output, update	V6, V7, V8, CONCUR	COMP
DEQMULT=	specifies the number of pages to extend	output, update	V6, V7, V8, CONCUR	COMP
DLDMGACTION=	specifies what type of action to take when a SAS catalog in a SAS data library is detected as damaged	input, output, update		LR
DROP=	excludes variables from processing or from output SAS data sets	input, output, update	all	LR
ENCRYPT=	encrypts SAS data files	input, output, update	V6, V6TAPE, V7, V7TAPE, V8, V8TAPE	LR
FILECLOSE=	specifies the volume positioning to be performed when a SAS file residing on tape is closed	input, output	V6TAPE, V7TAPE, V8TAPE	LR, COMP
FIRSTOBS=	begins processing at a specified observation	input, output, update	all	LR
IDXNAME=	directs the SAS System to use a specific index to satisfy the conditions of a WHERE expression	input, output, update	V7, V7TAPE, V8, V8TAPE	LR
IDXWHERE=	overrides the SAS System decision about whether to use an index to satisfy the conditions of a WHERE expression	input, output, update	V7, V7TAPE, V8, V8TAPE	LR
IN=	creates a variable that indicates whether a data set contributed data to the current observation	input	all	LR
INDEX=	defines indexes when creating a SAS data set	input, output, update	V6, V6TAPE, V7 , V7TAPE, V8, V8TAPE	LR
KEEP=	specifies variables for processing or writing to output SAS data sets	input, output, update	all	LR
LABEL=	specifies a label for a data set	input, output, update	all	LR
LOCKREAD=	specifies whether to read a record if a lock cannot be obtained for the record	input	CONCUR	COMP
LOCKWAIT=	indicates whether the SAS System should wait for a locked record	input	CONCUR	COMP
MBF=	specifies the multibuffer count for a data set	input, output, update	CONCUR	COMP
OBS=	specifies the last observation of a data set to process	input, output, update	all	LR
OUTREP=	specifies an operating environment's requirements vector for an output file	input, output, update	V7, V7TAPE, V8, V8TAPE	LR
PW=	assigns a read, write, or alter password to a SAS file and enables access to a password-protected SAS file	input, output, update	V6, V7, V8, CONCUR	LR
PWREQ=	controls the pop-up menu of a requestor window for a data set password	input, output, update	V6, V7, V8	LR
RDBLOCK=	specifies whether record-level locking or table-level locking is used when updating Oracle Rdb data	update	V7, V8	RDB
RDBCONST=	specifies when to evaluate constraints on Oracle Rdb data	input, update	V7, V8	RDB
READ=	assigns a read password to a SAS file and enables access to a read-protected SAS file	input, output, update	V6, V7, V8, CONCUR	LR
RENAME=	changes the name of a variable	input, update	all	LR
REPLACE=	overrides the REPLACE system option	output	all	LR
REUSE=	specifies reuse of space when observations are added to a compressed data set	output	V6, V7, V8	LR
SORTEDBY=	specifies how the data set is currently sorted	input, output, update	V6, V7, V8	LR
TOBSNO=	specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server	input, output, update	V7, V8	LR
TRANTAB=	specifies a translation table for character conversions	input, output, update	V7, V7TAPE, V8, V8TAPE	LR
TYPE=	specifies the data set type for input, update, and output data	input output update	all	LR
WHERE=	selects observations that meet the specified condition	input	all	LR
WHEREUP=	specifies whether to evaluate added observations and modified observations against a WHERE clause	input, output, update	V7, V7TAPE, V8, V8TAPE	LR
WRITE=	assigns a write password to a SAS file and enables access to a write-protected SAS file	input, output, update	V6, V7, V8, CONCUR	LR

Chapter Contents
Previous
Next
Top of Page

COMP	See the description of the data set option in this section.
LR	See SAS Language Reference: Dictionary.
RDB	See SAS/ACCESS Software for Relational Databases: Reference (Oracle Rdb Chapter).