The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » Couple file from male and female dataset
Couple file from male and female dataset [message #13106] Thu, 21 September 2017 02:22 Go to next message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Member
HI, I am trying to make couple file from male and female dataset. I created new file using V001+V002+V034 (with female dataset) and MV001+MV002+MV034$1 (with male dataset), I renamed the variables name in male dataset similar to female dataset. How we can match the husband and wife where V034 and MV034 values are too different (such as in female dataset mostly have value 1 but in male dataset mostly have value 2)
What is the command to merge only to keep couple dataset, STATA command is okey, if R command is not available. Thank you.


DNB

[Updated on: Thu, 21 September 2017 13:38]

Report message to a moderator

Re: Couple file from male and female dataset [message #13107 is a reply to message #13106] Thu, 21 September 2017 13:43 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
Registered: February 2013
Senior Member
Following is a response from DHS Stata Specialist, Tom Pullum:

Almost all surveys have a CR file in which partners in the IR and MR files are already matched. Please look for that file. Let us know if you can't find it.

Re: Couple file from male and female dataset [message #13109 is a reply to message #13107] Thu, 21 September 2017 14:02 Go to previous messageGo to next message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Member
Hi Tom,
Thank you for your reply. I am using IR and MR files. I would like to combine both files to make couple file for further analysis. Shall I do this or not to make couple file. If yes, how could I combine and If not, What should I do.

I could not find the CR file for Pakistan (2012-13) dataset. For this, how could we make CR file.

Thank you,


DNB

[Updated on: Thu, 21 September 2017 16:28]

Report message to a moderator

Re: Couple file from male and female dataset [message #13134 is a reply to message #13107] Tue, 26 September 2017 12:48 Go to previous messageGo to next message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Member
Is there any way to get a CR file for Pakistan (2012-13) DHS?

DNB
Re: Couple file from male and female dataset [message #13135 is a reply to message #13134] Tue, 26 September 2017 14:09 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
Registered: February 2013
Senior Member
There are no couples' files for this survey, since we did not collect the data for MV034: Line number of wife/partner.
Re: Couple file from male and female dataset [message #13136 is a reply to message #13135] Tue, 26 September 2017 14:16 Go to previous messageGo to next message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Member
Thank you,

DNB
Re: Couple file from male and female dataset [message #13141 is a reply to message #13136] Wed, 27 September 2017 17:05 Go to previous messageGo to next message
Christopher is currently offline  Christopher
Messages: 4
Registered: February 2017
Location: taipei, Taiwan
Member
Thank you for your response on the merge of IR and MR,
I also have a similar problem but mine is different;


Am trying to find the impact of men involvement in the uptake of Antenatal care for the Malawi DHS trying to compare the three data sets of 2004,2010 &2016. hence i want to merge the Individual records for the year and the Men's record; i tried to use the couple records but has only those records of the married individuals but i also want to have a general overview of all women in the sample.

Help me out with the SAS command that i may use in merging the Individual Record (mwir7hsd) & Mens Record (mwmr7hsd) for Malawi dataset.

Thank you.
Re: Couple file from male and female dataset [message #13143 is a reply to message #13141] Wed, 27 September 2017 22:42 Go to previous messageGo to next message
dnbhatta is currently offline  dnbhatta
Messages: 9
Registered: September 2017
Location: Nepal
Member
I do not have idea with SAS command. However, If you are using R, do rbind with different data sets. Before using the command make sure the variable names must be similar.

Thanks


DNB
Re: Couple file from male and female dataset [message #18426 is a reply to message #13107] Thu, 28 November 2019 03:35 Go to previous messageGo to next message
NVanEekert is currently offline  NVanEekert
Messages: 5
Registered: October 2017
Member
Dearest,

I am looking for the couple s file of the Egyptian DHS - but unfortunately don't find it.
Could you help me with this?

Best,
Nina
Re: Couple file from male and female dataset [message #18506 is a reply to message #18426] Wed, 11 December 2019 09:38 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
Registered: February 2013
Senior Member
Please send all data availability or data access questions to archive@dhsprogram.com. Be sure to specify the survey name (country and year).
Previous Topic: Merge PR and KR in wave 3, b16 does not exist
Next Topic: Merging IR and PR data files
Goto Forum:
  


Current Time: Wed Apr 8 01:45:36 Eastern Daylight Time 2020