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


What is the IPUMS equivalent to what the actual CPS basic monthly calls PRWKS...
IPUMS monthly CPS sort order compared to the DataFerrett's monthly CPS sort o...
How do I drop repeated records if I combine 9 months of CPS Basic Monthly Dat...
Merging issues with the Sep 2000, Apr 2001, Jun 2001 and Feb 2002 basic month...
Login   |   Register

Recently Active Members

View More »

Share |