SAS Companion for the OS/390 Environment

Summary of SAS Data Set Options in the OS/390 Environment

The Summary Table of SAS Data Set Options describes both the data set options specific to OS/390 and the portable data set options.

The See column tells you where to look for more detailed information about an option, based on the following legend:

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

LR See SAS Language Reference: Dictionary.

The Engines column lists the engines with which the option is valid, based on the following legend:

all V8, V7, V6, DBI Applies to all disk and tape engines, including database interface (DBI) engines.

all V8, V7, V6 Applies to all disk and tape engines except DBI engines.

V8TAPE, V7TAPE, V6TAPE Applies to all tape engines for the specified SAS versions; does not apply to disk or DBI engines.

V8, V7, V6 Applies to all disk engines for the specified versions; does not apply to tape or DBI engines.

Summary Table of SAS Data Set Options
Data Set Option Description When Used See Engines

ALTER= specifies the password required to delete or replace a SAS data set or to modify variable attributes or indexes for a SAS data set output, update LR all V8, V7, V6

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

input LR all V5

BUFSIZE= specifies a permanent page size for output SAS data sets output LR all V8, V7, V6

CNTLLEV= specifies the level at which shared update access to a SAS data set is denied input, output, update LR all V8, V7, V6

input LR V5

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

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

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

input LR V5

ENCRYPT= encrypts SAS data files output LR all V8

FILECLOSE= specifies how to position a tape volume when a SAS file on the tape is closed input, output LR V8TAPE, V7TAPE, V6TAPE

input LR V5TAPE

FILEDISP= specifies the initial disposition for a sequential-format SAS data library input, output COMP V8TAPE, V7TAPE, V6TAPE

input COMP V5TAPE

FIRSTOBS= causes processing to begin at a specified observation input LR all V8, V7, V6, DBI

GENMAX= requests generations for a file and specifies the maximum number of generations input, output, update LR V8

GENNUM= references a specific generation of a data set input, output, update LR V8

IDXNAME= directs SAS to use a specific index to satisfy the conditions of a WHERE expression input LR V8

IDXWHERE= overrides the SAS decision about whether to use an index to satisfy the conditions of a WHERE expression input LR V8

IN= creates a variable that indicates whether the data set contributed data to the current observation input (with SET, MERGE, MODIFY, UPDATE statements only) LR all V8, V7, V6, DBI

INDEX= defines one or more indexes for a new data set output LR V8, V7, V6

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

input LR all V5

LABEL= specifies a label for the SAS data set input, output, update LR all V8, V7, V6, DBI

input LR all V5

OBS= specifies the last observation of the data set to process input LR all V8, V7, V6, DBI

OUTREP= specifies an output format for an operating environment other than OS/390 output LR all V8

POINTOBS= controls whether a new compressed data set may be processed by observation number input LR V8

PW= assigns a read, write, and alternate password to a SAS file input, output, update LR all V8, V7, V6

input LR all V5

PWREQ= specifies whether to display a requestor window if a password has not been supplied input, output, update LR all V8, V7, V6

input LR all V5

READ= specifies the password required to read a SAS data set input, update LR all V8, V7, V6

input LR V5

RENAME= changes the name of a variable input, output, update LR all V8, V7, V6, DBI

input LR V5

REPLACE= overrides the REPLACE= system option output LR all V8, V7, V6, DBI

REUSE= specifies whether SAS appends new observations to a compressed data set or inserts them in freed space output LR V8, V7, V6

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

input LR all V5

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

TRANTAB= specifies a translation table for character conversions input, output, update LR all V8

TYPE= specifies the data set type for data that is used by some SAS/STAT procedures input, output, update LR all V8, V7, V6, DBI

input LR all V5

WHERE= selects observations that meet the specified condition input, update LR all V8, V7, V6, DBI

input LR all V5

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

input LR all V5

WRITE= specifies the password required to modify the value of an observation within a SAS data set output, update LR all V8, V7, V6

***Summary Table of SAS Data Set Options***
Data Set Option	Description	When Used	See	Engines
ALTER=	specifies the password required to delete or replace a SAS data set or to modify variable attributes or indexes for a SAS data set	output, update	LR	all V8, V7, V6
BUFNO=	specifies the number of buffers for processing a SAS data set	input, output, update	LR	all V8, V7, V6
		input	LR	all V5
BUFSIZE=	specifies a permanent page size for output SAS data sets	output	LR	all V8, V7, V6
CNTLLEV=	specifies the level at which shared update access to a SAS data set is denied	input, output, update	LR	all V8, V7, V6
		input	LR	V5
COMPRESS=	compresses observations in an output SAS data set	output	LR	all V8, V7, V6
DLDMGACTION=	specifies what type of action to take when a SAS data set in a SAS data library is detected as damaged	input, output, update	LR	V8, V7, V6
DROP=	excludes variables from processing or from output SAS data sets	input, output, update	LR	all V8, V7, V6, DBI
		input	LR	V5
ENCRYPT=	encrypts SAS data files	output	LR	all V8
FILECLOSE=	specifies how to position a tape volume when a SAS file on the tape is closed	input, output	LR	V8TAPE, V7TAPE, V6TAPE
		input	LR	V5TAPE
FILEDISP=	specifies the initial disposition for a sequential-format SAS data library	input, output	COMP	V8TAPE, V7TAPE, V6TAPE
		input	COMP	V5TAPE
FIRSTOBS=	causes processing to begin at a specified observation	input	LR	all V8, V7, V6, DBI
GENMAX=	requests generations for a file and specifies the maximum number of generations	input, output, update	LR	V8
GENNUM=	references a specific generation of a data set	input, output, update	LR	V8
IDXNAME=	directs SAS to use a specific index to satisfy the conditions of a WHERE expression	input	LR	V8
IDXWHERE=	overrides the SAS decision about whether to use an index to satisfy the conditions of a WHERE expression	input	LR	V8
IN=	creates a variable that indicates whether the data set contributed data to the current observation	input (with SET, MERGE, MODIFY, UPDATE statements only)	LR	all V8, V7, V6, DBI
INDEX=	defines one or more indexes for a new data set	output	LR	V8, V7, V6
KEEP=	specifies variables for processing or for writing to output SAS data sets	input, output, update	LR	all V8, V7, V6, DBI
		input	LR	all V5
LABEL=	specifies a label for the SAS data set	input, output, update	LR	all V8, V7, V6, DBI
		input	LR	all V5
OBS=	specifies the last observation of the data set to process	input	LR	all V8, V7, V6, DBI
OUTREP=	specifies an output format for an operating environment other than OS/390	output	LR	all V8
POINTOBS=	controls whether a new compressed data set may be processed by observation number	input	LR	V8
PW=	assigns a read, write, and alternate password to a SAS file	input, output, update	LR	all V8, V7, V6
		input	LR	all V5
PWREQ=	specifies whether to display a requestor window if a password has not been supplied	input, output, update	LR	all V8, V7, V6
		input	LR	all V5
READ=	specifies the password required to read a SAS data set	input, update	LR	all V8, V7, V6
		input	LR	V5
RENAME=	changes the name of a variable	input, output, update	LR	all V8, V7, V6, DBI
		input	LR	V5
REPLACE=	overrides the REPLACE= system option	output	LR	all V8, V7, V6, DBI
REUSE=	specifies whether SAS appends new observations to a compressed data set or inserts them in freed space	output	LR	V8, V7, V6
SORTEDBY=	specifies how the data set is currently sorted	input, output update	LR	all V8, V7, V6
		input	LR	all V5
TOBSNO=	specifies the number of observations to be transmitted in each multi-observation exchange with a SAS server	input, output, update	LR	REMOTE
TRANTAB=	specifies a translation table for character conversions	input, output, update	LR	all V8
TYPE=	specifies the data set type for data that is used by some SAS/STAT procedures	input, output, update	LR	all V8, V7, V6, DBI
		input	LR	all V5
WHERE=	selects observations that meet the specified condition	input, update	LR	all V8, V7, V6, DBI
		input	LR	all V5
WHEREUP=	specifies whether to evaluate added observations and modified observations against a WHERE clause	input, output, update	LR	all V8
		input	LR	all V5
WRITE=	specifies the password required to modify the value of an observation within a SAS data set	output, update	LR	all V8, V7, V6

Chapter Contents
Previous
Next
Top of Page

COMP	See the description of the data set option in this chapter.
LR	See SAS Language Reference: Dictionary.

all V8, V7, V6, DBI	Applies to all disk and tape engines, including database interface (DBI) engines.
all V8, V7, V6	Applies to all disk and tape engines except DBI engines.
V8TAPE, V7TAPE, V6TAPE	Applies to all tape engines for the specified SAS versions; does not apply to disk or DBI engines.
V8, V7, V6	Applies to all disk engines for the specified versions; does not apply to tape or DBI engines.