I am trying to download the S0103 file from the ACS - to study the 65+ population at the ZCTA level. Whenever I download the file, I only get ~900 variables (when I should get ~33K) regardless of whether I open with R or with Excel. I tried setting the geography to counties, to see if the number of rows was just to unwieldy, and that data download was also truncated (providing only ~1100 rows, vs. the expected ~3K).
Thanks for the help!
This may be due to the Census Bureau's data suppression rules for Subject Tables. Here is some text from their ACS Data Suppression document (https://www2.census.gov/programs-surveys/acs/tech_docs/data_suppression/ACSO_Data_Suppression.pdf):
"Subject tables featuring specific population groups and iterated Selected Population Profiles (SPPs) that are generated directly from microdata are filtered in a similar matter to detailed tables, except that filtering is applied to the sub-population groups as opposed to the whole tables. However, if one half or more of the lines in a SPP for a geography are filtered out, the whole table is filtered out for that geography."
If there are specific estimates that you need for the 65+ population, you may be able to access them from other tables.
In reply to Mark Mather:
In reply to Hannah: