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 name of the server engine:
SASSPDS
-
-
the name of the server host
-
-
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.