Configuring SPD Server Client Software

The SPD Server client software is used 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.2, and contains the following SAS modules:
  • sasspds is the LIBNAME engine that is required to access the SPD Server environment from SAS 9.2.
  • sasspdo is the SPD Server operator procedure that is required to access the SPD Server 4.5 environment from SAS 9.2.
  • spds.msg is the SAS compatible message file for the SPD Server LIBNAME engine and SPD Server operator procedure.
The SPD Server client software is installed with SAS 9.2 Foundation at <SASROOT>/SASFoundation/9.2/spdclient. The SAS 9.2 configuration file automatically includes your SPD Server client software directory in its required path list.
Once the SPD Server environment is configured and running, you need to complete other installation functions on the SAS clients that will use SPD Server. This might include the system that is actually running SPD Server. Therefore, some of these steps might have already been performed during the installation of the SPD Server host. If so, skip the duplicated steps.
Perform 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 not already there:
    spdsname ????/tcp # SPDS Name Service
    The service defines the port number for the SPD Server Name Server process. Make sure the added port number matches the port number used during the SPD Server installation. If you are running SAS with 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.2 ODBC Driver, JDBC Driver, and htmSQL driver. Each of these drivers can be downloaded from the Support tab at support.sas.com
    ODBC client applications require installation of the spds.dll application extension. Install the ODBC client application extension as follows
    • Install the SAS 9.2 ODBC Driver
    • Copy 
      InstallDir/lib/spds.dll
      to 
      <drive letter>:\Program Files\sas\shared files\general
    • Configure an ODBC data source for direct SPD Server access.
Copyright © SAS Institute Inc. All rights reserved.