**[2006]{#OLE_LINK6} Behavioral Risk Factor Surveillance System (BRFSS)
Metropolitan Area Data Weighting Methodology**

**Creation of Metropolitan-Level Weights**

[A documented and verified subset of the 2006 BRFSS has been produced to
provide some local area estimates. These local areas are identified as
metropolitan statistical areas (MSAs), primary metropolitan statistical
areas (PMSAs), or New England county metropolitan statistical areas
(NECMAs), as defined by the U.S. Office of Management and Budget and
used by the U.S. Census Bureau in 1999. In this report, all mentions of
metropolitan area refer to MSAs, PMSAs, and NECMAs. Detail information
on MSA, PMSA, and NECMA designations used by the U.S. Census Bureau used
in this analysis is available at ]{.underline}

[. The metropolitan area definitions used for this analysis were June
30, 1999, which are different from the definitions currently used in
SMART data. So, we called the definitions used this project as
historical metropolitan statistical areas. The reason for using old
definitions is to match the EPA data for it used the old definitions in
their datasets.]{.underline}

[The BRFSS 2006 metropolitan area data set was produced by adding new
analysis weights designed to correspond to the 2006 population estimates
for each eligible metropolitan area. The additional weights were
post-stratified to the metropolitan area level. The process by which
these new weights were obtained is detailed in Appendix C, "Weight Class
Collapsing Rules."]{.underline}

# [Selected Areas ]{.underline}

[Typically, BRFSS data are used to produce state-level estimates.
However, for this project, 2006 BRFSS data were used to produce
prevalence estimates for metropolitan areas. Estimates have been
produced for 110 metropolitan areas that have met the analysis criteria
for the 2006 data year. Missing county codes were imputed from a value
included in the purchased telephone sample that represents the county
most likely to be associated with the telephone number. ]{.underline}

**[Appendix A: Variables ]{.underline}[Added ]{.underline}[to
]{.underline}[2006]{.underline}[ Data]{.underline}**

[PMSACODE---Historical metropolitan area code of the MSA, PMSA, or
NECMA, if appropriate, in which the respondent lived. ]{.underline}

[\_PMSAWT---The new metropolitan area-level weight by historical
Metropolitan area code, which should be used when generating
metropolitan area-level estimates for questions that were asked of the
entire sample. ]{.underline}

**[Appendix B]{.underline}[: ]{.underline}[T]{.underline}[he
]{.underline}[110]{.underline}[ ]{.underline}[Areas ]{.underline}[with
]{.underline}[Metropolitan Area]{.underline}[-Level Weights
]{.underline}[in the ]{.underline}[2006]{.underline}[
]{.underline}[BRFSS, with MSA, PMSA, or NECMA]{.underline}[ Codes and
Names]{.underline}**

  ------------------------ ---------------------------------------------------------------
  [MSA CODE]{.underline}   [MSA NAME]{.underline}
  [0080]{.underline}       [Akron, OH PMSA]{.underline}
  [0200]{.underline}       [Albuquerque, NM MSA]{.underline}
  [0520]{.underline}       [Atlanta, GA MSA]{.underline}
  [0560]{.underline}       [Atlantic-Cape May, NJ PMSA]{.underline}
  [0600]{.underline}       [Augusta-Aiken, GA-SC MSA]{.underline}
  [0640]{.underline}       [Austin-San Marcos, TX MSA]{.underline}
  [0720]{.underline}       [Baltimore, MD PMSA]{.underline}
  [0760]{.underline}       [Baton Rouge, LA MSA]{.underline}
  [0875]{.underline}       [Bergen-Passaic, NJ PMSA]{.underline}
  [0920]{.underline}       [Biloxi-Gulfport-Pascagoula, MS MSA]{.underline}
  [1000]{.underline}       [Birmingham, AL MSA]{.underline}
  [1010]{.underline}       [Bismarck, ND MSA]{.underline}
  [1080]{.underline}       [Boise City, ID MSA]{.underline}
  [1350]{.underline}       [Casper, WY MSA]{.underline}
  [1440]{.underline}       [Charleston-North Charleston, SC MSA]{.underline}
  [1480]{.underline}       [Charleston, WV MSA]{.underline}
  [1520]{.underline}       [Charlotte-Gastonia-Rock Hill, NC-SC MSA]{.underline}
  [1580]{.underline}       [Cheyenne, WY MSA]{.underline}
  [1600]{.underline}       [Chicago, IL PMSA]{.underline}
  [1640]{.underline}       [Cincinnati, OH-KY-IN PMSA]{.underline}
  [1680]{.underline}       [Cleveland-Lorain-Elyria, OH PMSA]{.underline}
  [1720]{.underline}       [Colorado Springs, CO MSA]{.underline}
  [1760]{.underline}       [Columbia, SC MSA]{.underline}
  [1920]{.underline}       [Dallas, TX PMSA]{.underline}
  [2000]{.underline}       [Dayton-Springfield, OH MSA]{.underline}
  [2020]{.underline}       [Daytona Beach, FL MSA]{.underline}
  [2080]{.underline}       [Denver, CO PMSA]{.underline}
  [2120]{.underline}       [Des Moines, IA MSA]{.underline}
  [2160]{.underline}       [Detroit, MI PMSA]{.underline}
  [2190]{.underline}       [Dover, DE MSA]{.underline}
  [2320]{.underline}       [El Paso, TX MSA]{.underline}
  [2400]{.underline}       [Eugene-Springfield, OR MSA]{.underline}
  [2520]{.underline}       [Fargo-Moorhead, ND-MN MSA]{.underline}
  [2580]{.underline}       [Fayetteville-Springdale-Rogers, AR MSA]{.underline}
  [2680]{.underline}       [Fort Lauderdale, FL PMSA]{.underline}
  [2800]{.underline}       [Fort Worth-Arlington, TX PMSA]{.underline}
  [2960]{.underline}       [Gary, IN PMSA]{.underline}
  [3000]{.underline}       [Grand Rapids-Muskegon-Holland, MI MSA]{.underline}
  [3040]{.underline}       [Great Falls, MT MSA]{.underline}
  [3120]{.underline}       [Greensboro\--Winston-Salem\--High Point, NC MSA]{.underline}
  [3160]{.underline}       [Greenville-Spartanburg-Anderson, SC MSA]{.underline}
  [3290]{.underline}       [Hickory-Morganton-Lenoir, NC MSA]{.underline}
  [3320]{.underline}       [Honolulu, HI MSA]{.underline}
  [3400]{.underline}       [Huntington-Ashland, WV-KY-OH MSA]{.underline}
  [3480]{.underline}       [Indianapolis, IN MSA]{.underline}
  [3560]{.underline}       [Jackson, MS MSA]{.underline}
  [3600]{.underline}       [Jacksonville, FL MSA]{.underline}
  [3640]{.underline}       [Jersey City, NJ PMSA]{.underline}
  [3660]{.underline}       [Johnson City-Kingsport-Bristol, TN-VA MSA]{.underline}
  [3760]{.underline}       [Kansas City, MO-KS MSA]{.underline}
  [3880]{.underline}       [Lafayette, LA MSA]{.underline}
  [4100]{.underline}       [Las Cruces, NM MSA]{.underline}
  [4120]{.underline}       [Las Vegas, NV-AZ MSA]{.underline}
  [4360]{.underline}       [Lincoln, NE MSA]{.underline}
  [4400]{.underline}       [Little Rock-North Little Rock, AR MSA]{.underline}
  [4480]{.underline}       [Los Angeles-Long Beach, CA PMSA]{.underline}
  [4520]{.underline}       [Louisville, KY-IN MSA]{.underline}
  [4920]{.underline}       [Memphis, TN-AR-MS MSA]{.underline}
  [5000]{.underline}       [Miami, FL PMSA]{.underline}
  [5015]{.underline}       [Middlesex-Somerset-Hunterdon, NJ PMSA]{.underline}
  [5080]{.underline}       [Milwaukee-Waukesha, WI PMSA]{.underline}
  [5120]{.underline}       [Minneapolis-St Paul, MN-WI MSA]{.underline}
  [5140]{.underline}       [Missoula, MT MSA]{.underline}
  [5190]{.underline}       [Monmouth-Ocean, NJ PMSA]{.underline}
  [5330]{.underline}       [Myrtle Beach, SC MSA]{.underline}
  [5360]{.underline}       [Nashville, TN MSA]{.underline}
  [5380]{.underline}       [Nassau-Suffolk, NY PMSA]{.underline}
  [5560]{.underline}       [New Orleans, LA MSA]{.underline}
  [5600]{.underline}       [New York, NY PMSA]{.underline}
  [5640]{.underline}       [Newark, NJ PMSA]{.underline}
  [5720]{.underline}       [Norfolk-Virginia Beach-Newport News, VA-NC MSA]{.underline}
  [5880]{.underline}       [Oklahoma City, OK MSA]{.underline}
  [5910]{.underline}       [Olympia, WA PMSA]{.underline}
  [5920]{.underline}       [Omaha, NE-IA MSA]{.underline}
  [5960]{.underline}       [Orlando, FL MSA]{.underline}
  [6160]{.underline}       [Philadelphia, PA-NJ PMSA]{.underline}
  [6200]{.underline}       [Phoenix-Mesa, AZ MSA]{.underline}
  [6280]{.underline}       [Pittsburgh, PA MSA]{.underline}
  [6440]{.underline}       [Portland-Vancouver, OR-WA PMSA]{.underline}
  [6520]{.underline}       [Provo-Orem, UT MSA]{.underline}
  [6640]{.underline}       [Raleigh-Durham-Chapel Hill, NC MSA]{.underline}
  [6660]{.underline}       [Rapid City, SD MSA]{.underline}
  [6720]{.underline}       [Reno, NV MSA]{.underline}
  [6740]{.underline}       [Richland-Kennewick-Pasco, WA MSA]{.underline}
  [6760]{.underline}       [Richmond-Petersburg, VA MSA]{.underline}
  [6780]{.underline}       [Riverside-San Bernardino, CA PMSA]{.underline}
  [7040]{.underline}       [St Louis, MO-IL MSA]{.underline}
  [7160]{.underline}       [Salt Lake City-Ogden, UT MSA]{.underline}
  [7320]{.underline}       [San Diego, CA MSA]{.underline}
  [7490]{.underline}       [Santa Fe, NM MSA]{.underline}
  [7560]{.underline}       [Scranton\--Wilkes-Barre\--Hazleton, PA MSA]{.underline}
  [7600]{.underline}       [Seattle-Bellevue-Everett, WA PMSA]{.underline}
  [7680]{.underline}       [Shreveport-Bossier City, LA MSA]{.underline}
  [7760]{.underline}       [Sioux Falls, SD MSA]{.underline}
  [7840]{.underline}       [Spokane, WA MSA]{.underline}
  [8200]{.underline}       [Tacoma, WA PMSA]{.underline}
  [8280]{.underline}       [Tampa-St Petersburg-Clearwater, FL MSA]{.underline}
  [8400]{.underline}       [Toledo, OH MSA]{.underline}
  [8440]{.underline}       [Topeka, KS MSA]{.underline}
  [8480]{.underline}       [Trenton, NJ PMSA]{.underline}
  [8520]{.underline}       [Tucson, AZ MSA]{.underline}
  [8560]{.underline}       [Tulsa, OK MSA]{.underline}
  [8840]{.underline}       [Washington, DC-MD-VA-WV PMSA]{.underline}
  [8960]{.underline}       [West Palm Beach-Boca Raton, FL MSA]{.underline}
  [9040]{.underline}       [Wichita, KS MSA]{.underline}
  [9160]{.underline}       [Wilmington-Newark, DE-MD PMSA]{.underline}
  [9200]{.underline}       [Wilmington, NC MSA]{.underline}
  [9260]{.underline}       [Yakima, WA MSA]{.underline}
  [9320]{.underline}       [Youngstown-Warren, OH MSA]{.underline}
  [9360]{.underline}       [Yuma, AZ MSA]{.underline}
                           
  ------------------------ ---------------------------------------------------------------

**[Appendix C: Weight Class Collapsing Rules]{.underline}**

**[Metropolitan Area]{.underline}[-]{.underline}[Level
]{.underline}[Weighting Methodology]{.underline}**

[Respondents were assigned to a metropolitan area on the basis of the
county name that they provided during the interview. The county was then
recorded using the Federal Information Processing Standards (FIPS)
county code used by the U.S. Census Bureau. ]{.underline}

[All respondents in metropolitan areas were then assigned to age, race,
and sex categories. If a respondent's age was missing, it was imputed
using the variable \_IMPAGE available in the BRFSS public-use 2006 data
file. If a respondent's race was missing, it was imputed using the
majority race for the metropolitan area in which the respondent lived.
]{.underline}

[Within each metropolitan area, respondents were assigned to weighting
classes on the basis of age (18-24, 25-34, 35-44, 45-54, 55-64, or 65+),
race (white and non-Hispanic, or nonwhite or Hispanic), and sex (male or
female) categories. Some states did not use race in post-stratification;
for the metropolitan areas in these states, only age and sex groups were
used to establish weighting classes. For all other metropolitan areas,
all three groups were used to establish weighting classes. For
metropolitan areas that crossed state lines, the post-stratification
variables used by the state in which the majority of the metropolitan
area's population lived were used to set up weighting classes. Thus,
metropolitan areas that post-stratified by race had 24 initial weighting
classes and metropolitan areas that did not post-stratify by race had 12
initial weighting classes. ]{.underline}

[Weighting classes with fewer than 19 sample members were collapsed
according to the following rules:]{.underline}

1.  [For metropolitan areas that used race in post-stratification, the
    race categories within a sex category were collapsed if at least 80%
    of the age categories (i.e., at least five age categories) in the
    race and sex cross-classification had fewer than 19 members.
    ]{.underline}

2.  [The two youngest age categories in any age-sex or age-sex-race
    weighting class were collapsed if either contained fewer than 19
    members. The two middle and two oldest age categories in each
    remaining weighting class were also collapsed if either had fewer
    than 19 members. ]{.underline}

3.  [Weighting classes were not collapsed across sex. However, for each
    age and race category collapsing, it was done in the same manner for
    the male and female.]{.underline}

4.  [Metropolitan area was not included in the re-weighting if weighting
    classes with fewer than 19 sample members remained after all
    collapsing rules had been applied. ]{.underline}

[In 110 metropolitan areas, at least 500 respondents participated in the
2006 BRFSS and at least 19 sample members remained in all final
weighting classes. A list of these metropolitan areas is available in
Appendix B. The respondents in these metropolitan areas were the only
ones assigned a metropolitan area-level weight. To calculate the new
metropolitan area-level weight, we applied a post-stratification
adjustment factor to the design weight (\_WT2) and created the
adjustment factor based on the ratio of the total population to the sum
of the design weights for each weighting class within each metropolitan
area. The new metropolitan area-level weight (\_PMSAWT) should be used
to generate estimates in these 85 metropolitan areas.]{.underline}

[Example---SUDAAN Code]{.underline}

[For example, suppose we want a prevalence estimate for the Atlanta, GA
metropolitan area (PMSA code = 0520). The SAS/SUDAAN code that could be
used to generate this estimate is:]{.underline}

[proc sort data=xxxx;]{.underline}

[by \_STSTR \_PSU;]{.underline}

[run;]{.underline}

[proc descript data=xxxx filetype=sas design=wr;]{.underline}

[nest \_STSTR \_PSU / missunit;]{.underline}

[weight \_PMSAWT;]{.underline}

[subpopn PMSACODE='0520' / name=" Atlanta, GA";]{.underline}

[var (your analysis variable);]{.underline}

[catlevel (the level of your analysis variable for which you want an
estimate);]{.underline}

[run;]{.underline}