https://communities.sas.com/t5/SAS-Procedures/Proc-Sort-Proc-SQL-default-order/m-p/56311#M15735 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.<BR /> <BR /> 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.<BR /> Regards,<BR /> Linus Wed, 22 Oct 2008 15:50:18 GMT LinusH 2008-10-22T15:50:18Z https://communities.sas.com/t5/SAS-Procedures/Proc-Sort-Proc-SQL-default-order/m-p/56310#M15734 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) Wed, 22 Oct 2008 14:57:40 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Sort-Proc-SQL-default-order/m-p/56310#M15734 aas08 2008-10-22T14:57:40Z https://communities.sas.com/t5/SAS-Procedures/Proc-Sort-Proc-SQL-default-order/m-p/56311#M15735 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.<BR /> <BR /> 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.<BR /> Regards,<BR /> Linus Wed, 22 Oct 2008 15:50:18 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Sort-Proc-SQL-default-order/m-p/56311#M15735 LinusH 2008-10-22T15:50:18Z