Macro for standardizing for age in IRR SAS 9.2

[chloeb]

Hi,

I am currently trying to standardize IRR by age and sex. However my current version, SAS 9.2 does not have the Proc STDRATE statement. I am unsure of how I can generate standardized IRR without this procedure.

If you have a macro or know how to standardize ratios, please advise.

Thank you,

Chloe

[Reeza]

It's a fairly simple data step calculation if you have the data. But what version of SAS/STAT are you on?

I like this paper because it has worked examples so its easy to see the logic of how to standardize your rates.

http://www.apheo.ca/resources/indicators/Standardization%20report_NamBains_FINALMarch16.pdf

[chloeb]

Thank you Reeza! I am currently using SAS version 9.2.

Do you have any resources for coding the standardization of incidence rate ratios? I think I understand the basic logic of standardizing by age, however, I am at loss at finding a SAS code.

Thanks again,

Chloe

[Reeza]

If you're looking for a macro then I don't have one, but I'm sure they're out there.

Realistically, I'd just write my code, because its so straight forward. You'd have to test and decode the macro.

Here's a few options:

http://www.sas.com/offices/NA/canada/downloads/UserGroups/Health-UG-April11/SAS_HUG_Ash.pdf

http://www.lexjansen.com/wuss/2007/CodersCorner/COD_Zheng_AddingTheFeature.pdf

http://www.lexjansen.com/mwsug/2005/Pharmaceutical_Healthcare/PH600.pdf

GOOGLE Search : Age Standardization site:lexjansen.com

[chloeb]

Thank you so much Reeza! This helps a lot!

Chloe