Question

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!


S



 
Do you have the same question? Follow this Question
 

Staff Answer

avatar

Tim_Moreland

Staff

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

1
0
Report it

Answers

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.

Thanks!

Sergio

 

Mar 14, 2016 - 11:51 AM

0
0
Report it

OTHER QUESTIONS NEEDING ANSWERS

Can I merge IPUMS-CPS variables to raw March 2011 CPS data?
How to merge IPUMS CPS with IPUMS USA?
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...
Login   |   Register


Share |