topic Re: Datalines - re-order variables in each observation in ascending order in SAS Programming

Datalines - re-order variables in each observation in ascending order

jeremy4 — Wed, 28 Aug 2019 15:16:29 GMT

Hi,

I have created the following temporary "sorted" dataset. Would it be possible to provide me with code so that the variables within each observation are in ascending order (example output below)? Thanks!

Code

data sorted;

input var1-var6;

datalines;

23 2 43 55 1 6

132 3 23 67 45 2

11 99 101 24 96 44

44 1 1276 1734 1599 1921

;

run;

Output wanted

Obs var1 var 2 var3 var4 var5 var6

1 1 2 6 23 43 55

2 2 3 23 45 67 132

3 1 24 44 96 99 101

4 1 44 1276 1599 1734 1921

Re: Datalines - re-order variables in each observation in ascending order

Reeza — Wed, 28 Aug 2019 15:24:30 GMT

CALL SORTN.

data sorted;

   input var1-var6;
  call sortn(of var1-var6);
[rest of your code]
run;

@jeremy4 wrote:

Hi,

I have created the following temporary "sorted" dataset. Would it be possible to provide me with code so that the variables within each observation are in ascending order (example output below)? Thanks!

Code

data sorted;

   input var1-var6;

   datalines;

     23 2 43 55 1 6

     132 3 23 67 45 2

     11 99 101 24 96 44

     44 1 1276 1734 1599 1921

     ;

run;

Output wanted

Obs var1        var 2         var3        var4        var5       var6

1       1              2                6            23           43           55

2       2               3               23           45           67          132

3       1              24              44           96           99          101

4       1              44            1276       1599       1734       1921

Re: Datalines - re-order variables in each observation in ascending order

jeremy4 — Wed, 28 Aug 2019 15:29:16 GMT

Thanks a lot for your help!