The DHS Program User Forum - RDF feed
https://userforum.dhsprogram.com/index.php
Merging IR and MR files India
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20127&th=9332#msg_20127
I am working with the DHS 2015-2016 datasets for India. I am trying to merge women with men to create a dataset with couples as the unit of measurement. I know a couple recode is available but I would like to do it manually to retain all of the variables I need. Please find my Stata code for this merge attached.
Is this the correct way to do this? If yes, why do I have 63,996 matched couples while the couple recode dataset provided by DHS has 63,696 observations?
Thank you in advance for your help.
]]>DHSUser2322020-09-28T13:46:34-00:00Re: Merging IR and MR files India
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20143&th=9332#msg_20143
Following is a response from DHS Research & Data Analysis Director, Tom Pullum:
Constructing couples is not easy. I suggest that you DO use the CR file. If you want more variables for women, then merge the CR with the IR and keep cases with _merge=3. Then drop _merge and merge the CR with the MR and keep cases with _merge=3. This will be much easier than trying to reproduce the matching of partners.
]]>Bridgette-DHS2020-09-28T18:35:08-00:00Re: Merging IR and MR files India
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20148&th=9332#msg_20148
duplicates report mv001 mv002 mv003
Duplicates in terms of mv001 mv002 mv003
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 63512 0
2 | 184 92
--------------------------------------
]]>DHSUser2322020-09-30T09:44:24-00:00Re: Merging IR and MR files India
https://userforum.dhsprogram.com/index.phpindex.php?t=rview&goto=20196&th=9332#msg_20196
Following is another response from DHS Research & Data Analysis Director, Tom Pullum:
With the India files, you need to include region in the identifiers. For women, you merge with v001 v002 v003 v024 and for men you merge with mv001 mv002 mv003 mv024. Sorry for forgetting that. The India surveys are the only ones for which you need to include region.]]>Bridgette-DHS2020-10-07T11:47:12-00:00