American Community Survey (ACS)

2007 PUMS Top Coded and Bottom Coded Values

The following eleven housing variables and seven person variables are top coded only or top coded and bottom coded in the Public Use Microdata Sample files:

The tables below show the top code only or the top code and bottom code values for each of these variables by state. These top codes and bottom codes were derived based on the following rules:

1. Age, travel time to work, and all base dollar amounts are top-coded using the state mean of all cases greater than or equal to the top-code state minimum value. The only exception to the top-code state minimum value is TAX which uses the top-code national minimum value. Income amounts which can have negative values (self-employment and interest/dividends) are bottom-coded using the state mean of all cases less than or equal to the bottom-code state maximum value. Recodes of dollar amounts use the rounded top-coded/bottom-coded base dollar amounts without any additional top-coding/bottom-coding.
2. Top-coded property taxes are further assigned to one of 68 categories.

HTML file

Excel file

[Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer available for free from Microsoft®. This symbol indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.