Help using Base SAS procedures

get then minimum value when you have missing values

Accepted Solution Solved
Reply
Super Contributor
Posts: 301
Accepted Solution

get then minimum value when you have missing values

  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.


Accepted Solutions
Solution
‎03-26-2014 09:36 AM
Frequent Contributor
Posts: 106

Re: get then minimum value when you have missing values

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;

View solution in original post


All Replies
Solution
‎03-26-2014 09:36 AM
Frequent Contributor
Posts: 106

Re: get then minimum value when you have missing values

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 189 views
  • 0 likes
  • 2 in conversation