PCI = Metropolitan/Micropolitan Principal City IndicatorThis info, along with some other important summary file documentation, is in the (suboptimally out-of-the-way) "Notes on Data, Geography and Variable Changes" in the GitHub pages for the table…
Hello I need to load 5 year 2015-2019 summary files into Stata. Is anyone using Stata who could offer help? Thanks Patrick
Linking based on GeoID works but can be cumbersome. There are ways to write code to download the summary files and process them using a statistical package, or to use open-source tools to write code using the API.
Summary files option: https://www.census…
I have ArcGIS Pro/ArGIS Online and Excel and SPSS (but no SAS). Therefore I would like to learn how to use read the ACS Summary File into Excel for beginners. I would like to consider the simplest possible case for now
Therefore, I am using the 2019 1…
Just a quick note, Social Explorer www.socialexplorer.com has Census files from the 2010 and 2020 Censuses by summary level that have results of both Censuses in a form that makes it possible to map or get reports or download data, that has combined both…
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…