Skip to main content

AHS: RE: Matching cases from National AHS and Metro AHS Data

HUD.GOV HUDUser.gov
eList
AHS

Karen Danielsen writes:

>>I was wondering if you can match cases from the national survey to the metropolitan area studies. It looks like the cases from the national survey have just the SMSA number in front of the case number in the control variable but there seems to be other cases included in some of the metro areas that have a more complex control number. If there is another way to match them, please let me know. <<

The list below shows the selection conditions you should use to identify all of the records in the 29 metropolitan supplement areas of the 2011 AHS. This will pick up both the national and metro supplement cases in the dataset. I will be sending a document to HUD USER shortly, so that this information will be readily available.

AHS Area Name in American FactFinder Selection Condition
Anaheim-Santa Ana, CA AHS Area (SMSA = 0360)
Atlanta-Sandy Springs-Marietta, GA AHS Area (SMSA = 0520)
Birmingham-Hoover, AL AHS Area (SMSA = 1000)
Buffalo-Niagara Falls, NY AHS Area (SMSA = 1280 or CMSA = 10)
Charlotte-Gastonia-Concord, NC-SC AHS Area (SMSA = 1520)
Cincinnati-Middletown, OH-KY-IN AHS Area (SMSA = 1640)
Cleveland-Elyria-Mentor, OH AHS Area (SMSA = 1680)
Columbus, OH AHS Area (SMSA = 1840)
Dallas-Plano-Irving, TX AHS Area (SMSA = 1920)
Denver, CO AHS Area (SMSA = 2080) [CMSA codes of 34 are not used because some of those are in Boulder, CO, which is not part of the Denver MSA]
Fort Worth-Arlington, TX AHS Area (SMSA = 2800)
Indianapolis-Carmel, IN AHS Area (SMSA = 3480)
Kansas City, MO-KS AHS Area (SMSA = 3760)
Los Angeles-Long Beach, CA AHS Area (SMSA = 4480)
Memphis, TN-MS-AR AHS Area (SMSA = 4920)
Milwaukee-Waukesha-West Allis, WI AHS Area (SMSA = 5080)
New Orleans-Metairie-Kenner, LA AHS Area (SMSA = 5560)
Oakland-Fremont-Hayward, CA AHS Area (SMSA = 5775)
Phoenix-Mesa-Glendale, AZ AHS Area (SMSA = 6200)
Pittsburgh, PA AHS Area (SMSA = 0845 or SMSA = 6280)
Portland-Vancouver-Beaverton, OR-WA AHS Area (SMSA = 6440 or CMSA = 79)
Providence, RI AHS Area (SMSA = 6480 or CMSA = 80)
Riverside-San Bernardino-Ontario, CA AHS Area (SMSA = 6780)
Sacramento--Arden-Arcade--Roseville, CA AHS Area (SMSA = 6920)
San Diego-Carlsbad-San Marcos AHS Area (SMSA = 7320)
San Francisco-San Mateo-Redwood City, CA AHS Area (SMSA = 7360)
San Jose-Sunnyvale-Santa Clara, CA AHS Area (SMSA = 7400)
St. Louis, MO-IL AHS Area (SMSA = 0275 or SMSA = 2285 or SMSA = 7040 or CMSA = 82)
Virginia Beach-Norfolk-Newport News, VA-NC AHS Area (SMSA = 5720)

 

Dav Vandenbroucke
Senior Economist
U.S. Dept. HUD
david.a.vandenbroucke@hud.gov
202-402-5890

 

eList Archives