SPD Server Additions to Base SAS

The SPD Server product provides the following server-specific language elements that are available in the SAS session:
  • LIBNAME options
  • table options
  • macro variables
  • formats and informats
  • SQL statements
Additional SQL statements are available only via explicit SQL pass-through. One of the statements, RESET, enables you to customize the behavior of the server’s SQL processor.
SPD Server also provides the SPDO procedure. PROC SPDO is the operator interface for SPD Server. PROC SPDO is used to perform the following tasks:
  • define and manage ACLs
  • create and manage cluster tables
  • define row-level security on tables
  • truncate a table
  • refresh SPD Server domains and server parameters on the fly
  • manage client proxies
  • execute SPD Server utilities.
For more information about PROC SPDO, see SPDO Procedure in SAS Scalable Performance Data Server: Administrator’s Guide.
Last updated: February 8, 2017