|
low = min(of var:) *or low = min(of var1,var2,var3,var4) or whatever
convenient list you have;
Getting the variable name is more complicated; I suppose the most
straightforward way is
data test;
input
var1 var2 var3 var4;
datalines;
20 30 15 40
17 50 25 30
;;;;
run;
data want;
set test;
array vars var:;
low = min(of var:);
do _n_ = 1 to dim(vars) until (vars[_n_] = low);
end;
low_var = vname(vars[_n_]);
run;
which is sort of cheating and not particularly fast, but I can't think of a
better way off the top of my head.
-Joe
On Mon, Apr 27, 2009 at 3:15 PM, Sclavid Raj <sskonda@aol.com> wrote:
> Hello all,
>
> I have four variables and 2000 obs. I need to get the lowest value in each
> observation (row) among four variables in a separate variables for lowest
> value, as well as that variable name.
>
> Here is the example:
>
> var1 var2 var3 var4
> 20 30 15 40
> 17 50 25 30
> . .
> . .
> . .
>
> Output should be like this;
> var1 var2 var3 var4 low low_var
> 20 30 15 40 15 var3
> 17 50 25 30 17 var1
> . .
> . .
> . .
>
> I think i am clear.
>
> Thanks in advacne.
>
> Sclavid.
>
| 
