Sorting complex folder names

[jacksonan123]

I have the following data under the variable name folder.

Folder

test1.nm7

test100.nm7

test1001.nm7

test2.nm7

test3.nm7

I would like to sort this data to give me the test in the following numerical order.

Folder

test1.nm7

test2.nm7

test3.nm7

test100.nm7

test1001.nm7

Can someone tell me how to do this?

[novinosrin · Accepted solution]

data have;
input var :$15.;
cards; 
test1.nm7

test100.nm7

test1001.nm7

test2.nm7

test3.nm7
;

proc sql;
 create table want as
 select *
 from have
 order by input(compress(scan(var,1,'.'),,'kd'),32.);
quit;

 The idea is to extract and sort the numerical part in the pattern. 

var
test1.nm7
test2.nm7
test3.nm7
test100.nm7
test1001.nm7

[data_null__]

There is an option for that.

proc sort sortseq=LINGUISTIC(NUMERIC_COLLATION=ON);
   by var;
   run;

[novinosrin]

Much thanks guru @data_null__  as always. 

[jacksonan123]

I will give it a try later but the prior post resolved the issue.

[Ksharp]

Could be simpler as :


select *
from have
order by input(scan(var,1,,'kd'),32.);

[jacksonan123]

It does work I had put in something wrong. I will accept it as a solution.