Greetings! How to read the data from Table DP05 of the 2019 American Community Survey (ACS) 5-year estimates into SAS? When I deleted the second row on variable definition and read it into SAS, errors came (copied below). When I read all lines starting…
I'm reading through the PDF "Understanding and Using American Community Survey Data - What State and Local Government Users Need to Know" and need help recreating the calculation for the median salary in Case Study #1 as shown in Figure 3.8…
Geocorr works by reducing both source and target geographies into collections of blocks -- the "atoms", if you will. We know the population of every block. So we can take all the blocks that are in ZCTA 21771 (say) and add up the populations of all those…
Hi,
I'm looking to cross tabulate a few different variables with a dichotomous poverty variable (below threshold or not) in the 1-year PUMS. I derived the poverty status variable by recoding the income to poverty ratio. Unfortunately the statistical…
We were asked to create a timeline of the local number of households with children by household type. We extracted data from past Censuses, Census 2020 and recent 1-year ACS. We noticed some differences between the ACS and the DHC counts that seemed to…
Hi, Mara -- taking a weighted average of block group medians can give you misleading results, because the median depends on the income distributions of the different block groups. If the block group pieces you're combining have roughly symmetrical distributions…
Dear Andy,
The relationship file that I referenced is for the 2020 PUMAs (posted on the census website) but they are not in use yet for the current 2021 PUMS data (I use the API). The relationship file in the post has a lot of PUMAs that do not exist…