Using a LIBNAME Statement to Access SPD Server

Overview of Using a LIBNAME Statement

You do not need to understand all possible LIBNAME and table options to initiate an SPD Server client session. The LIBNAME statement should specify the following items:

the local library reference (libref)
the required engine name (SASSPDS)
a valid domain name that is registered to the name server and defined to the SPD Server host
the name of the name server’s host
the user ID
password access, either using the PROMPT=YES switch or using the PASSWD keyword. (Using the PROMPT=YES switch is the more secure method.)

Issuing an Initial LIBNAME Statement

The following example specifies the libref market, the engine name sasspds, the LIBNAME domain mktdata, and the name server host sunone. It identifies an SPD Server user ID and is configured to prompt the user for a password.

LIBNAME market sasspds 'mktdata' 
 host='sunone'
 user='user id' 
 prompt=yes;

Instead of using the previous code to access SPD Server, you could use the following:

LIBNAME market sasspds 'mktdata' 
 host='sunone'
 user='user id' 
 passwd='beemer';

The only difference between this example and the previous example is the password specification. In the second example, the password beemer is included in the LIBNAME statement. You can use this method for batched SPD Server jobs that run unattended.