SPDSSTAG Macro Variable

Specifies whether to use non-tagged or tagged sorting for PROC SORT or BY processing.

Valid in: SPD Server
Default: NO
Restriction: Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized).
Syntax
Required Arguments
Details
Example

Syntax

SPDSSTAG=YES | NO

Required Arguments

YES

performs tagged sorting.

NO

performs non-tagged sorting.

Details

During a non-tagged sort, the server attaches the entire table column to the key field or fields to be sorted. Non-tagged sorting allows the software to deliver better performance than a tagged sort. Non-tagged sorting also requires more temporary disk space than a tagged sort.

Example

You are low on disk space and do not know whether you have enough disk overhead to accommodate the extra sort space required to support a non-tagged sort operation.
Configure the server to perform a tagged sort. 
%let SPDSSTAG=YES;
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 8, 2017