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.
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;
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.