How to Proc Sort Alphanumerically

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

How to Proc Sort Alphanumerically

Hello!

 

I am using SAS ver9.3 to sort observations. They are as follows:

 

NT1

NT2

T1

T2

T3

 

I would like to sort them as:

 

T1

T2

T3

NT1

NT2

 

A simple DECENDING statement does not work, and give me T3, T2, T1, NT2, NT1. Is there a proper way to sort this? Thank you in advance. I am new at SAS programming so apologies if there is a simple solution I am not realizing.


Accepted Solutions
Solution
‎05-08-2017 04:14 PM
Super User
Posts: 5,369

Re: How to Proc Sort Alphanumerically

Well, there's not really a simple solution.  SAS isn't built to sort in an order that is neither ascending nor descending.  You would need to create an extra variable based on your old variable:

 

if oldvar =: 'T' then sort_order=1;

else sort_order=2;

 

Then use that as part of your sorting sequence:

 

proc sort data=have;

by sort_order oldvar;

run;

View solution in original post


All Replies
Solution
‎05-08-2017 04:14 PM
Super User
Posts: 5,369

Re: How to Proc Sort Alphanumerically

Well, there's not really a simple solution.  SAS isn't built to sort in an order that is neither ascending nor descending.  You would need to create an extra variable based on your old variable:

 

if oldvar =: 'T' then sort_order=1;

else sort_order=2;

 

Then use that as part of your sorting sequence:

 

proc sort data=have;

by sort_order oldvar;

run;

Occasional Contributor
Posts: 14

Re: How to Proc Sort Alphanumerically

Thank you! This worked perfectly.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 120 views
  • 1 like
  • 2 in conversation