12-08-2015 09:14 AM
I would like to reproduce this simple example using PROC STDRATE. I do not see any way to specify a group option when using the indirect standardization method.
Here is my code so far.
data counts; input area $ age $ death denom ; datalines; Area1 65-69 6 500 Area1 70-74 15 300 Area1 75-79 20 200 Area2 65-69 3 300 Area2 70-74 12 300 Area2 75-79 36 400 ; proc sql; create table aggregate as select age, sum(death) as death, sum(denom) as denom from counts group by age; quit; /* I need an option to group by area */ proc stdrate data=counts refdata=aggregate method=indirect stat=rate(mult=100) ; population event=death total=denom; reference event=death total=denom; strata Age; run;
Thanks for your help!