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 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.