topic Re: How to Proc Sort Alphanumerically in SAS Programming

How to Proc Sort Alphanumerically

yawenyu — Mon, 08 May 2017 18:45:54 GMT

Hello!

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

NT1

NT2

I would like to sort them as:

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.

Re: How to Proc Sort Alphanumerically

Astounding — Mon, 08 May 2017 18:53:59 GMT

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;

Re: How to Proc Sort Alphanumerically

yawenyu — Mon, 08 May 2017 20:14:49 GMT

Thank you! This worked perfectly.