Specifies whether the output order of data set observations that have identical values for the BY variable is guaranteed to be in the data set order.
Valid in: | DATA step and PROC step |
Used by: | BYSORT=YES data set option |
Default: | NO |
Engine: | SPD Engine only |
does not guarantee that the output order of data set observations that have identical values for the BY variable is in data set order.
guarantees that the output order of data set observations that have identical values for the BY variable is in data set order.
Condition:
|
Data Set Order Preserved?
|
---|---|
If BY is present
|
YES (BYNOEQUALS=NO and
BYSORT=YES by default)
|
If BY is present and
BYNOEQUALS=YES
|
NO
|
If BY is present and
BYSORT=NO
|
YES (because no automatic
sort occurs)
|
If neither BY nor WHERE
is present
|
YES
|
If WHERE is present
|
NO
|
title 'With BYNOEQUALS=YES'; proc print data=labs.performance(bynoequals=yes) noobs; by score; run;
title 'With BYNOEQUALS=NO; proc print data=labs.performance(bynoequals=no) noobs; by score; run;