I have character variable with numerical values...While sorting I am getting the following way.....is there way that i can get as 1,2,3,4,5,6,,7,8 instead of 1,1,10,10,11,11
100010002 1
100010002 1
100010002 10
100010002 10
100010002 11
100010002 11
100010002 11
100010002 12
100010002 12
100010002 13
100010002 13
100010002 2
100010002 2
100010002 3
100010002 4
100010002 5
100010002 6
100010002 7
100010002 8
100010002 8
proc sort data=have SORTSEQ=LINGUISTIC;
by x; run;
Do you need numeric_collation sub-option?
I have charceter variable but it has only numeric values........so i would like do sorting the way we do it for numeric but for character variable......
Yes, DN, you are right, so for Proc Sort:
proc sort data=have SORTSEQ=LINGUISTIC (numeric_collation=on)
by x; run;
Or if using Proc SQL:
proc sql;
create table want (drop=skey) as
select *, sortkey(x,'','','','NUMERIC','') as skey
from have
order by skey;
quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.