# Matching ipums cps to census cps asec

**URL:** <https://forum.ipums.org/t/matching-ipums-cps-to-census-cps-asec/4936>\
**Category:** CPS\
**Created:** [October 26, 2022, 11:37pm UTC](https://forum.ipums.org/t/matching-ipums-cps-to-census-cps-asec/4936 "2022-10-26T23:37:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![patricia\_malagon](https://avatars.discourse-cdn.com/v4/letter/p/b5a626/32.png) [@patricia\_malagon](https://forum.ipums.org/u/patricia_malagon)\
**Post date:** [October 26, 2022, 11:37pm UTC](https://forum.ipums.org/t/matching-ipums-cps-to-census-cps-asec/4936/1 "2022-10-26T23:37:03Z")

</div>

Hi I’m attempting to match recent years from ipums cps to census data. I’m trying to merge by  
hseq and pernum in ipums to h\_seq and pppos in census  
or  
hrhhid+hrhhid2 and lineno in ipums to h\_idnum and a\_lineno in census  
but after merging I check if sex, age, and race of respondents match between the datasets and there’s a mismatch.

I would appreciate any help! Thank you

---

<div class="post-metadata">

**Author:** ![KariWilliams](https://avatars.discourse-cdn.com/v4/letter/k/82dd89/32.png) [@KariWilliams](https://forum.ipums.org/u/KariWilliams)\
**Post date:** [October 28, 2022, 9:27pm UTC](https://forum.ipums.org/t/matching-ipums-cps-to-census-cps-asec/4936/2 "2022-10-28T21:27:47Z")

</div>

This [blog post](https://blog.popdata.org/mergecpsfile/) from a former colleague of mine describes how to merge IPUMS and other versions of CPS data. I recommend comparing your merge criteria with those in the blog post.

Also, I am not sure why you are linking the IPUMS and original versions of the data, but will note that IPUMS CPS offers [unharmonized variables](https://cps.ipums.org/cps/unharmonized_variables.shtml) to streamline access to the original CPS data prior to IPUMS harmonization methods.