Chapter Contents |
Previous |
Next |
SAS Companion for the OpenVMS Operating Environment |
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.
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 |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.