Overview of Connecting to SPD Server

You can connect to the server by issuing a SAS LIBNAME statement, or by using the SQL CONNECT statement.
  • The LIBNAME statement enables you to access server data by using the SAS DATA step and SAS procedures. When you use the LIBNAME statement and specify the IP=YES LIBNAME option, you invoke the implicit SQL pass-through facility for your SQL requests.
  • The SQL CONNECT statement connects to the server from within an SQL query. The SQL CONNECT statement invokes the server’s explicit SQL pass-through facility.
Regardless of the connection method that you use, your connection request must include the following information:
The domain names, host names, and name server port number that you can use are typically given to you by a server administrator. If ACL security is enabled, the administrator will also give you a server user ID. When UNIX file security is the only form of security that is active for the server, authentication is not required. All resources within the server domain are granted access by UNIX permissions for the server UNIX ID.
Last updated: February 8, 2017