Status:Closed    Asked:Jul 25, 2017 - 04:24 PM

Labor Force Participation by Age for the year 2014 looks very different

I am using the online SDA frequency tool trying to recreate a chart I saw in a Pew Research study from 2015 (U.S. Labor Force by Generation, 1995-2015). I set my variables as follows: row=Year, column=age, selection filter=labforce(2), weight=wtsupp. The table that results looks in line with what I would expect, except the year 2014. The year 2014 looks like it is about double the average of the years before (2013) and after (2015), for every age break and the total. The unweighted data does not appear to mimic this outlying result for year 2014. Any suggestions?

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


Yeah, this is a funny quirk of the CPS ASEC sample for 2014. In this year, the Census Bureau fielded an experimental redesign of the income questions in the ASEC. To preserve comparability, they split the 2014 ASEC sample into two groups: 3/8ths received the redesigned income questions and 5/8ths received the old income questions. Importantly, both groups were given WTSUPP values so that each independently could calculate representative statistics. In SDA you are pooling these two groups together, so that is why you are calculating statistics that are roughly double what you are expecting. Unfortunately, there is currently no way around this in the online analysis tool. The HFLAG variable exists to identify which group households in the 2014 ASEC sample belong, but it is currently not available in SDA. The IPUMS CPS team hopes to add this variable to SDA soon. More information about the 2014 3/8ths file is available here.


Jul 26, 2017 - 10:24 AM

Report it


I am looking for the Kessler 6 variable in IPUMS-MEPS
Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Login   |   Register

Recently Active Members

View More »

Share |