SORTCUTP

SORTCUTP

Specifies the number of bytes above which the host sort program is used instead of the SAS sort program

Default: 0

Valid in: configuration file, SAS invocation, SASV8_OPTIONS environment variable, OPTIONS statement

UNIX specifics: all

Syntax
Details

Syntax

SORTCUTP=n|nK|nM|nG|MIN|MAX

-SORTCUTP n|nK|nM|nG |MIN|MAX

n|nK|nM|nG: specifies the number of bytes in multiples of 1; 1,024 (kilobytes); 1,048,576 (megabytes); and 1,073,741,824 (gigabytes), respectively. For example, a value of 8 specifies 8 bytes and a value of 3M specifies 3,145,728 bytes.
MIN: specifies 0 bytes.
MAX: specifies 2,147,483,647 bytes. On 64-bit systems, MAX is 9,007,199,254,740,992.
hexX: specifies the number of bytes in hexadecimal notation. For example, 2DX specifies 45 bytes.

Details

When you specify SORTPGM=BEST, SAS uses the value of the SORTCUT and SORTCUTP options to determine whether to use the host sort or the SAS System sort. If the data set to be sorted is larger than the number of bytes (or kilobytes or megabytes) that you specify with SORTCUTP, the host sort (external) program will be used instead of the SAS sort (internal) program. On 32-bit systems, the value you specify must be less than or equal to 2,147,483,647 bytes. On 64-bit systems, the value you specify must be less than or equal to 9,007,199,254,740,992. If both SORTCUT and SORTCUTP are either not defined or are set to 0, the SAS System sort is used. If you specify both options and either condition is true, SAS chooses the host sort.

The following equation computes the number of bytes to be sorted:

number-of-bytes= ((length-of-obs)+(length-of-all-keys))
*number-of-obs

Chapter Contents
Previous
Next
Top of Page

Default:	0
Valid in:	configuration file, SAS invocation, SASV8_OPTIONS environment variable, OPTIONS statement
UNIX specifics:	all