ACS Data Users Group

 View Only

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

    Posted 09-16-2020 03:31 PM

    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.

    acsdatacommunity.prb.org/.../acs_5F00_1yr_5F00_seq_5F00_table_5F00_number_5F00_lookup.zip



  • 2.  RE: Sequence and table number lookup SAS file for 2019 1-year

    Posted 09-23-2020 09:28 AM

    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.



  • 3.  RE: Sequence and table number lookup SAS file for 2019 1-year

    Posted 09-23-2020 09:30 AM

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