COH606 Epidemiology SAS 6: Computing SMR

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

SAS 6: Computing SMR

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;