Sort based on number in a string of characters

[ArchanaSudhir]

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

[Haikuo · Accepted solution]

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;

[ArchanaSudhir]

Thanks, it works like magic:)

[Steelers_In_DC]

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