SORTEQUALS System Option

Specifies whether observations in the output data set with identical BY variable values are in a particular order.
Valid in: Configuration file, SAS invocation, OPTIONS statement, SAS System OPTIONS window
Category: Sort: Procedure options
PROC OPTIONS GROUP= SORT
Note: This option can be restricted by a site administrator. For more information, see Restricted Options.

Syntax

Syntax Description

SORTEQUALS
specifies that observations with identical BY variable values are to retain the same relative positions in the output data set as in the input data set.
NOSORTEQUALS
specifies that no resources be used to control the order of observations with identical BY variable values in the output data set.
Interaction:To achieve the best sorting performance when using the THREADS= system option, specify THREADS=YES and NOSORTEQUALS.
Tip:To save resources, use NOSORTEQUALS when you do not need to maintain a specific order of observations with identical BY variable values.

Comparisons

The SORTEQUALS and NOSORTEQUALS system options set the sorting behavior of PROC SORT for your SAS session. The EQUAL or NOEQUAL option in the PROC SORT statement overrides the setting of the system option for an individual PROC step and specifies the sorting behavior for that PROC step only.

See Also

Procedure Statement Options:
PROC SORT statement EQUALS option, SORT Procedure in Base SAS Procedures Guide
System Options: