Sequence and table number lookup SAS file for 2019 1-year

For some reason, the SAS-format Sequence Number/Table Number Lookup File (found here: https://www.census.gov/programs-surveys/acs/technical-documentation/summary-file-documentation.html) has different column names than those used in years past.

If you're using SAS for sequence-file processing, here's a version of the lookup file with corrected column names.

acs_1yr_seq_table_number_lookup.zip

  • The Census Bureau has reissued a corrected SAS-format Sequence Number/Table Number Lookup File. It now has the same variable names as previous years and corrected the Table IDs for tables by race/ethnicity and for Puerto Rico. In the previous version the letter following the table number was missing. 

  • Thanks! I noticed the missing letter suffixes as well. (But only after spending hours pulling out my hair because my programs weren't working.)