DOCUMENTATION
Sign In

Get access to My SAS, trials, communities and more.

SAS Language Elements by Name, Product, and Category
 

Macro Variables Listed Alphabetically

Name
Syntax and Description
SPDSAUNQ Macro Variable
SPDSAUNQ=NO | YES
Specifies whether to cancel an append or insert to a table. Use this macro variable if the table has a unique index and the new rows would violate the index uniqueness.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSBNEQ Macro Variable
SPDSBNEQ=NO | YES
Specifies the output order of table rows that have identical values in the BY column.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSBSRT Macro Variable
SPDSBSRT=NO | YES
Configures SPD Server's sorting behavior when it encounters a BY clause and there is no index available.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSCLJX Macro Variable
SPDSCLJX=NO | YES
Affects the SAS SQL planner when a SAS table is being joined with an indexed SPD Server table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSCMPF Macro Variable
SPDSCMPF=n
Specifies the amount of growth space, sized in bytes, to be added to a compressed data block.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSCOMP Macro Variable
SPDSCOMP=NO | YES
Specifies whether to compress the data when sending a data packet through the network.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSDCMP Macro Variable
SPDSDCMP=YES | CHAR | BINARY
Specifies to compress SPD Server tables that are stored on disk.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSEINT Macro Variable
SPDSEINT=NO | YES
Specifies how SPD Server responds to network disconnects during SQL explicit pass-through EXECUTE() statements.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSEOBS Macro Variable
SPDSEOBS=n
Specifies the number of the last row of a user-defined range that you want to process in a table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSEV1T Macro Variable
SPDSEV1T=0 | 1 | 2
Specifies whether data returned from an SPD Server WHERE clause evaluations should be in strict row order.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSEV2T Macro Variable
SPDSEV2T=0 | 1 | 2
Specifies whether the data returned from WHERE clause evaluations should be in strict row order.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSFSAV Macro Variable
SPDSFSAV=NO | YES
Specifies whether you want to retain table data if the SPD Server table creation process terminates abnormally.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSHOST Macro Variable
SPDSHOST=HOST-NAME
Assigns an SPD Server host name.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSIASY Macro Variable
SPDSIASY=NO | YES
Specifies whether to create indexes in parallel when creating multiple indexes on an SPD Server table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSIPDB Macro Variable
SPDSIPDB=NO | YES
Specifies whether to include SQL implicit pass-through code or error messages in the SPD Server log.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSIRAT Macro Variable
SPDSIRAT=0...100
Specifies whether to perform segment candidate pre-evaluation when performing WHERE clause processing with indexes.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSNBIX Macro Variable
SPDSNBIX=NO | YES
Specifies to suppress index use during a BY sort.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSNETP Macro Variable
SPDSNETP=size-of-packet
Sizes buffers in server memory for the network data packet.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSNIDX Macro Variable
SPDSNIDX=NO | YES
Specifies whether to use the table's indexes when processing WHERE clauses. SPDSNIDX can also be used to disable index use for BY order determination.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSRSSL Macro Variable
SPDSRSSL=NO | YES
Specifies to make a secure sockets connection to SPD Server.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSSADD Macro Variable
SPDSSADD=NO | YES
Specifies whether SPD Server appends tables by transferring a single row at a time synchronously, or by transferring multiple rows asynchronously (block row appends).
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSSIZE Macro Variable
SPDSSIZE=n
Specifies the size of an SPD Server table partition.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSSOBS Macro Variable
SPDSSOBS=n
Specifies the number of the starting row in a user-defined range of a table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSSQLR Macro Variable
SPDSSQLR=reset-option
Specifies an SQL reset option using implicit pass-through.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSSTAG Macro Variable
SPDSSTAG=NO | YES
Specifies whether to use non-tagged or tagged sorting for PROC SORT or BY processing.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSTCNT Macro Variable
SPDSTCNT=n
Specifies the number of threads that you want to use during WHERE clause evaluations.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSUSAV Macro Variable
SPDSUSAV=NO | REP | YES
Specifies whether to save rows with non-unique (rejected) keys to a separate SAS table.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSVERB Macro Variable
SPDSVERB=NO | YES
Specifies that PROC CONTENTS output include details about compressed blocks, data partition size, and indexes.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSWCST Macro Variable
SPDSWCST=NO | YES
Specifies whether to use dynamic WHERE clause costing.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSWDEB Macro Variable
SPDSWDEB=NO | YES
Use the SPDSWDEB macro variable to specify whether the WHERE clause planner WHINIT, when evaluating a WHERE expression, should display a summary of the execution plan.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
SPDSWSEQ Macro Variable
SPDSWSEQ=NO | YES
Set the SPDSWSEQ macro variable to YES. When set to YES, the SPDSWSEQ macro variable overrides WHERE clause costing and forces a global EVAL3 or EVAL4 strategy.
Product: SAS Scalable Performance Data Server
Document: SAS Scalable Performance Data Server: User’s Guide
Last updated: November 17, 2025