Configure SPD Server Client Software

Use the SPD Server client software to make SAS LIBNAME connections and perform user-specified operations on the SPD Server host. The SPD Server client software is installed with SAS 9.3 Foundation at <SASROOT>/SASFoundation/9.3/sasexe. The SAS 9.3 configuration file automatically includes your SPD Server client software directory in its required path list. The client software contains the following SAS modules:
  • sasspds is the LIBNAME engine that is required to access the SPD Server environment from SAS 9.3.
  • sasspdo is the SPD Server operator procedure that is required to access the SPD Server 4.5 environment from SAS 9.3.
  • spds.msg is the message file for the SPD Server LIBNAME engine and SPD Server operator procedure. This file is compatible with SAS.
After you have configured the SPD Server environment and the SPD Server is running, you need to complete other installation tasks on the SAS clients that will use SPD Server. Because some of these tasks might involve the system that is actually running SPD Server, you might have already completed some of the following steps when you installed the SPD Server host. If that is the case, skip the duplicated steps.
Complete the following steps on each SAS client that will access SPD Server:
  1. If you want to access SPD Server through a registered port (name service), add the following service to your /etc/inet/services or /etc/services file (if this service is not already present):
    spdsname ????/tcp # SPDS Name Service
    This service defines the port number for the SPD Server name server process. Make sure that this port number matches the port number that you used when you installed SPD Server. If you are running SAS on an existing SPD Server installation, this service name is probably already defined. You can either define another service name for the SAS client to use (for example, sp45name) or you can directly include the SPD Server port number in your SAS statements.
  2. The SPD Server can be accessed with the SAS 9.3 ODBC driver, JDBC driver, and htmSQL driver. Download these drivers on the Support tab at support.sas.com.
  3. ODBC drivers only: ODBC client applications require you to install the spds.dll application extension. To install the ODBC client application extension:
    1. Install the SAS 9.3 ODBC driver
    2. Copy the InstallDir/lib/spds.dll directory to the <drive letter>:\Program Files\sas\shared files\general directory.
    3. Configure an ODBC data source for direct SPD Server access.