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: blogpostsaying 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 documentsuggests 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,