
Prints the default values for SPD Server macro variables.
proc spdo lib=libref;
spdsmac;
SPD Macro Variables list/settings.
SPDSACWH=NO Controls whether to use Where clause filtering for HADOOP processing.
SPDSAUNQ=NO Controls appends to tables with unique indexes.
SPDSBNEQ=NO Controls BYNOEQUALS for BY processing.
SPDSBSRT=YES Controls Sorting for BY processing.
SPDSCLJX=NO Controls whether SAS will consider doing an index
join to a SPD cluster table index with an
unknown number of values.
SPDSCOMP=YES Controls Network Data Compression.
SPDSCMPF=0 Number of bytes free in each compress block
for later updates. Default is 0 bytes.
SPDSDCMP=NO Controls Data Compression.
SPDSEINT=YES Controls network interrupts for SQL pass-through.
SPDSEOBS=0 Ending observation number.
SPDSEV1T=1 EVAL1 method type(0=sync,1=async).
SPDSEV2T=1 EVAL2 method type(0=sync,1=async).
SPDSFSAV=NO Controls whether output files are deleted.
SPDSHPRD=NO Controls whether to use parallel reads for HADOOP processing.
SPDSIASY=NO Controls whether indexes are created in parallel.
SPDSIPDB=NO Controls whether Implicit SQL Pass-Through errors appear in the SAS log.
SPDSIRAT=0 Percentage of segments on which to perform pre-evaluation.
SPDSNBIX=NO Controls use of indexes during a BY sort.
SPDSNETP=4096 Network Packet Size.
SPDSNIDX=NO Controls whether indexes are used during Where clause
planning or by processing.
SPDSRSSL=NO Controls SSL communication with the server.
SPDSSADD=NO Controls whether record updates are synchronous.
Important when using Unique indexes and duplicate values
are detected.
SPDSSIZE=0 File Partition size (in M units).
SPDSSOBS=0 Starting observation number.
SPDSSQLR=NO SQL reset options specified in implicit pass-through.
SPDSSTAG=NO Controls whether to use tagged sorting.
SPDSTCNT=0 Number of threads to use during Where clause evaluations.
SPDSUSAV=NO Controls whether records with duplicate
keys are saved in a SAS Data Set.
SPDSUSDS= Name of the SAS Data Set which has the
records with duplicate keys.
SPDSVERB=NO Controls verbose listing of data set contents.
SPDSWCST=NO Controls whether to use dynamic Where clause costing.
SPDSWDEB=NO Controls whether WHERE clause planning tree is printed.
SPDSWSEQ=NO Controls whether to override Where clause costing.