I desperately need help with this program! I can't seem to get the last section (In bold) to work. I know that the 'value' step won't work, but I don't know what to use that will let me change BMI value. I originally had this as a proc format step, but that ended up with my label changes interrupting my variable changes. PLEASE HELP!
Data female_pr;
Input Gender $1-6 Height $8-9 Weight $11-13 Rate_before $14-17 Rate_after $19-21 ;
Datalines;
female 68 140 96 124
female 56 125 90 127
female 69 118 70 85
female 160 88 115
female 65 140 76 93
female 62 110 68 122
female 63 127 65
female 64 160 87 115
female 70 170 53 39
female 66 200 60 78
female 63 120 127
female 60 138 84 107
female 66 236 64 71
female 65 230 104 102
female 68 130 82 116
Run;
Run;
Proc print data=female_pr;
Run;
Data male_pr;
Input Gender $1-6 Height $7-9 Weight $11-13 Rate_before $14-17 Rate_after $19-21 ;
Datalines;
male 72 185 61 96
male 76 160 85 97
male 75 200 38 68
male 73 145 79 98
male 73 200 54 82
male 73 235 78 90
male 74 155 60 80
male 61 183 55 64
male 69 160 67 100
male 72 140 54 71
male 73 170 65 106
male 72 265 63 96
Run;
Run;
Proc print data= male_pr;
Run;
Data pulserate;
Input Gender $1-6 Height $8-9 Weight $11-13 Rate_before $14-17 Rate_after $19-21 ;
Datalines;
female 65 140 76 93
female 62 110 68 122
female 63 127 65 83
female 64 160 87 115
female 70 170 53 39
female 66 200 60 78
male 73 235 78 90
male 74 155 60 80
male 61 183 55 64
male 69 160 67 100
male 72 140 54 71
male 73 170 65 106
male 72 265 63 96
Run;
Run;
Proc print data=pulserate;
Run;
Data comb_rate;
Set female_pr male_pr pulserate;
if gender='male' then
do;
BMI=703*weight/(height*height);
end;
if gender='female' then
do;
BMI=695*weight/(height*height);
end;
Rate_change=rate_after-rate_before;
run;
proc print data=comb_rate;
run;
data format;
label rate_change='Pulse Rate Change'
BMI='Body Mass Index';
value bmifmt
Low-25='Normal'
26-35 ='Low Risk'
36-High='High Risk';
run;
proc print data=comb_rate;
FORMAT BMI bmifmt.;
run;
Click image to register for webinar
