Hi,
The variable lab_pred is a binary variable indicating whether or not the person works (1=work).
Edu, sex, and agegr are categorical variables for the education (4 categories: 0,1,2,3), sex (two categories: 0,01) and age groups (from 15 to 70 by 5 years). For each combination of sex*edu*agegr, I want to calculate the proportion that works and the lower and upper bounds.
To produce this outcomes, I use the following code, but it produces a different table for each sub-category of sex*edu*agegr.
proc sort data=work.predict2; by sex edu agegr; run;
proc freq data=work.predict2;
table lab_pred /nocol nofreq nopercent binomial (CL=Wald(correct));
by sex edu agegr;
run;
How can I generate an output that will look like:
Sex
Agegr
Edu
% lab_pred=1
Lower CI
Upper CI
0
15
0
0
15
1
0
15
2
0
15
3
…
…
…
1
70
3
... View more