You begin an
SPD Server session by establishing a connection to the server from your SAS session. You can use SQL
commands to start your SPD Server client session, or you can use a LIBNAME statement.
Both methods use the
SASSPDS engine and initiate communication between the SAS client machine and SPD Server.
When you access SPD Server with a LIBNAME statement, you can create and access SPD
Server data with the DATA
step, PROC SQL, PROC COPY, PROC DATASETS, PROC CONTENTS, and other SAS procedures.
SPD Server also supports implicit SQL pass-through and explicit SQL pass-through.
When you use
implicit SQL pass-through, you submit PROC SQL statements as you would to access any
other data source. The client and the server optimize the query for you automatically.
When you use explicit SQL pass-through, you submit SPD Server SQL. The server processes
the query exactly as it is sent. SPD Server SQL is the same as the SAS SQL language,
with minor modifications and some additional statements.
For more information
about the language, see Understanding the SPD Server SQL Processor.