# Join MEPS Full Consolidated Files with Event Files

**URL:** <https://forum.ipums.org/t/join-meps-full-consolidated-files-with-event-files/3759>\
**Category:** HEALTH SURVEYS\
**Created:** [September 17, 2020, 3:18pm UTC](https://forum.ipums.org/t/join-meps-full-consolidated-files-with-event-files/3759 "2020-09-17T15:18:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prashant\_Meckoni](https://avatars.discourse-cdn.com/v4/letter/p/c6cbf5/32.png) [@Prashant\_Meckoni](https://forum.ipums.org/u/Prashant_Meckoni)\
**Post date:** [September 17, 2020, 3:18pm UTC](https://forum.ipums.org/t/join-meps-full-consolidated-files-with-event-files/3759/1 "2020-09-17T15:18:57Z")

</div>

TLDR: Is there an example to join the IPUMS MEPS Full Consolidated Files with any of the MEPS Events files?

The IPUMS MEPS Full Consolidated Files, at the most aggregated level, are at an annual level. So for each `MEPSID` primary key, there are two rows.

What will be the best way to join the Consolidated File and any Events File. I have written two options, please suggest a better one if these are not good enough.

**Option1:** Can I use a combination of `MEPSID+YEAR` from the full consolidated files and then `DUPERSID+PANEL+xxDATEYEAR` from the events file?  
**Option2:** Can I use a combination of `MEPSIDRD+ROUNDRD` from the full consolidated files at round level and then `DUPERSID+PANEL+EVENTRN` from the events file?

---

<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:** [September 17, 2020, 8:07pm UTC](https://forum.ipums.org/t/join-meps-full-consolidated-files-with-event-files/3759/2 "2020-09-17T20:07:31Z")

</div>

The IPUMS MEPS team is working on documentation on linking IPUMS MEPS to other AHRQ MEPS data (including event files), but it isn’t quite ready yet. I will answer your question directly, but keep an eye on the [IPUMS MEPS user guide page](https://meps.ipums.org/meps/userGuide.shtml) for additional information on this soon.

The approach you describe for Option 1 is appropriate; however, I want to share a bit more information and will suggest a slight modification.

First, while I would not expect xxDATEYEAR variables on the event files to include values other than the survey year, rounds (and correspondingly their reference periods) can span more than one calendar year. Because of the complexity of timing information, I would not be surprised if there was occasionally an unexpected value for year in the file. I suggest making your own year of survey variable after reading in the event data and using that to link.

Secondly, AHRQ recently revised DUID (and DUPERSID) to append PANEL to the beginning of the variable. IPUMS MEPS will be updating our documentation and unique identifier accordingly (and retiring the current version of MEPSID–it will still be available under a different variable name). All that to say, review both the IPUMS and AHRQ documentation carefully as the order of the concatenated components of these identifiers is changing/has changed.

---

<div class="post-metadata">

**Author:** ![Prashant\_Meckoni](https://avatars.discourse-cdn.com/v4/letter/p/c6cbf5/32.png) [@Prashant\_Meckoni](https://forum.ipums.org/u/Prashant_Meckoni)\
**Post date:** [September 21, 2020, 4:24am UTC](https://forum.ipums.org/t/join-meps-full-consolidated-files-with-event-files/3759/3 "2020-09-21T04:24:51Z")

</div>

Thank you @KariWilliams.

I already had the made a new variable related to the year of the data file before stacking of events from multiple years’ events’ files. I used that with the `YEAR` column from IPUMS MEPS. It has worked from now.

Thank you for replying. Thanks for updating me on the ARHQ changes and IPUMS expected changes of `MEPSID`.