I have a simple question that I can't seem to answer. I want to create and calculate a new variable IBW using 4 different equations. Choice of equations depends on 2 other variables 1) sex and 2) heightin (categorized as less than or greater or equal to 60) When I use the following code, the variable IBW is generated but the calculation is not performed (value is missing for all observations) without an error message. data b;
set a;
heightin = height/ 2.54;
IBW = .;
if sex = 'F' and heightin lt 60 then IBW = (45 - (60- (heightin*2.3)));
if sex = 'F' and heightin ge 60 then IBW = (45 + ((heightin-60)*2.3));
if sex = 'M' and heightin lt 60 then IBW = (50 - (60- (heightin*2.3)));
if sex = 'M' and heightin ge 60 then IBW = (50 + ((heightin-60)*2.3));
run;
... View more