Use SAS to Test Your SPD Server Installation

Testing your SPD Server installation is simple. To verify your installation, you make two SAS LIBNAME assignments using the SPD Server LIBNAME engine. The examples in this section refer to the SASSPDS engine, which is the engine for SAS 9.3.
  1. Start the SPD Server environment.
  2. On a client system that is configured correctly, invoke SAS and make the following LIBNAME assignments:
    LIBNAME test sasspds 'tmp'
     server=serverNode.port 
     user='anonymous';
    In this code, serverNode is the server's node name, and port is either the numeric value used to start the name server or the service name you use to access the SPD Server name server. Name services enable you to connect to a server using a character string, instead of specifying a port number. If you used the default numeric port assignment of 5400, your assignmentlooks similar to the following example:
    LIBNAME test sasspds 'tmp' 
     server=serverNode.5400 
     user='anonymous';
    If you used the spdsname service, your LIBNAME assignment looks similar to the following example:
    LIBNAME test sasspds 'tmp' 
     server=serverNode.spdsname 
     user='anonymous';
    In addition, you should verify that the row-level integrity LIBNAME assignment works correctly:
    LIBNAME testrl sasspds 'tmp' 
     server=serverNode.port 
     user='anonymous' 
     locking=YES; 
    When you verify these statements, you confirm the connectivity between the SAS client and the SPD Server environment. When you successfully make these LIBNAME assignments, the network configuration is correct and most of the SPD Server configuration is correct.
    Substitute serverNode with the node name that runs the name server and the data server. The test assumes that the temporary LIBNAME definition in the sample libnames.parm file was not changed during installation.
  3. Watch the SAS log for error messages. You might see failures to locate one or more of the required SPD Server components. The following messages are common error messages that you might receive:
    ERROR: Module TEST not found in search paths. 
    ERROR: Error in the LIBNAME or FILENAME statement. 
    If you receive the following error message (or a similar message) that describes failures to access messages, check your -SASMSG option and confirm that the directory in which you installed SPD Server components is correctly set.
    ERROR: unable to access message 608.108 
  4. After you have assigned every LIBNAME, you can further verify your installation by running the sample SAS program, InstallDir\samples\verify.sas. Issue the following SAS command to execute the program:
    %include 'InstallDir\samples\verify.sas'\source2;
    This test exercises many features of the SPD Server LIBNAME engine and proxy, and verifies your installation configuration. The test performs a sequence of DATA and PROC steps using a generated data set. It checks the results expected from various DATA step queries. If any query fails to produce the expected results, the SAS job is terminated. The job verify.sas requires that the SAS librefs TEST and TESTRL are assigned as shown in step 2.
  5. Verify that SQL pass-through services are working in SPD Server by issuing the following SAS commands:
    %let spdshost=serverNode;
    %let spdsport=port;
    %include 'InstallDir\samples\verptsql.sas'\source2; 
    Note: serverNode and port are described in step 2.