Need to calculate Age-std rates for more than 2 groups

karora1 — Sun, 16 Jan 2022 05:44:46 GMT

Hello I'm trying to calculate Age-std rates for a variety of geographies at once. I've used proc stdrate in the past to do my calculations in SAS for direct agestd rates but just realized that up until now I have often calculated the rates for two groups only in SAS. However this time I would like to calculate a death rate using the direct method but for all of the networks in our region (in this case 6 areas). The rate ratios are not needed but the rates and confidence intervals for each of the geographies is required. My code is the following

proc stdrate data=deathrategeo2
refdata=Can2011
method=direct
stat=rate(mult=100000)
cl = GAMMA;
population group = network_name  event=death total=Pop;
reference total=Pop;
strata age18up ;
title "Age std death rates by Network";
ods output StdRate = netstdrate;
run;

However, i get the following error message " At most two study populations can be used for METHOD=DIRECT" and the procedure isn't run. I know many people have to calculate direct age-std rates for more then 2 groups at a time, so there must be away to calculate it, but i can't seem to find the right way to do it.

Re: Need to calculate Age-std rates for more than 2 groups

karora1 — Sun, 16 Jan 2022 06:04:59 GMT

nevermind I found a "By" option that I can put in the network name and remove the group=networkname option.

topic Re: Need to calculate Age-std rates for more than 2 groups in Statistical Procedures

Need to calculate Age-std rates for more than 2 groups

Re: Need to calculate Age-std rates for more than 2 groups