DATA Step, Macro, Functions and more

Sort values in a row

Reply
Super Contributor
Posts: 717

Sort values in a row

 

 

The values in a column could as follows:

 

ColA

a

a;b;c

b;a;c

b;c;a

 

How to reorder the colA like below:

 

ColA

a

a;b;c

a;b;c

a;b;c

 

 

 

 

Super User
Posts: 24,010

Re: Sort values in a row

If they're all in one variable you need to first separate them and then use CALL SORTC(). 

You can separate them using SCAN() and recombine using CATX(). 

 

Ie

CALL SORTC(var1, var2, var3).

Super User
Posts: 13,941

Re: Sort values in a row

And if anyone earlier made a comment about "why stick multiple values into a single value" you just discovered one of the reasons the question was asked.

Ask a Question
Discussion stats
  • 2 replies
  • 58 views
  • 0 likes
  • 3 in conversation