Help using Base SAS procedures

Group option with PROC STDRATE when using indirect method

Reply
Occasional Contributor
Posts: 13

Group option with PROC STDRATE when using indirect method

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.

 

http://www.dartmouthatlas.org/downloads/methods/indirect_adjustment.pdf

 

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!

 

Ask a Question
Discussion stats
  • 0 replies
  • 210 views
  • 0 likes
  • 1 in conversation