topic Re: Age standardized rate in SAS Procedures

Age standardized rate

knselina — Wed, 27 Feb 2019 20:12:28 GMT

Hi , I have run following program. Can anybody of this group run examine this program and help met o understand its interpretation.

Thank you

Selina

----------

data CAN_11;
input Age $1-5 Event PYear ;
datalines;
00-04 0 926252
05-09 0 882186
10-14 0 931354
15-19 0 1092368
20-24 20 1160880
25-29 70 1181076
30-34 135 1167005
35-39 185 1138694
40-44 185 1190523
45-49 185 1350322
50-54 135 1341093
55-59 130 1179520
60-64 110 1036627
65-69 80 787985
70-74 50 610955
75-79 45 503555
80-84 45 410520
85-89 20 277374
90+ 5 158532
;

data BD_Avg11;
input Age $1-5 Event PYear ;
datalines;
00-04 0 1914
05-09 0 1736
10-14 0 1586
15-19 0 1593
20-24 0 1506
25-29 0.1 1465
30-34 0.2 1325
35-39 0.5 1070
40-44 0.3 1008
45-49 0.2 876
50-54 0.2 725
55-59 0.1 554
60-64 0.1 396
65-69 0 245
70-74 0 130
75-79 0 77
80-84 0 43
85-89 0 13
90+ 0 11
;
ods graphics on;
proc stdrate data=BD_Avg11 refdata=CAN_11
method=indirect
stat=rate(mult=100000)
plots=all
;
population event=Event total=PYear;
reference event=Event total=PYear;
strata Age / stats smr;
run;
ods graphics off;

Re: Age standardized rate

ChrisHemedinger — Wed, 27 Feb 2019 20:25:46 GMT

I'll bet that @Reeza can explain it...because it looks very similar to something else that she has shared in the past....very similar.

It might help if you explain the context in which you're running this.

Re: Age standardized rate

Reeza — Wed, 27 Feb 2019 20:46:30 GMT

Thanks Chris.

@knselina if you take a look at the version of code I have linked below, it's commented pretty thoroughly, explaining what each line/option does. If you have questions beyond that, please post back the details.

https://gist.github.com/statgeek/9606454

In general, you're calculating an age-standardized rate using the Canadian 2011 census data (a guess).

The number should be represented as per 100,000 population, not per capita.

If you want to run either of these and test it, there are two free versions of SAS available. One runs in the cloud, SAS Academics on Demand and the other version, SAS UE, needs to be installed on your machine.