Help using Base SAS procedures

How to do custom sort in SAS

Reply
Contributor
Posts: 59

How to do custom sort in SAS

Hi,

I have a variable Score which takes on values like :
A+
A
B
C
D
E
U

I wanted the sequence to remain the same as above, but for summarizing the data available in the dataset on that coloumn, I have to sort it and hence the sequence changes , A is always depicted over A+. I am sure there will be a way to custom sort it in the above order, however wasnt able to figure out myself.
Super User
Posts: 5,256

Re: How to do custom sort in SAS

For sorting the data, you could use a temporary sort column, where your A+ gets a lower value than A, or having A have larger value than A+.

For summarization, if you use PROC MEANS/SUMMARY, you can specify ORDER=DATA on the CLASS statment, which will preserve the order from the procedure input.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation