The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Merge CR and IR
Merge CR and IR [message #13598] Sun, 26 November 2017 01:57 Go to next message
Messages: 3
Registered: November 2017
Good day,

I would like to merge the CR data and IR data.

More specifically, I would like to combine the information of the husband (NOT THE WIFE) from the IR file to the CR file.

In the CR file, there is no information on the husband's height and weight, nor in the MR file. I managed to find it in the IR file. But I couldn't find the identifiers of the husband (e.g., MV***) in the IR file. The IR file is based on the WIFE...and it has more than one man's information in the file (8 actually).

I can also find the men's height and weight info in the HR file, but I don't know how to identify which one is the husband from (HB0$1 to HB0$8).

So, can anyone help me find a way to derive the husband's height and weight information in the IR file and combine it with the CR one?

I have worked on this for two days and haven't made any progress...

Any response is appreciated. Thanks!

[Updated on: Sun, 26 November 2017 02:25]

Report message to a moderator

Re: Merge CR and IR [message #13739 is a reply to message #13598] Fri, 15 December 2017 08:53 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1621
Registered: February 2013
Senior Member
An email was sent to the user, requesting additional information.
Previous Topic: Thoughts on pooling surveys from single country
Next Topic: Merging PR file with KR file
Goto Forum:

Current Time: Fri May 24 01:58:28 Eastern Daylight Time 2019