Home > Data Services > Catalog . Restricted Data . Census . ACS

Search Data Services

Meta Search
search across all the following databases:

Data Catalog
Data and documentation

KnowledgeBase
Common questions and answers.

Resources
Entire collection of data resources.


Latest Data News

RSS Feed icon

Federal Register Notice: Some ACS questions on the chopping block

Political Science: A self-inflicted wound?

Sage Stats and CQ Political Stats Trial

Breaking News: Protect the 2020 Census

The Fastest Growing US Cities Are Mostly In the West

Data Services Knowledge Base

Q:  

I am working with a zip code file from the Census Bureau. Some of the zip codes have XX or HH in the code, e.g., 298HH. How can I get rid of these zip codes? What does the HH/XX code(s) represent anyway?

A:  

First, zip code tabulation areas (ZCTA) are the Census Bureau’s representation of zip codes. The HH indicates that the ZCTA represents a large water area (generally larger than 25 square miles). Because the water area may border many five-digit ZCTAs, the water area was not assigned to any zip code – hence 298HH. The XX codes are applied to large land areas where the Census Bureau had insufficient information to determine the five-digit codes. These are generally in rural areas with little settlement – parks, forest lands, deserts, etc.

The easiest way to get rid of these ZCTAs that have XX or HH in the code is to perform an arithmetic operation on the ZCTA code. All the non-numeric codes will be transformed from a character value to a missing value:

data a;
infile "fake";
input zcta $;
zip = zcta + 0;
proc print; var zcta zip;

Annotated Resources:

Direct Links:

Related Question Groups: