get then minimum value when you have missing values

[michtka]

  Dear all, I have been off for a while.

I hope you can help me with this:

I've got the next dataset:

var 1 var2 var3 var4   result

20    30    40    .         20

.      .       10   30       10

30   10     40   20       10

5     10     15   .          5

I want to obtain the result variable, minimum of (var1,var2,var3 and var4):

For example, in raw 3 is easy because there are not missing values, then

if nmiss(var1,var2,var3,var4) =0 then result=min(var1,var2,var3,var4).

My question is, How can I get the variable result when I have missing values?

I appreciate your help.

Thanks,

V.

[pradeepalankar · Accepted solution]

Hi ,

you can use min function even if inbetween variables are missing.

The MIN function returns a missing value (.) only if all arguments are missing.

data test;

input var1-var4 ;

result=min(of var1-var4);

cards;

20 30 40 .

. . 10 30

30 10 40 20

5 10 15 .

;

run;