SAS can execute SQL
commands within the client, or pass the SQL to the server. SPD Server
supports SQL that is passed to it from the client. The SPD Server
host can completely evaluate SQL expressions. SPD Server also supports
nested SQL pass-through commands. You can use SQL pass-through commands
to connect to other SPD Server hosts while you are connected to your
SPD Server host. You can use nested pass-through commands to distribute
simultaneous SQL queries across multiple SPD Server hosts on your
network.
You can access the SQL
pass-through facility with or without SAS syntax and applications.
You can use SAS to connect to an SPD Server host by using pass-through
syntax from PROC SQL or from other SQL-aware SAS applications.
For more information about the SPD Server pass-through facility
and for syntax examples, see Accessing and Creating SAS Scalable Performance Data (SPD) Server Tables.