get then minimum value when you have missing values

michtka — Wed, 26 Mar 2014 13:20:22 GMT

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,

Re: get then minimum value when you have missing values

pradeepalankar — Wed, 26 Mar 2014 13:36:37 GMT

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;