# Merge IPUMS CPS and CEPR CPS

**URL:** <https://forum.ipums.org/t/merge-ipums-cps-and-cepr-cps/2262>\
**Category:** CPS\
**Created:** [April 6, 2018, 1:18pm UTC](https://forum.ipums.org/t/merge-ipums-cps-and-cepr-cps/2262 "2018-04-06T13:18:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Johannes\_Mueller](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@Johannes\_Mueller](https://forum.ipums.org/u/Johannes_Mueller)\
**Post date:** [April 6, 2018, 1:18pm UTC](https://forum.ipums.org/t/merge-ipums-cps-and-cepr-cps/2262/1 "2018-04-06T13:18:00Z")

</div>

Dear all,

I am trying to merge the IPUMS CPS data to CEPR CPS data at the person (nested in household) level.

Are there any unique identifiers I could use? In which way have they been adjusted in the IPUMS CPS?

f.e. cpsid cpsidp would be good candidates I guess but the CEPR quivalent of them is much shorter; what could I do here?

Best

Jo

---

<div class="post-metadata">

**Author:** ![Michelle\_Pratt](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/michelle_pratt/32/194_2.png) [@Michelle\_Pratt](https://forum.ipums.org/u/Michelle_Pratt)\
**Post date:** [April 6, 2018, 7:59pm UTC](https://forum.ipums.org/t/merge-ipums-cps-and-cepr-cps/2262/2 "2018-04-06T19:59:00Z")

</div>

I am not familiar with the structure of data provided by CEPR, however, here are links where you can find available technical and linking variables in IPUMS CPS:

- Household level - [technical](https://cps.ipums.org/cps-action/variables/group?id=h-core_tech)

- Household level - [linking](https://cps.ipums.org/cps-action/variables/group/h-core_linking)

- Person level - [technical](https://cps.ipums.org/cps-action/variables/group?id=core_link)

- Person level - [linking](https://cps.ipums.org/cps-action/variables/group/core_link)

This [document](https://cps.ipums.org/cps/resources/linking/drew_flood_warren_2014_jesm.pdf) goes into detail about the creation of CPSID and CPSIDP. You may want to see what household identifiers are available in CEPR; we have a variable, [HRHHID](https://cps.ipums.org/cps-action/variables/HRHHID#description_section), which is part 1 of the CPS household ID on the original files, that sounds like it may be helpful.