So I calculated the totals as such:
proc sql noprint;
select sum(A_N_ALL) into :EthnicA trimmed from catdem where CAT = 1;
select sum(B_N_ALL) into :EthnicB trimmed from catdem where CAT = 1;
select sum(A_N_ALL) into :RaceA trimmed from catdem where CAT = 2;
select sum(B_N_ALL) into :RaceB trimmed from catdem where CAT = 2;
select sum(A_N_OBESE) into :ObeseA trimmed from catdem where CAT = 1;
select sum(B_N_OBESE) into :ObeseB trimmed from catdem where CAT = 1;
select sum(A_N_NOT_OBESE) into :NotObeseA trimmed from catdem where CAT = 1;
select sum(B_N_NOT_OBESE) into :NotObeseB trimmed from catdem where CAT = 1;
select sum(A_N_SEVERELY_OBESE) into :SeverelyObeseA trimmed from catdem where CAT = 1;
select sum(B_N_SEVERELY_OBESE) into :SeverelyObeseB trimmed from catdem where CAT = 1;
run;
With these results in the log:
3397 %put &=EthnicA &=RaceA &=EthnicB &=RaceB; /*totals match up*/
ETHNICA=120 RACEA=120 ETHNICB=20 RACEB=20
3398 %put &=ObeseA &=ObeseB &=NotObeseA &=NotObeseB $=SeverelyObeseA &=SeverelyObeseB;
OBESEA=24 OBESEB=2 NOTOBESEA=58 NOTOBESEB=12 $=SeverelyObeseA SEVERELYOBESEB=6
Now I want these totals to show up in the column titles when I run PROC REPORT.
Code:
proc report data = catdem nowd split = '*'
%reportStyle
column CAT CHAR
('Cohort A' ('BMI < 30 *kg/m ^{super 2} ^n (N = &&NotObeseA)' A_N_NOT_OBESE A_P_NOT_OBESE) ('30 ^{unicode 2264} BMI ^{unicode 2264}*kg/m ^{super 2} ^n (N = &&ObeseA)' A_N_OBESE A_P_OBESE) ('BMI > 40 *kg/m ^{super 2} ^n (N = &&SeverelyObeseA)' A_N_SEVERELY_OBESE A_P_SEVERELY_OBESE) ('All Subjects (N = &&EhtnicA)' A_N_ALL A_P_ALL))
('Cohort B' ('BMI < 30 *kg/m ^{super 2} ^n (N = &&NotObeseB)' B_N_NOT_OBESE B_P_NOT_OBESE) ('30 ^{unicode 2264} BMI ^{unicode 2264}*kg/m ^{super 2} ^n (N = &&ObeseB)' B_N_OBESE B_P_OBESE) ('BMI > 40 *kg/m ^{super 2} ^n (N = &&SeverelyObeseB)' B_N_SEVERELY_OBESE B_P_SEVERELY_OBESE) ('All Subjects (N = &&EhtnicB)' B_N_ALL B_P_ALL));
...When I do this, I get N = &&NotObeseA, etc. instead of N = 58. What can I do to fix this?
