2007 smart brfss county Methodology 2007 Selected Metropolitan/Micropolitan Area Risk Trends from the brfss creation of Metropolitan-level weights



Download 495.5 Kb.
Date conversion25.05.2016
Size495.5 Kb.
2007 SMART BRFSS County Methodology
2007 Selected Metropolitan/Micropolitan Area Risk Trends from the BRFSS

Creation of Metropolitan-level weights
The Behavioral Risk Factor Surveillance System (BRFSS) Selected Metropolitan/Micropolitan Area Risk Trends (SMART) is a documented and verified subset of the 2007 BRFSS, which has been produced to provide some local area estimates. These local areas are identified counties within metropolitan or micropolitan statistical areas (MMSA) as defined by the Office of Management and Budget. The data set was produced by adding new analysis weights designed to correspond to the 2007 population estimates for each eligible county within a selected MMSA. The additional weights were post-stratified to the county-level. The process by which these new weights were obtained is detailed in Appendix C, “Weight Class Collapsing Rules.”

Selected Areas

Typically, BRFSS data are used to produce state-level estimates. However, for the SMART project, BRFSS data were used to produce small area-level estimates for MMSAs as defined by the Bureau of the Census. On June 6, 2003, the Office of Management and Budget (OMB) issued new definitions for metropolitan statistical areas, micropolitan statistical areas, and metropolitan divisions. OMB periodically updates the list of MMSAs. The list of areas used for this analysis can be found at http://www.whitehouse.gov/omb/bulletins/fy05/b05-02_appendix.pdf. For more information about MMSAs, please visit http://www.census.gov/population/www/estimates/metroarea.html. A respondent was associated with a particular MMSA on the basis of their county code. Missing county codes were imputed from a value included in the purchased telephone sample that represents the county most likely associated with the telephone number. There were 184 MMSAs that met the analysis criteria for the 2007 data year. From within the 184 MMSAs, county-level estimates have been produced from the BRFSS data for 298 counties that have met the weighting criteria (Appendix C) for the 2007 data year.


Appendix A: List of Variables added to the 2007 Data
Data Documentation for the 13 Variables Added to the 2007 BRFSS Data
ADJCNTY County-level post-stratification weight. This factor is multiplied by the design weight (_WT2) to get the final County-level weight (_CNTYWT).

AGE_CNTY Age categories used to set up the initial weighting classes for the county-level weights.

1 – 18–24

2 – 25–34

3 – 35–44

4 – 45–54

5 – 55–64

6 – 65+
AGE_C_F Age categories used in the final weighting classes for the county-level weights.

1 – 18–24

2 – 25–34

3 – 35–44

4 – 45–54

5 – 55–64

6 – 65+

7 – 18–34

8 – 35–54

9 – 55+

10 – 18–44

11 – 45+

12 – 18–54

14 – 45–65

19 – 35+
RACE_CNT Race categories used to set up the initial weighting classes for the county-level weights.

0 – Race not used

1 – White, non-Hispanic

2 – Nonwhite or Hispanic


RACE_C_F Race categories used in the final weighting classes for the county-level weights.

0 – Race not used

1 – White, non-Hispanic

2 – Nonwhite or Hispanic


SEX_CNTY Sex categories used to set up the initial and final weighting classes for the county-level weights (weight classes are never collapsed across sex).

1 – Male



2 – Female
_CNTY – FIPS County code of the county where the respondent lives. This variable is equivalent to CTYCODE, except for respondents with a CTYCODE of “777” or “999”. The county code for these respondents was imputed based on information provided by BSB.
_CNTYNAM County name of the county where the respondent lives.
_CNTYWT The new county-level weight. This is the weight to use when generating county-level estimates for questions that were asked of the whole sample.

Appendix B: List of the 298 counties that have COUNTY-level Weights in 2007 BRFSS Data
Metropolitan/Micropolitan Statistical Area or Metropolitan Division Codes and Names


State Name

FIPS State

FIPS County

County Name

Alabama

1

73

Jefferson County

Alabama

1

97

Mobile County

Alabama

1

101

Montgomery County

Alabama

1

125

Tuscaloosa County

Alaska

2

20

Anchorage Municipality

Arizona

4

13

Maricopa County

Arizona

4

19

Pima County

Arizona

4

21

Pinal County

Arizona

4

23

Santa Cruz County

Arizona

4

27

Yuma County

Arkansas

5

7

Benton County

Arkansas

5

119

Pulaski County

Arkansas

5

143

Washington County

California

6

1

Alameda County

California

6

37

Los Angeles County

California

6

65

Riverside County

California

6

71

San Bernardino County

California

6

73

San Diego County

Colorado

8

1

Adams County

Colorado

8

5

Arapahoe County

Colorado

8

13

Boulder County

Colorado

8

31

Denver County

Colorado

8

35

Douglas County

Colorado

8

41

El Paso County

Colorado

8

59

Jefferson County

Colorado

8

69

Larimer County

Colorado

8

123

Weld County

Connecticut

9

1

Fairfield County

Connecticut

9

3

Hartford County

Connecticut

9

7

Middlesex County

Connecticut

9

9

New Haven County

Connecticut

9

11

New London County

Connecticut

9

13

Tolland County

Delaware

10

1

Kent County

Delaware

10

3

New Castle County

Delaware

10

5

Sussex County

District of Columbia

11

1

District of Columbia

Florida

12

1

Alachua County

Florida

12

3

Baker County

Florida

12

5

Bay County

Florida

12

9

Brevard County

Florida

12

11

Broward County

Florida

12

17

Citrus County

Florida

12

19

Clay County

Florida

12

21

Collier County

Florida

12

23

Columbia County

Florida

12

27

DeSoto County

Florida

12

31

Duval County

Florida

12

33

Escambia County

Florida

12

35

Flagler County

Florida

12

39

Gadsden County

Florida

12

41

Gilchrist County

Florida

12

49

Hardee County

Florida

12

51

Hendry County

Florida

12

53

Hernando County

Florida

12

55

Highlands County

Florida

12

57

Hillsborough County

Florida

12

65

Jefferson County

Florida

12

69

Lake County

Florida

12

71

Lee County

Florida

12

73

Leon County

Florida

12

81

Manatee County

Florida

12

83

Marion County

Florida

12

85

Martin County

Florida

12

86

Miami-Dade County

Florida

12

87

Monroe County

Florida

12

89

Nassau County

Florida

12

93

Okeechobee County

Florida

12

95

Orange County

Florida

12

97

Osceola County

Florida

12

99

Palm Beach County

Florida

12

101

Pasco County

Florida

12

103

Pinellas County

Florida

12

105

Polk County

Florida

12

109

St. Johns County

Florida

12

111

St. Lucie County

Florida

12

113

Santa Rosa County

Florida

12

115

Sarasota County

Florida

12

117

Seminole County

Florida

12

127

Volusia County

Florida

12

129

Wakulla County

Georgia

13

63

Clayton County

Georgia

13

67

Cobb County

Georgia

13

89

DeKalb County

Georgia

13

121

Fulton County

Georgia

13

135

Gwinnett County

Hawaii

15

1

Hawaii County

Hawaii

15

3

Honolulu County

Hawaii

15

7

Kauai County

Hawaii

15

9

Maui County

Idaho

16

1

Ada County

Idaho

16

19

Bonneville County

Idaho

16

27

Canyon County

Idaho

16

69

Nez Perce County

Illinois

17

31

Cook County

Illinois

17

43

DuPage County

Illinois

17

97

Lake County

Indiana

18

89

Lake County

Indiana

18

97

Marion County

Iowa

19

153

Polk County

Kansas

20

91

Johnson County

Kansas

20

173

Sedgwick County

Kansas

20

177

Shawnee County

Kansas

20

209

Wyandotte County

Kentucky

21

111

Jefferson County

Louisiana

22

19

Calcasieu Parish

Louisiana

22

33

East Baton Rouge Parish

Louisiana

22

51

Jefferson Parish

Louisiana

22

71

Orleans Parish

Louisiana

22

103

St. Tammany Parish

Maine

23

5

Cumberland County

Maine

23

11

Kennebec County

Maine

23

19

Penobscot County

Maine

23

23

Sagadahoc County

Maine

23

31

York County

Maryland

24

3

Anne Arundel County

Maryland

24

5

Baltimore County

Maryland

24

17

Charles County

Maryland

24

21

Frederick County

Maryland

24

25

Harford County

Maryland

24

27

Howard County

Maryland

24

31

Montgomery County

Maryland

24

33

Prince George's County

Maryland

24

35

Queen Anne's County

Maryland

24

43

Washington County

Maryland

24

510

Baltimore city

Massachusetts

25

1

Barnstable County

Massachusetts

25

5

Bristol County

Massachusetts

25

9

Essex County

Massachusetts

25

13

Hampden County

Massachusetts

25

15

Hampshire County

Massachusetts

25

17

Middlesex County

Massachusetts

25

21

Norfolk County

Massachusetts

25

23

Plymouth County

Massachusetts

25

25

Suffolk County

Massachusetts

25

27

Worcester County

Michigan

26

81

Kent County

Michigan

26

99

Macomb County

Michigan

26

125

Oakland County

Michigan

26

163

Wayne County

Minnesota

27

3

Anoka County

Minnesota

27

37

Dakota County

Minnesota

27

53

Hennepin County

Minnesota

27

123

Ramsey County

Mississippi

28

33

DeSoto County

Mississippi

28

47

Harrison County

Mississippi

28

49

Hinds County

Mississippi

28

121

Rankin County

Missouri

29

95

Jackson County

Missouri

29

189

St. Louis County

Missouri

29

510

St. Louis city

Montana

30

29

Flathead County

Montana

30

111

Yellowstone County

Nebraska

31

43

Dakota County

Nebraska

31

55

Douglas County

Nebraska

31

79

Hall County

Nebraska

31

109

Lancaster County

Nebraska

31

153

Sarpy County

Nevada

32

3

Clark County

Nevada

32

31

Washoe County

New Hampshire

33

9

Grafton County

New Hampshire

33

11

Hillsborough County

New Hampshire

33

13

Merrimack County

New Hampshire

33

15

Rockingham County

New Hampshire

33

17

Strafford County

New Jersey

34

3

Bergen County

New Jersey

34

5

Burlington County

New Jersey

34

7

Camden County

New Jersey

34

13

Essex County

New Jersey

34

15

Gloucester County

New Jersey

34

17

Hudson County

New Jersey

34

19

Hunterdon County

New Jersey

34

23

Middlesex County

New Jersey

34

25

Monmouth County

New Jersey

34

27

Morris County

New Jersey

34

29

Ocean County

New Jersey

34

31

Passaic County

New Jersey

34

35

Somerset County

New Jersey

34

37

Sussex County

New Jersey

34

39

Union County

New Jersey

34

41

Warren County

New Mexico

35

1

Bernalillo County

New Mexico

35

13

Dona Ana County

New Mexico

35

43

Sandoval County

New Mexico

35

45

San Juan County

New Mexico

35

49

Santa Fe County

New Mexico

35

61

Valencia County

New York

36

29

Erie County

New York

36

47

Kings County

New York

36

59

Nassau County

New York

36

61

New York County

New York

36

81

Queens County

New York

36

103

Suffolk County

New York

36

119

Westchester County

North Carolina

37

21

Buncombe County

North Carolina

37

25

Cabarrus County

North Carolina

37

35

Catawba County

North Carolina

37

51

Cumberland County

North Carolina

37

63

Durham County

North Carolina

37

71

Gaston County

North Carolina

37

81

Guilford County

North Carolina

37

89

Henderson County

North Carolina

37

101

Johnston County

North Carolina

37

119

Mecklenburg County

North Carolina

37

129

New Hanover County

North Carolina

37

135

Orange County

North Carolina

37

151

Randolph County

North Carolina

37

179

Union County

North Carolina

37

183

Wake County

North Dakota

38

15

Burleigh County

North Dakota

38

17

Cass County

Ohio

39

35

Cuyahoga County

Ohio

39

49

Franklin County

Ohio

39

61

Hamilton County

Ohio

39

89

Licking County

Ohio

39

95

Lucas County

Ohio

39

99

Mahoning County

Ohio

39

113

Montgomery County

Ohio

39

151

Stark County

Ohio

39

153

Summit County

Oklahoma

40

17

Canadian County

Oklahoma

40

27

Cleveland County

Oklahoma

40

109

Oklahoma County

Oklahoma

40

143

Tulsa County

Oregon

41

5

Clackamas County

Oregon

41

51

Multnomah County

Oregon

41

67

Washington County

Pennsylvania

42

3

Allegheny County

Pennsylvania

42

45

Delaware County

Pennsylvania

42

51

Fayette County

Pennsylvania

42

79

Luzerne County

Pennsylvania

42

91

Montgomery County

Pennsylvania

42

101

Philadelphia County

Pennsylvania

42

129

Westmoreland County

Rhode Island

44

3

Kent County

Rhode Island

44

5

Newport County

Rhode Island

44

7

Providence County

Rhode Island

44

9

Washington County

South Carolina

45

3

Aiken County

South Carolina

45

13

Beaufort County

South Carolina

45

15

Berkeley County

South Carolina

45

19

Charleston County

South Carolina

45

35

Dorchester County

South Carolina

45

45

Greenville County

South Carolina

45

51

Horry County

South Carolina

45

63

Lexington County

South Carolina

45

79

Richland County

South Carolina

45

91

York County

South Dakota

46

99

Minnehaha County

South Dakota

46

103

Pennington County

Tennessee

47

37

Davidson County

Tennessee

47

65

Hamilton County

Tennessee

47

157

Shelby County

Tennessee

47

163

Sullivan County

Texas

48

29

Bexar County

Texas

48

61

Cameron County

Texas

48

85

Collin County

Texas

48

113

Dallas County

Texas

48

121

Denton County

Texas

48

141

El Paso County

Texas

48

201

Harris County

Texas

48

215

Hidalgo County

Texas

48

439

Tarrant County

Texas

48

453

Travis County

Texas

48

479

Webb County

Texas

48

491

Williamson County

Utah

49

11

Davis County

Utah

49

35

Salt Lake County

Utah

49

45

Tooele County

Utah

49

49

Utah County

Utah

49

57

Weber County

Vermont

50

7

Chittenden County

Vermont

50

11

Franklin County

Vermont

50

17

Orange County

Vermont

50

21

Rutland County

Vermont

50

23

Washington County

Vermont

50

27

Windsor County

Virginia

51

13

Arlington County

Virginia

51

59

Fairfax County

Virginia

51

153

Prince William County

Virginia

51

510

Alexandria city

Washington

53

5

Benton County

Washington

53

7

Chelan County

Washington

53

11

Clark County

Washington

53

17

Douglas County

Washington

53

33

King County

Washington

53

35

Kitsap County

Washington

53

53

Pierce County

Washington

53

61

Snohomish County

Washington

53

63

Spokane County

Washington

53

67

Thurston County

Washington

53

73

Whatcom County

Washington

53

77

Yakima County

West Virginia

54

39

Kanawha County

Wisconsin

55

79

Milwaukee County

Wyoming

56

13

Fremont County

Wyoming

56

21

Laramie County

Wyoming

56

25

Natrona County


Appendix C: Weight Class Collapsing Rules
County-level Weighting Methodology
Respondents were assigned to a county on the basis of their FIPS county codes. Missing county codes were imputed from a value included in the purchased telephone sample that represents the county most likely associated with the telephone number before the respondent identifies a county during data collection.
All respondents in counties were then assigned to age, race, and sex categories. If a respondent’s age was missing, it was imputed by using the variable _IMPAGE available in the BRFSS public-use 2007 data file. If a respondent’s race was missing, it was imputed by using the majority race for the county in which the respondent lives. The six age categories were 18-24, 25-34, 35-44, 45-54, 55-64, and 65+. The two race categories were white, non-Hispanic, and nonwhite or Hispanic.
Within each county, respondents were assigned to weighting classes on the basis of the age, race, and sex categories described above. Some states do not use race in post-stratification. For the county in states that do not use race, only the age and sex groups were used to set up weighting classes. For the county in states that do use race, all three groups were used to set up weighting classes. Thus, the counties that use race had 24 initial weighting classes and counties that do not use race had 12 initial weighting classes.
Weighting classes with fewer than 19 sample members were collapsed in accordance with the following rules:


  1. For those counties that used race in post-stratification, the race categories within a sex category collapse if at least 80% of the age categories in that race /sex cross-classification (i.e. 5 of 6 the age categories) have fewer than 19 members. In counties that used race to create the initial weighting classes, the number of weighting classes was thus reduced from 24 to 12 if race was collapsed for both sexes and from 24 to 18 if race was collapsed for only one sex.




  1. Collapse the two youngest age categories in any age/sex or age/sex/race weighing class if either contains fewer than 19 members. Do the same for the two middle and the two oldest age categories in each remaining weighting class.




  1. If either of the age/sex or age/sex/race categories have fewer than 19 members, then the age categories were collapsed until there were 19 members in some combination of the age categories listed in the variable AGE_C_F.




  1. Do not collapse weighting classes across sex.




  1. Do not include a county in the reweighting that still has weighting classes with fewer than 19 sample members after all collapsing rules have been applied. These counties will be excluded from the 2007 SMART BRFSS.

There were 184 MMSAs that had at least 500 respondents in the 2007 BRFSS and at least 19 sample members in all final weighting classes. There are 298 counties within the 184 MMSAs that had at least 19 sample members in all final weighting classes. (See Appendix B in the Data Documentation for a list of these counties.) Only the respondents in these counties were given a county-level weight. To calculate the new county-level weight, we applied a post-stratification adjustment factor to the design weight (_WT2) and created the adjustment factor by taking the ratio of the total population over the sum of the design weights for each weighting class within each county. The new county-level weight (_CNTYWT) should be used to generate estimates in these 298 counties.


Example SUDAAN Code:

For example, to estimate for DeKalb County, GA (_STATE=13, _CNTY=89). The following SAS/SUDAAN code that could be used to do this:


data xxxx;

set yyyy;


if (_STATE=13 & _CNTY=89) then DUMMY=1;

run;
proc sort data=xxxx;

by _STSTR SEQNO;

run;
proc descript data=xxxx filetype=sas design=wr;

nest _STSTR SEQNO / missunit;

weight _CNTYWT;

subpopn DUMMY=1 / name=”DeKalb County, GA”;

var (your analysis variable);



catlevel (the level of your analysis variable for which you want an estimate);

run;


The database is protected by copyright ©essaydocs.org 2016
send message

    Main page