SAS File Passwords

When you use the LIBNAME engine for DataFlux Federation Server, SAS passwords are supported only for unsecured DSNs. An unsecured DSN is a DSN that does not have Federation Server authorization enabled. If you specify a SAS password to create or read a SAS data set when Federation Server authorization is enabled, the server will return an error.

Base SAS software enables you to restrict access to SAS data sets by assigning SAS passwords when you create the data sets. You can specify three levels of protection: read, write, and alter. Later, to read or update the data set, you specify the appropriate password.

To assign or specify a password, submit the ALTER=, PW=, READ=, and WRITE= password options as follows:

libname myfiles fedsvr server="d1234.us.company.com" 
   port=2171 uid="myid" pwd="mypwd"
   dsn=basedsn;
  
data myfiles.newds (pw=luke);
   set sashelp.class;
run;

In the preceding example, the DATA step assigns the password Luke to the new SAS data set.

For more information about SAS passwords, see SAS Language Reference: Concepts.