The STDRATE Procedure

Getting Started: STDRATE Procedure

(View the complete code for this example.)

This example illustrates indirect standardization and uses the standardized mortality ratio to compare the death rate from skin cancer between people who live in the state of Florida and people who live in the United States as a whole.

The Florida_C43 data set contains the stratum-specific mortality information for skin cancer in year 2000 for the state of Florida (Florida Department of Health 2000, 2013). The variable Age is a grouping variable that forms the strata in the standardization, and the variables Event and PYear identify the number of events and total person-years, respectively. The COMMA9. format is specified in the DATA step to input numerical values that contain commas in PYear.

data Florida_C43;
   input Age $1-5 Event PYear:comma9.;
   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
;

The US_C43 data set contains the corresponding stratum-specific mortality information for the United States in year 2000 (Miniño et al. 2002; US Bureau of the Census 2011). The variable Age is the grouping variable, and the variables Event and PYear identify the number of events and the total person-years, respectively.

data US_C43;
   input Age $1-5 Event:comma5. PYear:comma10.;
   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
;

The following statements invoke the STDRATE procedure and request indirect standardization to compare death rates between the state of Florida and the United States:

ods graphics on;
proc stdrate data=Florida_C43 refdata=US_C43
             method=indirect
             stat=rate(mult=100000)
             plots=all
             ;
   population event=Event total=PYear;
   reference  event=Event total=PYear;
   strata Age / stats smr;
run;

The DATA= and REFDATA= options name the study data set and reference data set, respectively. The METHOD=INDIRECT option requests indirect standardization. The STAT=RATE option specifies the rate as the frequency measure for standardization, and the MULT=100000 suboption (which is the default) displays the rates per 100,000 person-years in the table output and graphics output. The PLOTS=ALL option requests all appropriate plots with indirect standardization.

The POPULATION statement specifies the options that are related to the study population, and the EVENT= and TOTAL= options specify variables for the number of events and person-years in the study population, respectively.

The REFERENCE statement specifies the options related to the reference population, and the EVENT= and TOTAL= options specify variables for the number of events and person-years in the reference population, respectively.

The STRATA statement lists the variable Age that forms the strata. The STATS option requests a strata information table that contains stratum-specific statistics such as rates, and the SMR option requests a table of stratum-specific SMR estimates.

The "Standardization Information" table in Figure 109.1 displays the standardization information.

Figure 109.1: Standardization Information

The STDRATE Procedure

Standardization Information
Data SetWORK.FLORIDA_C43
Reference Data SetWORK.US_C43
MethodIndirect Standardization
StatisticRate
Number of Strata10
Rate Multiplier100000


The STATS option in the STRATA statement requests that the "Indirectly Standardized Strata Statistics" table in Figure 109.2 display the strata information and expected number of events at each stratum. The MULT=100000 suboption in the STAT=RATE option requests that crude rates per person-years be displayed. The Expected Events column displays the expected number of events when the stratum-specific rates in the reference data set are applied to the corresponding person-years in the study data set.

Figure 109.2: Strata Information (Indirect Standardization)

The STDRATE Procedure

Indirectly Standardized Strata Statistics
Rate Multiplier = 100000
Stratum
Index
AgeStudy PopulationReference PopulationExpected
Events
Observed
Events
Population-TimeCrude RateStandard
Error
 Population-TimeCrude
Rate
ValueProportion95% Normal Confidence
Limits
ValueProportion
100-0409537850.06090.00000.000000.00000.0000191757980.06810.00000.000
205-14019979350.12760.00000.000000.00000.0000410775770.14600.00240.049
315-24418850140.12040.21220.106100.00420.4202391838910.13920.10461.972
425-341419575730.12500.71520.191140.34051.0898398920240.14180.46639.127
535-444323566490.15051.82460.278251.27932.3700451485270.16041.386532.676
645-547220880000.13333.44830.406382.65184.2448376779520.13393.182266.445
755-647015483710.09894.52090.540353.46185.5799242746840.08635.367783.112
865-7412614474320.09248.70510.775517.185110.2250183909860.06548.9011128.837
975-8413610875240.069512.50551.0723410.403714.6072123611800.043913.1379142.878
1085+733359440.021521.72982.5432816.745126.714642395870.015118.940563.630


With ODS Graphics enabled, the PLOTS=ALL option displays all appropriate plots. With indirect standardization and a rate statistic, these plots include the strata distribution plot, the strata rate plot, and the strata SMR plot. By default, strata levels are displayed on the vertical axis for these plots.

The strata distribution plot displays proportions for stratum-specific person-years in the study and reference populations, as shown in Figure 109.3.

Figure 109.3: Strata Distribution Plot

Strata Distribution Plot


The strata distribution plot displays the proportions in the "Indirectly Standardized Strata Statistics" table in Figure 109.2. In the plot, the proportions of the study population are identified by the blue lines, and the proportions of the reference population are identified by the red lines. The plot shows that the study population has higher proportions in older age groups and lower proportions in younger age groups than the reference population.

The strata rate plot displays stratum-specific rate estimates in the study and reference populations, as shown in Figure 109.4. This plot displays the rate estimates in the "Indirectly Standardized Strata Statistics" table in Figure 109.2. In addition, the plot displays the confidence limits for the rate estimates in the study population and the overall crude rates for the two populations.

Figure 109.4: Strata Rate Plot

Strata Rate Plot


The SMR option in the STRATA statement requests that the "Strata SMR Estimates" table in Figure 109.5 display the strata SMR at each stratum. The MULT=100000 suboption in the STAT=RATE option requests that the reference rates per person-years be displayed.

Figure 109.5: Strata SMR Information

Strata SMR Estimates
Rate Multiplier = 100000
Stratum
Index
AgeStudy PopulationReference
Crude
Rate
Expected
Events
SMRStandard
Error
 
Observed
Events
Population-
Time
95% Normal Confidence
Limits
100-0409537850.00000.000....
205-14019979350.00240.0490.0000...
315-24418850140.10461.9722.02801.01400.04064.0154
425-341419575730.46639.1271.53390.40990.73042.3373
535-444323566491.386532.6761.31600.20070.92261.7093
645-547220880003.182266.4451.08360.12770.83331.3339
755-647015483715.367783.1120.84220.10070.64491.0395
865-7412614474328.9011128.8370.97800.08710.80721.1487
975-84136108752413.1379142.8780.95190.08160.79191.1118
1085+7333594418.940563.6301.14730.13430.88411.4104


The "Strata SMR Estimates" table shows that although SMR is less than 1 only at three age strata (55–64, 65–74, and 75–84), these three strata contain about of the total events.

The strata SMR plot displays stratum-specific SMR estimates with confidence limits, as shown in Figure 109.6. The plot displays the SMR estimates in the "Strata SMR Estimates" table in Figure 109.5.

Figure 109.6: Strata SMR Plot

Strata SMR Plot


The METHOD=INDIRECT option requests that the "Standardized Morbidity/Mortality Ratio" table in Figure 109.7 be displayed. The table displays the SMR, its confidence limits, and the test for the null hypothesis . The default ALPHA=0.05 option requests that confidence limits be constructed.

Figure 109.7: Standardized Morbidity/Mortality Ratio

Standardized Morbidity/Mortality Ratio
Observed
Events
Expected
Events
SMRStandard
Error
95% Normal Confidence
Limits
ZPr > |Z|
538528.7261.01750.04390.93161.10350.400.6893


The normal confidence limits contain the null hypothesis value , and the hypothesis of is not rejected at the level from the normal test.

The "Indirectly Standardized Rate Estimates" table in Figure 109.8 displays the indirectly standardized rate and related statistics.

Figure 109.8: Standardized Rate Estimates (Indirect Standardization)

Indirectly Standardized Rate Estimates
Rate Multiplier = 100000
Study PopulationReference
Crude
Rate
Expected
Events
SMRStandardized Rate
Observed
Events
Population-
Time
Crude
Rate
EstimateStandard
Error
95% Normal Confidence
Limits
538156582273.43592.6366528.7261.01752.68290.11572.45622.9096


The indirectly standardized rate estimate is the product of the SMR and the crude rate estimate for the reference population. The table shows that although the crude rate in the state of Florida (3.4359) is higher than the crude rate in the U.S. (2.6366), the resulting standardized rate (2.6829) is close to the crude rate in the U.S.