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


Year-specific data citation in IPUMS-CPS
I wanted to know if IPUMS is still collecting data on India. Specifically the...
Replicating Income and Poverty Census Report with ASEC data
Questions about "not matched" observations between NBER and IPUMS CPS monthly...
Login   |   Register

Recently Active Members

View More »

Share |