https://communities.sas.com/t5/SAS-Procedures/How-to-do-custom-sort-in-SAS/m-p/70763#M20373 Hi, <BR /> <BR /> I have a variable Score which takes on values like :<BR /> A+<BR /> A<BR /> B<BR /> C<BR /> D<BR /> E<BR /> U<BR /> <BR /> 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. Thu, 22 Jan 2009 10:34:20 GMT tejeshwar 2009-01-22T10:34:20Z https://communities.sas.com/t5/SAS-Procedures/How-to-do-custom-sort-in-SAS/m-p/70763#M20373 Hi, <BR /> <BR /> I have a variable Score which takes on values like :<BR /> A+<BR /> A<BR /> B<BR /> C<BR /> D<BR /> E<BR /> U<BR /> <BR /> 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. Thu, 22 Jan 2009 10:34:20 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-do-custom-sort-in-SAS/m-p/70763#M20373 tejeshwar 2009-01-22T10:34:20Z https://communities.sas.com/t5/SAS-Procedures/How-to-do-custom-sort-in-SAS/m-p/70764#M20374 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+.<BR /> <BR /> 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.<BR /> <BR /> /Linus Thu, 22 Jan 2009 10:53:07 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-do-custom-sort-in-SAS/m-p/70764#M20374 LinusH 2009-01-22T10:53:07Z