topic Re: Creating a column based on max values of row in SAS Programming

Creating a column based on max values of row

Siddharth123 — Sat, 23 Jul 2016 21:29:09 GMT

Hi All,

I am stuck in a problem of creating a single column data (B) which depends on the max value in each row of original data (A). Data A is -

Data A:

v1   v2   v3    v4
1      2   3       4
2      3   4       1
6      7   2       4

Data B should take the max from each row of Data A and then create the corresponding column as value in Data B:

Col

Is this possible to do?

Re: Creating a column based on max values of row

KachiM — Sat, 23 Jul 2016 21:55:53 GMT

Here is a way.

data want;
   length Col $32;
   set have;
   array k[*] V1 - V4;
   Max = Max(of k[*]);
   Pos = whichN(Max, of k[*]);
   Col = vname(k[Pos]);
keep Col;
run;

Hope this is an acceptable answer.

Re: Creating a column based on max values of row

Reeza — Sun, 24 Jul 2016 01:43:52 GMT

What if you have ties?

Data A:

v1   v2   v3    v4
1      2   3       4
2      3   4       1
6      7 4 4

Re: Creating a column based on max values of row

Ksharp — Sun, 24 Jul 2016 02:26:30 GMT

It is IML thing:


data DataA;
input v1    v2    v3    v4;
cards;
1      2     3       4
2      3     4       1
6      7     2       4
;
run;
proc iml;
use DataA;
read all var _num_ into x[c=vnames];
close;
col=vnames[x[,<:>]];
create max from col;
append from col;
close;
quit;
data want;
 merge DataA Max;
run;