BookmarkSubscribeRSS Feed
aas08
Calcite | Level 5
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)
1 REPLY 1
LinusH
Tourmaline | Level 20
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

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1560 views
  • 0 likes
  • 2 in conversation