Question

Status:Closed    Asked:Aug 21, 2018 - 04:34 AM

Merge monthly IPUMS CPS with NBER ORG

Hi,


I'm trying to extend the CPS IPUMS dataset with the NBER outgoing rotation files (http://www.nber.org/morg/annual/), because the former only has data on hourly wages until 1989, the latter until 1979. I'm using the basic monthly IPUMS CPS dataset.


I found this post: blogpost saying that I should use hrhhid (hhid in NBER), hrhhid2, huhhnum (hhnum in NBER), hrsample, hrsersuf and lineno as keys in the merge, but for these early ORG samples, hrhhid2, hrsample and hrsersuf don't exist and the other three variables don't uniquely identify observations in either the CPS or the NBER files.


This document suggests that I should use hhid, hhnum, lineno and combine these with minsamp (mish in CPS) and intmonth (month in CPS) to use them as keys in the merge. But even then, variables are not uniquely identified.


Thank you very much for your help,


John

 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Jeff Bloem

Staff

I've taken a bit of time to look into this myself and also find that these variables (even with month in sample, month, and year included) do not uniquely identify observations in the NBER MORG samples from 1979 through 1989. This being the case, I am not able to provide much guidance on linking IPUMS CPS outgoing rotation group data to the NBER MORG samples during this time frame.

This detail is related to a larger ongoing project with IPUMS CPS that aims to allow full comparability and linking of the outgoing rotation groups all the way back to 1979. This project is not yet completed, however, and so there is not much additional detail that I can offer. Regarding unique identification and the perhaps incorrect documentation, I'd suggest reaching out to Jean Roth at jroth@nber.org.

 

Aug 22, 2018 - 09:44 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Should the IPUMS-CPS and NBER CPS data match?
Merging issues with the Sep 2000, Apr 2001, Jun 2001 and Feb 2002 basic month...
Merging NBER MORG and May files with CPS IPUMS: Help?
Merge CEPR CPS ORG data and IPUMS CPS
Login   |   Register

Recently Active Members

View More »

Share |