topic Re: Proc sort (ascending) takes 11 12 13, etc. before 2 in SAS Procedures

Proc sort (ascending) takes 11 12 13, etc. before 2

Mistervv — Tue, 29 Jul 2014 14:11:37 GMT

Hello, first time user for a couple of weeks now and have an issue with the SORT function.

When I sort by var (which is numeric, 1 until 13) I get:

etc.

In my other similar database I didn't have this issue, strange. Anyone knows how to fix this? Here's the basic code:

Proc sort data = data out = sorteddata;

by variable;

RUN;

Thanks.

Re: Proc sort (ascending) takes 11 12 13, etc. before 2

RW9 — Tue, 29 Jul 2014 14:21:34 GMT

It doesn't look like a numeric I am afraid. It looks like that variable is a character, hence it Is sorting textually.

Re: Proc sort (ascending) takes 11 12 13, etc. before 2

Ksharp — Tue, 29 Jul 2014 14:34:10 GMT

There is an option in proc sort can do that ,you need to check documentation . another way is sql.

Here is :

NUMERIC_COLLATION=on

Message was edited by: xia keshan

Re: Proc sort (ascending) takes 11 12 13, etc. before 2

Mistervv — Tue, 29 Jul 2014 14:43:16 GMT

I just ran a PROC CONTENTS and you're right. I find it strange it switched to Char, since it was Num in my main database, but thanks!

Re: Proc sort (ascending) takes 11 12 13, etc. before 2

Mistervv — Tue, 29 Jul 2014 15:26:21 GMT

Where do I put this in my code? Just out of curiosity. I just changed my variable to numeric by multiplying it by 1 now. Thanks.

Re: Proc sort (ascending) takes 11 12 13, etc. before 2

scmebu — Wed, 30 Jul 2014 13:01:43 GMT

data test;
 length v $ 3;
 input v;
 cards;
1
10
11
12
13
2
3
4
5
6
;
run;

proc sort data=test sortseq=linguistic(numeric_collation=on);
by v;
run;

proc print data=test;
run;