PW= Table Option

Assigns a READ, WRITE, and ALTER password to a SAS data set or an SPD Engine data set and enables access to the password-protected file. Specifies a key value for accessing an encrypted SPD Server table.

Category: Table Control
Data source: SAS data set, SPD Engine data set, SPD Server table
Note: Check your log after this operation to ensure that the password values are not visible. For more information, see “Blotting Passwords and Encryption Key Values” in SAS Language Reference: Concepts.

Syntax

Arguments

password

must be a valid SAS name.

key-value

must be a valid SAS name.

Details

The PW= table option applies to a SAS data set, an SPD Engine data set, and an SPD Server table. For a SAS data set and SPD Engine data set, you can use this option to assign a password to the data set or to access a password-protected data set. When a data set that is protected by a password is replaced, the new data set inherits the password.
Note: A SAS password does not control access to a SAS file beyond the SAS system. You should use the operating system-supplied utilities and file-system security controls in order to control access to SAS files outside of SAS.
For SPD Server tables, you can use the PW= option to access an SPD Server table that is already encrypted. The PW= option enables access to table files that are protected by the SAS proprietary encryption algorithm.

Examples

Example 1: Assigning a Password or Encryption Key with PW=

create table myfiles.mytable {options pw=green}(column1 double);

Example 2: Specifying a Password or Encryption Key with PW=

select * from myfiles.mytable {option pw=green};
Last updated: February 23, 2017