Status:Closed    Asked:Mar 07, 2016 - 11:59 AM

Merge IPUMS CPS prior 2006

Hi there,

I am trying to merge individuals between different years of the March CPS. After 2004 I use the variables

mish sex lineno hrhhid hrhhid2

to merge and it works very well, merging the expected number of infividuals considering the rotation of the panel.

However, when I move back of 2005, the variable hrhhid2 is not available anymore and I cannot find a set of variables that help me to merge let say, march CPS individuals in 2005 to those in 2006, or even 2004 to 2003 data sets.

Is there anyway to merge those series?

Many thanks!


Do you have the same question? Follow this Question

Staff Answer




Prior to 2005, you will want to use HUHHNUM, in place of HRHHID2, to link ASEC samples. Unfortunately, this is not guaranteed to give you a unique match across samples, as the ASEC includes an oversample of households from adjacent months. IPUMS-CPS is currently working on a variable called MARBASECID to facilitate linking across ASEC samples (see this previous answer). In the meantime, you can use person-level characteristics such as SEX, AGE, and RACE to help improve your match rate.

Hope this helps.


Mar 10, 2016 - 02:24 PM

Report it


Hi Tim,

yes it helped. Now I was able to match up to 1996 but before that seem to be impossible. Anyway. Looking forward for the new variable.




Mar 14, 2016 - 11:51 AM

Report it


Can I merge IPUMS-CPS variables to raw March 2011 CPS data?
Can I merge 1980 data with 2005 by conspuma?
Why are not all the "not in the labour force" categories filled for the EMPST...
Why does the CPS December 2015 Food Supplement Survey not merge with the Marc...
I am getting strange numbers for NIU persons in the sixties, especially 1962-...
Login   |   Register

Recently Active Members

View More »

Share |