Help using Base SAS procedures

proc sort character variables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

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

ideal

sequence

q2q1q1
q3q10q2
q4q2q3
q5q3q4
q1q4q5
q7q5q6
q10q6q7
q8q7q8
q9q8q9
q6q9q10

Accepted Solutions
Solution
‎11-16-2012 11:08 AM
PROC Star
Posts: 7,363

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;

View solution in original post


All Replies
Solution
‎11-16-2012 11:08 AM
PROC Star
Posts: 7,363

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: 9,677

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 261 views
  • 1 like
  • 3 in conversation