topic Re: Sort values in a row in SAS Programming

Sort values in a row

SASPhile — Mon, 16 Jul 2018 17:17:45 GMT

The values in a column could as follows:

ColA

a;b;c

b;a;c

b;c;a

How to reorder the colA like below:

ColA

a;b;c

Re: Sort values in a row

Reeza — Mon, 16 Jul 2018 17:26:59 GMT

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().

CALL SORTC(var1, var2, var3).

Re: Sort values in a row

ballardw — Mon, 16 Jul 2018 17:31:14 GMT

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.