The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merge CR and IR

Show: Today's Messages :: Show Polls :: Message Navigator

Merge CR and IR [message #13598]

Sun, 26 November 2017 01:57

yuchuan.liu.2015@smu.edu.
Messages: 3
Registered: November 2017

Member

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