Help using Base SAS procedures

Proc Sort/Proc SQL default order

Reply
N/A
Posts: 1

Proc Sort/Proc SQL default order

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)
Super User
Posts: 5,257

Re: Proc Sort/Proc SQL default order

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation