SAS 6: Computing SMR
Standardized Mortality Rate by Strata (SMR)
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.
1. Run the code for the two analyses.
2. Answer this question refe
ing 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 refe
ing 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 = XXXXXXXXXX ;
DATA us_all ;
  event_u = 7420 ;
  total_u = XXXXXXXXXX ;
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;
An Attachment of the results from this code is done for you already.
Results_ Program 1