Hi
I am using Proc Sort to sort a data set with a specific variable which is a alpha variable. I know the two standard sort options are ascending and descending (and don't see any others), but is there another option for custom sorting by the values in a variable/column?
The values I am trying to sort are (ascend/desc do not order correctly):
0
1 to 5
6 - 12
13 to 17
18 +
Paul
Paul, I think you are looking for:
data have;
input column1 $ &;
cards;
0
1 to 5
6 - 12
13 to 17
18 +
;
proc sort data=have SORTSEQ=LINGUISTIC(NUMERIC_COLLATION=ON);
by Column1;
run;
Paul, I think you are looking for:
data have;
input column1 $ &;
cards;
0
1 to 5
6 - 12
13 to 17
18 +
;
proc sort data=have SORTSEQ=LINGUISTIC(NUMERIC_COLLATION=ON);
by Column1;
run;
Thanks a lot again Art. That works fine.
Paul
If you always want to sort this column according to numeric value, I think it would be wise to concert the column to numeric.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.