Status:Closed    Asked:Aug 17, 2017 - 10:54 AM

How can I attach the PWCMPWGT weight to pooled CPS Basic Monthly data, 1990-2016?

I am looking to attach the PWCMPWGT to a pooled CPS Basic Monthly IPUMS dataset from 1990-2016 in order to replicate some BLS estimates. A step-by-step guide on how to merge this weight variable from NBER extracts with IPUMS CPS data would be helpful.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


Here are a few helpful notes regarding merging IPUMS CPS data with NBER CPS data. (1) NBER data includes non-response households. So, if you drop the non-interviewed households from the NBER file, the record counts should align with the record counts in IPUMS CPS files. (2) If you are merging basic monthly samples a 1:1 merge is possible using HRHHID, HRHHID2, and LINENO as linking keys. Also note that in the NBER file, you'll need to rename the PULINENO to LINENO to allow the merge to work properly. (3) Finally, although it may be a bit tedious, I'd recommend performing this merge one sample at a time. This way you won't mistakenly link different households.


Aug 17, 2017 - 02:18 PM

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 |