topic Re: Sort based on number in a string of characters in SAS Procedures

Sort based on number in a string of characters

ArchanaSudhir — Wed, 02 Dec 2015 18:27:55 GMT

Hi,

I have a dataset which has the following values for cyclename variable.:

Cycle 1

Cycle 2

Cycle 3

Cycle 4

Cycle 5

Cycle 11

Cycle 12

When i SORT IT BY CYCLENAME, Cycle 11 and cycle 12 come before cycle 2,

Cycle 1

Cycle 11

Cycle 12

Cycle 2

Cycle 3

Cycle 4

Cycle 5

How do I fix this so that cycle 11 and 11 come at last?

Thanks,

Archana

Re: Sort based on number in a string of characters

Haikuo — Wed, 02 Dec 2015 19:05:16 GMT

You will need a special option in Proc Sort:

data have;
input var $10.;
cards;
Cycle 1
Cycle 11
Cycle 12
Cycle 2
Cycle 3
Cycle 4
Cycle 5
;

proc sort data=have out=want sortseq=linguistic(Numeric_Collation=ON);
by var;
run;

Re: Sort based on number in a string of characters

Steelers_In_DC — Wed, 02 Dec 2015 20:08:25 GMT

Here is another solution, although I like the proc sort option, that is new to me:

proc sql;
create table want as
select *
from have
order by input(scan(var,2,' '),8.);

Re: Sort based on number in a string of characters

ArchanaSudhir — Wed, 02 Dec 2015 20:25:04 GMT

Thanks, it works like magic:)