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 are 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 is used as input to a SAS procedure except PROC DBLOAD.
Note: Passwords specified in PROC
DBLOAD cannot be overridden.
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 execute
SYSTEM 2000 in single-user mode.
proc fsedit data=vlib.emppos
(s2kmode=s s2kpw=demo);
run;