Advanced Topics

Data Set Options

Data set options enable you to override some of the run-time options that are stored in view descriptors. There are no LIBNAME options.

Here is a list of available data set options.

	DDBCOMIT=n
	DDBERLMT=n
	DDBKEY= 'default-key'
	DDBLOAD=0\|1
	DDBLOCK=0\|1
	DDBPW= 'password'
	DDBSV= 'status/version'
	DDBTRACE=0\|1
	DDBURT= 'User-Requirements-Table-name'
	DDBUSER= 'userid'

You can specify the data set options with the DATA= argument in any PROC statement or DATA step. They are effective for that single execution of the procedure. Data set options will override the corresponding values stored in the view descriptor.

The following example executes the FSEDIT procedure using a view descriptor named CUSTM. The data set options specified in the PROC statement will set the user ID to JOHN and the password to MINE, regardless of what user ID and password was included in the view descriptor.

proc fsedit data=vlib.custm (ddbuser='john' ddbpw='mine');
run;

A description of each data set option follows.

DDBCOMIT= Data Set Option

DDBERLMT= Data Set Option

DDBKEY= Data Set Option

DDBLOAD= Data Set Option

DDBLOCK= Data Set Option

DDBPW= Data Set Option

DDBSV= Data Set Option

DDBTRACE= Data Set Option

DDBURT= Data Set Option

DDBUSER= Data Set Option

Top of Page