Advanced Topics for Users

Overriding Options

Data set options enable you to override corresponding values stored in a view descriptor. The S2KPW= and S2KMODE= data set options can be specified by using the DATA= argument in any PROC statement except PROC DBLOAD. The options are in effect only for a single execution of the procedure.

S2KPW=password

enables you to override the SYSTEM 2000 password stored in the view descriptor. If no password is stored in the view descriptor, the S2KPW= option must be used to provide a valid password for the database.

The password must be an alphanumeric value that is 1 to 4 characters in length with no embedded blanks and can be enclosed in single quotation marks. Passwords longer than 4 characters will be truncated and a warning message is issued. If the password is a special character, it must be a single character (that is, a 1-character password) enclosed in single quotation marks.

Use the S2KPW= option in the DATA= argument, where DATA= specifies a SYSTEM 2000 view descriptor that will be used as input to a SAS procedure except PROC DBLOAD.

Note: Passwords specified in PROC DBLOAD cannot be overridden. [cautionend]

S2KMODE=S|M

enables you to override the SYSTEM 2000 access mode that is stored in the view descriptor. S2KMODE=S executes the procedure as a single-user job, which means that you allocate the database files in your job and execute a separate copy of SYSTEM 2000. S2KMODE=M indicates that the database files are allocated in a region controlled by the Multi-User software. S2KMD is an alias.

Use the S2KMODE= option in the DATA= argument, where DATA= specifies a SYSTEM 2000 view descriptor that will be used as input to a SAS procedure except PROC DBLOAD, which uses the mode that is specified for a new database, or the mode that is stored in the view descriptor for an incremental load.

The following program executes the FSEDIT procedure using the view descriptor EMPPOS. The data set options specified in the PROC FSEDIT statement use the password DEMO and will execute SYSTEM 2000 in single-user mode.

proc fsedit data=vlib.emppos 
  (s2kmode=s s2kpw=demo);
run;

Top of Page