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


problem loading data in stata 10
South & Central America CPS
Missing observation from Regency Aceh Tenggara in Indonesia 1971 census
Hi is there a way to get the foreign born population for a city (Elizabeth, N...
Is there a way that I can convert a DAT file to a STATA file? If so, how is t...
Underlying files for CPS Education Supplements (October)?
Login   |   Register

Recently Active Members

View More »

Share |