SUPPORT / SAMPLES & SAS NOTES
 

Support

Usage Note 30538: SPDSNBIX macro variable added in SAS SPD Server 4.4 TSM3

DetailsHotfixAboutRate It
A new macro variable, SPDSNBIX, has been added to SAS SPD Server 4.4. 
The variable controls whether the server uses the index when doing a BY-sort 
when a BY variable is indexed.

Values for the variable are as follows:

SPDSNBIX = NO    Default value; SPD Server will use the index to do a BY-sort 
                 if the BY variable is indexed.

SPDSNBIX = YES   SPD Server will not use an index to do a BY-sort even if the 
                 BY variable is indexed. Instead, it does a parallel merge sort
                 on the table.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SPDSScalable Performance Data Server64-bit Enabled AIX4.44.43.0 TS M0
HP-UX IPF4.44.43.0 TS M0
Tru64 UNIX4.44.43.0 TS M0
Solaris for x644.44.43.0 TS M0
64-bit Enabled Solaris4.44.43.0 TS M0
64-bit Enabled HP-UX4.44.43.0 TS M0
Windows4.44.43.0 TS M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.