Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
Standardized Mortality Rate by Strata
This assignment teaches you a little more about reading in data with SAS and also how to compute standardized mortality rates both overall and by strata.
In Part A, you will compute the SMR for skin cancer and compare that to the US as the reference population. In Part B, you will compute the SMR stratified by age. Complete code is given below. Refer to the link in the livebinder for a video explaining each statement.
1. Run the code for the two analyses.
2. Answer this question referring to your results? Does the first analysis show a difference in SMR for skin cancer between Florida and the US as a whole?
3. Answer this question referring to your results? Does the second analysis, by strata, show a difference in SMR for skin cancer between Florida and the US as a whole?
/* Assignment 5: PROC STDRATE */
/* Part A: Comparing Florida to US */
DATA florida_all ;
event_f = 538 ;
total_f = 15658227 ;
DATA us_all ;
event_u = 7420 ;
total_u = 281422206 ;
PROC STDRATE DATA=florida_all REFDATA=us_all
METHOD=INDIRECT
STAT=RATE(MULT=100000)
PLOTS=ALL;
POPULATION EVENT=event_f TOTAL=total_f;
REFERENCE EVENT=event_u TOTAL=total_u;
/* Part B: Comparing Florida to US */
/* By Strata */
DATA florida;
INPUT Age $1-5 Event PYear comma11.;
DATALINES;
00-04 0 953,785
05-14 0 1,997,935
15-24 4 1,885,014
25-34 14 1,957,573
35-44 43 2,356,649
45-54 72 2,088,000
55-64 70 1,548,371
65-74 126 1,447,432
75-84 136 1,087,524
85+ 73 335,944
;
DATA US;
INPUT Age $1-5 Event comma7. PYear comma12.;
DATALINES ;
00-04 0 19,175,798
05-14 1 41,077,577
15-24 41 39,183,891
25-34 186 39,892,024
35-44 626 45,148,527
45-54 1,199 37,677,952
55-64 1,303 24,274,684
65-74 1,637 18,390,986
75-84 1,624 12,361,180
85+ 803 4,239,587
;
PROC STDRATE DATA=Florida REFDATA=US
METHOD=INDIRECT
STAT=RATE(MULT=100000)
PLOTS=ALL
;
POPULATION EVENT=Event total=PYear;
REFERENCE EVENT=Event total=PYear;
STRATA Age / STATS SMR;
RUN;