topic Re: proc sort in SAS Procedures

proc sort

Golf — Sat, 18 Jul 2020 14:58:41 GMT

Hello,

I have the following data set.

How do I sort the data based on the Capacity which is the string variable? (I want to order descending capacity)

I tried the following codes, but it provide the same output:

proc sort data= stats2 SORTSEQ= LINGUISTIC  ;
by capacity;
run;

Thank You.

ketpt42 — Sat, 18 Jul 2020 15:06:54 GMT

You're probably better off extracting the number out of your Capacity column using the scan function instead of trying to do a linguistic sort.

smantha — Sat, 18 Jul 2020 15:22:07 GMT

Linguistic sort is a dictionary order meaning 10 -19 comes right after 1.

FreelanceReinh — Sat, 18 Jul 2020 15:31:44 GMT

Hello @Golf,

Just add the collating option NUMERIC_COLLATION=ON:

proc sort data=stats2 sortseq=linguistic(numeric_collation=on);

Golf — Sat, 18 Jul 2020 15:39:44 GMT

Thank you so much.
Bests,