S2KPW Statement (Optional)

Stores the SYSTEM 2000 password and access mode for a view descriptor.

Applies to:

view descriptors only

Syntax

S2KPW=password MODE=SINGLE | MULTI | SU | MU | S | M;

Required Argument

password

can be 1 to 4 characters in length, with no embedded blanks, and enclosed in single quotation marks. Passwords longer than 4 characters are truncated and a warning message appears. If you specify a special character for a password, it must be a single character (that is, a 1-character password) and enclosed in single quotation marks.

Optional Argument

MODE=SINGLE | MULTI | SU | MU | S | M

specifies the mode in which you want to access SYSTEM 2000. SINGLE (SU or S) means that the database in your SAS program environment is in single-user mode. MULTI (MU or M) means that the database files are in Multi-User mode. The mode is also stored with the view. The default is MULTI.

Details

TheS2KPW statement specifies the SYSTEM 2000 password and access mode for creating a view descriptor. The password that you specify is stored in encrypted form. It enables all who access the view descriptor to have access to the data that it describes. If you do not specify the S2KPW statement when creating a view descriptor, you must specify a password when using the view descriptor in order to access data from the database.

The password that is used when you open a view descriptor determines which data you see and your ability to subset and edit it through the view descriptor. You can specify the password that was used in the access descriptor from which the view is derived, or you can specify another password that encompasses a subset of the data in the view descriptor. If you specify a password that does not encompass data from the access descriptor, the view is created, but the software issues an error message when you attempt to open the view descriptor.