I’m trying to do a time series comparison of Moderate Income Households in San Jose between 2000 and 2017, using Census 2000 5% sample and ACS 2013-2017 sample.
I’ve used ArcGIS to select PUMA’s for 2000 and 2010 that generally cover the San Jose area, and comprised almost the exact same area. I am using Pernum(1) and hhwt for my cross tabulation. However, I am receiving a result for the Census 2000 sample that is almost 100,000 households higher than it should be according to other census sources for San Jose.
Anyone ever experienced an issue like this before or have an idea as to why this may be happening?