Skip Header

We are hiring thousands of people for the 2020 Census. Click to learn more and apply.

  • 2018
  • 2017
  • 2016
  • 2015
  • 2014
  • 2013
  • 2012
  • 2011
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005

Technical Documentation

The Summary File Core Technical Document is now available as What ACS Summary File Data Users Need to Know.

Documentation on how to use the ACS Summary File with Excel or TIGER/Line Shapefiles

Component ID: #ti62677112

Appendices include the sequence number and restrictions for all tables, as well as summary levels available for each release.

xls   1-year Appendices   [<1.0 MB]
xls   5-year Appendices   [<1.0 MB]

Summary File User Tools

Component ID: #ti62677109

Table Shells

Contains table ID, line number, unique ID (table ID + Line Number), stub, and data release

xls   Table Shells   [2.1 MB]
Component ID: #ti62677108

Sequence Number/Table Number Lookup File

Contains information on the relationship between the sequences and the tables

1-year Lookup File

zip   SAS format   [12 MB]
xls   Excel format   [1.5 MB]
txt   Text format   [2.1 MB]

5-year Lookup File

zip   SAS format   [9.2 MB]
xls   Excel format   [2.3 MB]
txt   Text format   [1.6 MB]
Component ID: #ti446861654

Simplified Geography Files

Contains basic geography information, including LOGRECNO, GEOID, and name, in an Excel file with tabs for the US, as well as each state or state equivalent.  Compared to the standard geography files in .csv and .txt format, these simplified files contain only the geography variables needed to read the ACS Summary File into Excel.

Component ID: #ti62677107

SAS Programs

Contains SAS programs for each sequence per state, which can be used to convert each estimate and margin of error into SAS datasets with table stubs

Component ID: #ti62677106

Detailed example SAS program containing SAS macros which access the geography, estimate and margin of error data. It creates one table for all geographies from the ACS Summary File. Segments of the SAS codes can be used to convert geography files into SAS datasets.

txt   1-Year Macros   [<1.0 MB]
txt   5-Year Macros   [<1.0 MB]

You May Be Interested In

You May Be Interested In

  Is this page helpful?
Thumbs Up Image Yes    Thumbs Down Image No
Comments or suggestions?
No, thanks
255 characters remaining
Thank you for your feedback.
Comments or suggestions?
Back to Header