Chapter Contents
Previous
Next
SAS Companion for the OpenVMS 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, CONCUR COMP
ALQMULT= specifies the multiple of pages allocated for a data set output V6, V7, 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, 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, V7, V6TAPE, V7TAPE LR
BUFSIZE= specifies permanent buffer size for output SAS data sets output V6, V7, V6TAPE, V7TAPE LR, COMP
CACHENUM= specifies the number of I/O data caches input, output, update V6, V7 COMP
CACHESIZ= specifies the size of each I/O data cache allocated for a file input, output, update V6, V7 COMP
CNTLLEV= specifies the level of shared access allowed to a SAS data set input, update V6, V7, CONCUR LR, COMP
COMPRESS= compresses observations in an output SAS data set output V6, V7 LR
DEQ= specifies the default file-extension quantity for a data set output, update V6, V7, CONCUR COMP
DEQMULT= specifies the number of pages to extend output, update V6, V7, 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 LR
FILECLOSE= specifies the volume positioning to be performed when a SAS file residing on tape is closed input, output V6TAPE, V7TAPE LR, COMP
FIRSTOBS= begins processing at a specified observation input, output, update all LR
GENMAX= requests generations for a file and specifies the maximum number of generations input, output, update
LR
GENNUM= references a specific generation of a data set input, output, update V7, V7TAPE LR
IDXNAME= directs the SAS System to use a specific index to satisfy the conditions of a WHERE expression input, output, update V7, V7TAPE 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 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 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 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, CONCUR LR
PWREQ= controls the pop-up menu of a requestor window for a data set password input, output, update V6, V7 LR
RDBLOCK= specifies whether record-level locking or table-level locking is used when updating Oracle Rdb data update V7 RDB
RDBCONST= specifies when to evaluate constraints on Oracle Rdb data input, update V7 RDB
READ= assigns a read password to a SAS file and enables access to a read-protected SAS file input, output, update V6, V7, 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 LR
SORTEDBY= specifies how the data set is currently sorted input, output, update V6, V7 LR
TOBSNO= specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server input, output, update V7 LR
TRANTAB= specifies a translation table for character conversions input, output, update V7, V7TAPE 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 LR
WRITE= assigns a write password to a SAS file and enables access to a write-protected SAS file input, output, update V6, V7, CONCUR LR


Chapter Contents
Previous
Next
Top of Page

Copyright © 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.