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.
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.