How to do custom sort in SAS

[tejeshwar]

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.

[LinusH]

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