DATA Step, Macro, Functions and more

Macro for standardizing for age in IRR SAS 9.2

Reply
New Contributor
Posts: 3

Macro for standardizing for age in IRR SAS 9.2

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

Super User
Posts: 17,863

Re: Macro for standardizing for age in IRR SAS 9.2

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

New Contributor
Posts: 3

Re: Macro for standardizing for age in IRR SAS 9.2

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

Super User
Posts: 17,863

Re: Macro for standardizing for age in IRR SAS 9.2

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

New Contributor
Posts: 3

Re: Macro for standardizing for age in IRR SAS 9.2

Thank you so much Reeza! This helps a lot!

Chloe

Ask a Question
Discussion stats
  • 4 replies
  • 383 views
  • 6 likes
  • 2 in conversation