topic Re: Sorting complex folder names in SAS Programming

Sorting complex folder names

jacksonan123 — Sat, 09 Jan 2021 14:32:00 GMT

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?

Re: Sorting complex folder names

novinosrin — Sat, 09 Jan 2021 14:39:55 GMT


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

Re: Sorting complex folder names

data_null__ — Sat, 09 Jan 2021 15:46:10 GMT

There is an option for that.

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

Re: Sorting complex folder names

novinosrin — Sat, 09 Jan 2021 15:47:37 GMT

Much thanks guru @data_null__ as always.

Re: Sorting complex folder names

jacksonan123 — Sat, 09 Jan 2021 16:47:00 GMT

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

Re: Sorting complex folder names

Ksharp — Sun, 10 Jan 2021 10:55:06 GMT

Could be simpler as :

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

Re: Sorting complex folder names

jacksonan123 — Sun, 10 Jan 2021 14:49:00 GMT

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