SPDO Procedure

SPDSMAC Statement

Prints the default values for SPD Server macro variables.

Syntax

spdsmac;

Example

After assigning a libref that specifies the SASSPDS engine and connects to an SPD Server domain, enter the following in your SAS session:
proc spdo lib=libref;
spdsmac;
The server returns information similar to the following in the SAS log:
                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.
Last updated: February 3, 2017