topic Re: sorting varaible in SAS Procedures

sorting varaible

rakeshvvv — Mon, 24 Nov 2014 16:33:17 GMT

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 10

100010002 11

100010002 12

100010002 13

100010002 2

100010002 3

100010002 4

100010002 5

100010002 6

100010002 7

100010002 8

Re: sorting varaible

Haikuo — Mon, 24 Nov 2014 16:37:51 GMT

proc sort data=have SORTSEQ=LINGUISTIC;

by x; run;

Re: sorting varaible

data_null__ — Mon, 24 Nov 2014 18:17:32 GMT

Do you need numeric_collation sub-option?

Re: sorting varaible

rakeshvvv — Mon, 24 Nov 2014 18:35:39 GMT

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

Re: sorting varaible

Haikuo — Mon, 24 Nov 2014 19:44:17 GMT

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;