sorting varaible

[rakeshvvv]

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

[Haikuo · Accepted solution]

proc sort data=have SORTSEQ=LINGUISTIC;

by x; run;

[data_null__]

Do you need numeric_collation sub-option?

[rakeshvvv]

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......

[Haikuo]

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;