Status:Closed    Asked:Feb 20, 2018 - 02:42 PM

Comparing 2015 ASEC CPS IPUMS with Census data and Table Creator, I note differing record counts for FTYR earners

To specifically demonstrate the problem I looked at males with college degree working 35+ hours per week and 50+ weeks per year in the 2015 data. At age 23, I find 71 observations with Census data and their Table Creator Tool. With IPUMS I find 64. Moreover, there appear to be 2 observations in the IPUMS data for which there is no analogue in the Census data. I am concerned that the microdata is not consistent. Any ideas on what could be driving this?

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


It is most likely that this discrepancy is driven by slightly different filters and/or universe statements defining the observations in the two tables you are comparing. The issue is unlikely to be due to differences in the underlying data, since both tables use the same data source. If you could send additional details, to, about how you are specifying your tables (screenshots are very helpful), then I can take a closer look into the causes of this discrepancy.


Feb 21, 2018 - 08:49 AM

Report it


NHGIS: How do I match FIPS Place codes to 1970/1980 Census Place Codes?
distinction between 2000 MIGPUMA1/PWPUMA00 codes and 2010 MIGPUMA1/PWPUMA00
Issues with January 2016 CPS Job Tenure Supplement
Hi! I am looking to do an analysis of food security trends by livelihood zone...
How can I match between June 1995 and September 1995?
YRIMMIG weighting
Login   |   Register

Recently Active Members

View More »

Share |