What is the default order when doing a Proc Sort and Proc SQL ORDERBY in SAS 8.2 and SAS 9.2? (Especially important when have observations with same by variable values)
For PROC SORT, the EQUALS/NOEQUALS determines how to handle rows with identical BY variable values. The sort order itself are specified using the SORTSEQ=, COLLATION= and other options. See on-line doc.
You can use the SORTSEQ= with Proc SQL as well, bet there is to my knowledge no counterpart to the EQUALS option of Proc Sort.
Regards,
Linus