Summary of SAS Data Set Options
Data Set Option |
Description |
Where Used |
Engines |
See |
ALQ= |
specifies the allocation quantity for a data set |
output |
V9, V8, V7, CONCUR |
Comp |
ALQMULT= |
specifies the multiple of pages allocated for a data
set |
output |
V9, V8, V7, CONCUR |
Comp |
ALTER= |
specifies a password for a SAS file that prevents users
from replacing or deleting the file, but permits READ and WRITE access |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE, CONCUR |
LR,Comp |
BKS= |
specifies the bucket size for a data set |
output |
CONCUR |
Comp |
BUFNO= |
specifies the number of buffers to be allocated for
processing a SAS data set |
input, output, update |
V9, V8, V7, V6 |
LR |
BUFSIZE= |
specifies the size of a permanent buffer page for an
output SAS data set |
output |
V9, V8, V7, V6, V9TAPE,V8TAPE, V7TAPE |
LR, Comp |
CACHENUM= |
specifies the number of I/O data caches |
input, output, update |
V9, V8, V7, V6 |
Comp |
CACHESIZE= |
specifies the size of each I/O data cache allocated
for a file |
input, output, update |
V9, V8, V7, V6 |
Comp |
CNTLLEV= |
specifies the level of shared access to SAS data sets |
input, update |
V9, V8, V7, CONCUR |
LR, Comp |
COMPRESS= |
controls the compression of observations in a new output
SAS data set |
output |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE |
LR |
DEQ= |
specifies the default file-extension quantity for a
data set |
output, update |
V9, V8, V7, CONCUR |
Comp |
DEQMULT= |
specifies the number of pages to extend |
output, update |
V9, V8, V7, CONCUR |
Comp |
DLDMGACTION= |
specifies the action to take when a SAS data set in
a SAS library is detected as damaged |
input, output, update |
V9, V8, V7, |
LR |
DROP= |
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 |
input, output, update |
all |
LR |
ENCODING= |
overrides the encoding for the input or output SAS data
set |
input, output |
V9, V8, V7, V9TAPE, V8TAPE, V7TAPE |
NLS |
ENCRYPT= |
specifies whether to encrypt an output SAS data set |
output |
V9, V8, V7 |
LR |
FIRSTOBS= |
specifies the first observation that SAS processes in
a SAS data set |
input, update |
all |
LR |
IDXNAME= |
directs SAS to use a specific index to meet the conditions
of a WHERE expression |
input, update |
V9, V8, V7, V6 |
LR |
IDXWHERE= |
specifies whether SAS uses an index, or uses a sequential
search, to match the conditions of a WHERE expression |
input, update |
V9, V8, V7, V6 |
LR |
IN= |
creates a Boolean variable that indicates whether a
data set contributed data to the current observation |
input |
all |
LR |
INDEX= |
defines an index for a new output SAS data set |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE |
LR |
KEEP= |
for an input data set, specifies the variables to process;
for an output data set, specifies the variables to write to the data set |
input, output, update |
all |
LR |
LABEL= |
specifies a label for a SAS 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 SAS 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 that SAS processes in
a data set |
input, update |
all |
LR |
OBSBUF= |
determines the size of the view buffer for processing
a DATA step view |
input |
V9, V8, V7, V9TAPE, V8TAOE, V6TAPE |
LR |
OUTREP= |
specifies the data representation for the output SAS
data set |
output |
V9, V8, V7, V9TAPE, V8TAPE, V7TAPE |
Comp |
POINTOBS= |
controls whether to process a compressed SAS data set
by observation number, or by sequential access |
input |
V9, V8, V7 |
LR |
PW= |
assigns a READ, WRITE, or ALTER password to a SAS file,
and enables access to a password-protected file |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE, CONCUR |
LR |
PWREQ= |
specifies whether to display a dialog box for a SAS
data set password |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE |
LR |
READ= |
assigns a password to a SAS file, and enables access
to a read-protected SAS file |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE, CONCUR |
LR |
RENAME= |
changes the name of a variable |
input, output, update |
all |
LR |
REPEMPTY= |
specifies whether a new, empty data set can overwrite
an existing SAS data set that has the same name |
output |
V9, V8, V7 |
LR |
REPLACE= |
Specifies whether a new SAS data set that contains data
can overwrite an existing data set that has the same name |
output |
all |
LR |
REUSE= |
specifies whether new observations can be written to
freed space in compressed SAS data sets |
output |
V9, V8, V7 |
LR |
SORTEDBY= |
indicates how the SAS data set is currently sorted |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE |
LR |
SPILL= |
specifies whether to create a spill for non-sequential
processing of a DATA step view |
output |
V9, V8, V7 |
LR |
TOBSNO= |
specifies the number of observations to send in a client/server
transfer |
input, output, update |
V9, V8, V7 |
LR |
TYPE= |
specifies the data set type for a specially structured
SAS data set |
input, output, update |
all |
LR |
WHERE= |
selects observations in a SAS data set that match the
specified conditions |
input, output, update |
all |
LR |
WHEREUP= |
specifies whether to evaluate new observations and updated
observations against a WHERE expression |
output, update |
V9, V8, V7, V6 |
LR |
WRITE= |
assigns a write password to a SAS data set, and enables
access to a write-protected SAS file |
input, output, update |
V9, V8, V7, V6, V9TAPE, V8TAPE, V7TAPE, CONCUR |
LR |