## proc sort character variables

Solved
Occasional Contributor
Posts: 7

# proc sort character variables

Hello everyone, I have a question regarding proc sort. Anyone can help? Thanks in advance!

For example I have a dataset "survey", and a character variable "question" and want to sort it.

I hope to get the ideal sequence order, but I got the sorted sequence in the middle column. I wonder whether it is possible to get the ideal sequence in SAS? Thanks!!!

proc sort data=survey;

by question;

run;

 original sequence after sorting idealsequence q2 q1 q1 q3 q10 q2 q4 q2 q3 q5 q3 q4 q1 q4 q5 q7 q5 q6 q10 q6 q7 q8 q7 q8 q9 q8 q9 q6 q9 q10

Accepted Solutions
Solution
‎11-16-2012 11:08 AM
PROC Star
Posts: 8,165

## Re: proc sort character variables

I think you are looking for the following:

data survey;

input question \$;

cards;

q2

q3

q4

q5

q1

q7

q10

q8

q9

q6

;

proc sort data=survey SORTSEQ=linguistic

(NUMERIC_COLLATION=ON);

by question;

run;

All Replies
Solution
‎11-16-2012 11:08 AM
PROC Star
Posts: 8,165

## Re: proc sort character variables

I think you are looking for the following:

data survey;

input question \$;

cards;

q2

q3

q4

q5

q1

q7

q10

q8

q9

q6

;

proc sort data=survey SORTSEQ=linguistic

(NUMERIC_COLLATION=ON);

by question;

run;

Occasional Contributor
Posts: 7

## Re: proc sort character variables

Hi Authur,

This is exactly what I wanted. Thank you so much!!!

Yanmin

Super User
Posts: 10,787

## Re: proc sort character variables

Or a SQL way which has more power.

```data survey;
input question \$;
cards;
q2
q3
q4
q5
q1
q7
q10
q8
q9
q6
;
run;
proc sql;
create table want as
select * from survey order by input(compress(question, ,'kd'),best8.);
quit;

```

Ksharp

Occasional Contributor
Posts: 7

## Re: proc sort character variables

Thank you so much, Ksharp!

Your Sql code works very well. It is great to know both methods work.

🔒 This topic is solved and locked.