Census reports on AHS metro survey can be found at http://www.census.gov/hhes/www/housing/ahs/metropolitandata.html
This document provides a brief introduction to the 2007 Metropolitan Survey dataset of the American Housing Survey
Download the 2007 Metropolitan dataset in ASCII format (revised 01-22-09)
(*.exe, 6.32 MB)
Download the 2007 Metropolitan dataset in SAS format
(*.exe, 4.71 MB)
Download the SAS "file flattener" program for the 2007 AHS Metropolitan dataset (*.sas, 10 KB)
The file flattener program is a SAS routine that extracts the eight individual SAS files from the transport dataset and produces a single SAS file, with one record per housing unit. Observations on persons, commuting, recent mover groups, and alterations & repair projects are transformed into numbered groups of variables in the housing unit record. While this file structure requires about twice as much disk space as the individual files, some users find it easier to use.
Download the Descriptive Statistics of 2007 AHS Metro Variables
(revised 01-27-09)(*.exe, 1.25 MB)
2007 metro survey topcode file (*.xls, 148 KB)
Topcodes and bottom codes in the AHS public use file In order to maintain confidentiality, unusually high (and, in a few cases, low) values in the AHS dataset are replaced with maximum (or minimum) values, called top (or bottom) codes. This MS-Excel spreadsheet documents these values for the affected variables.
2007 Instrument Items Booklet (*.pdf, 199 KB): The instrument items booklet is a PDF document that lists all the questions and responses in the AHS survey instrument. It was prepared for the Office of Management and Budget as part of the survey clearance process. This is the closest equivalent to a paper version of the AHS questionnaire.
2007 Instrument Items Booklet, Spanish-Language Version (*.pdf, 158 KB): Although there is no Spanish-language survey instrument, the Census Bureau prepared this translation of the instrument items booklet, as a guide for field representatives who needed to conduct AHS interviews in Spanish.
2007 AHS Survey Instrument Software (*.zip, 5.30 MB): This zip file contains all the files needed for a runnable “demo” version of the AHS survey instrument. Users can enter responses and step through the instrument to simulate the flow of questions in an actual AHS interview. This version of the software does not save any data; it merely demonstrates the instrument. It is intended to run on Microsoft Windows-based computers.
DISCLAIMER: The application is distributed for review purposes only, and no production data collection is permitted. By downloading the software, users agree to these terms. Further, this software is being provided "as is." Neither the Census Bureau nor the software publisher will provide any support for software downloaded from this web site.
Download the PSUDOTCT variable values for 2007 metro cases. (*.zip, 84 KB)
The PSUDOTCT variable allows users to determine whether two housing units in the survey are in the same Census tract. Due to a processing error, the PSUDOTCT variable for the 2007 metro file contained anomalies for the Boston and Baltimore MSAs. This file contains the correct PSUDOTCT variable values for 2007 metro cases. The zip file contains a comma separated values (.csv) file which can be imported into most statistical and database software. You can merge the data into the regular AHS dataset by matching on SMSA and CONTROL.
2007 AHS Survey Instrument Case Description and Instructions (*.pdf, 10 KB): This PDF file provides brief instructions on how to install the survey instrument software above. It also documents the characteristics of the sample cases provided with the software.
Special Technical Note: Be sure that the software you use to unzip the survey instrument is set to create subdirectories as needed. Most zip utilities will do this automatically, but some do not. The software will not work if its files are not stored in the appropriate subdirectories.
SURVEY DOCUMENTATION
Please download the Codebook for the American Housing Survey; Public Use File: 1997 and later (*.pdf, 2.14 MB).
SMSA | Description | Sample Size | Previous |
0720 | Baltimore, MD | 2733 | 1998 |
1120 | Boston, MA | 2771 | 1998 |
3360 | Houston, TX | 2861 | 1998 |
5000 | Miami Hialeah, FL | 2647 | 2002 |
5120 | Minneapolis St. Paul, MN | 2847 | 1998 |
8280 | Tampa St. Petersburg Clearwater, FL | 3053 | 1998 |
8840 | Washington, DC MD VA | 2781 | 1998 |
ITEMS ADDED
Academic comparison to other area elementary schools. A question was added to determine how the respondent believed their public elementary school compared academically to the other public elementary schools in their area.
Safety equipment. A series of questions were added to determine the number of homes with working smoke detectors, fire extinguishers, sprinkler systems, and/or carbon monoxide detectors.
Down payment. A question was added to determine the percent of purchase price that was used as a down payment. For detailed definitions of these items, see Appendix A.
ITEMS MODIFIED
Special living. Additional types of services and assistance available to residents (such as bathing and eating) were only asked of those who reported that meals, transportation, or housekeeping were available.
Neighborhood conditions. The series of questions on neighborhood crime, odors, and street noise or traffic was reduced. For each of these items we no longer ask whether or not the condition is bothersome and, if yes, so bothersome that they want to move.
Neighborhood shopping. We no longer ask if satisfactory neighborhood shopping is available and the distance from home (less than 1 mile or 1 mile or more). Instead, we ask if grocery or drug stores are within 15 minutes of the home and, if yes, are they satisfactory.
Public transportation. Instead of asking if the household uses public transportation weekly or less than weekly and the satisfaction level, we now ask if the household uses it regularly for commuting to school or work and the travel time to the nearest mode of transportation.
Selected physical problems. Modified to exclude hallways under severe and moderate physical problems.
Income sources of families and primary individuals. We subdivided the combined Interest/Dividend/Rental income question into separate income receipt items. We also modified the other income to no longer include child support or alimony.
Public elementary school. We no longer ask those who report an unsatisfactory elementary school if they are so bothered they want to move.
Other heating equipment. We no longer ask for the type of fuel used for the secondary sources of heating equipment, nor do we determine if the equipment is a parallel or supplemental heat source.
ITEMS DROPPED
Fuels. The question regarding other house heating fuels was dropped.
Height and condition of building. For multiunit structures, the questions on common stairways (and their condition) and light fixtures (and their working order) were dropped.


