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: 3189
Registered: February 2013
Senior Member
Following is a response from DHS Stata Specialist, Tom Pullum:

Almost all surveys with male respondent 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.

[Updated on: Tue, 15 March 2022 06:25]

Report message to a moderator

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: 3189
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 messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3189
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).
Re: Couple file from male and female dataset [message #24201 is a reply to message #13107] Mon, 14 March 2022 08:42 Go to previous messageGo to next message
Gaurav Dhamija is currently offline  Gaurav Dhamija
Messages: 2
Registered: May 2019
Member
Dear Bridgette,

As you have mentioned that all the DHS have couple record files, Is it true for the India DHS rounds conducted in 1992-93 and 1998-99?
I know the later rounds (2005-06 and 2015-16) have these files but I am not sure if it is there for the above mentioned rounds.


In case it is not there, I am interested in comparing husband' and wife' years of education in all the four rounds. This information is there in the IR files of 1992-93 and 1998-99. Can I compare husband' and wife' years of education data from IR files of 1992-93 and 1998-99 to CR files of 2005-06 and 2015-16?

I am not sure if the partner's years of education in the IR files is reported by the wife or the husband. If it is reported by the wife then the problem is IR files will have partner's education reported by wife but CR files will partner's education reported by partner only?

Please let me know if you need any other information to answer this query.

Looking forward to your response.
Re: Couple file from male and female dataset [message #24206 is a reply to message #24201] Tue, 15 March 2022 06:28 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3189
Registered: February 2013
Senior Member

Following is response from DHS Research & Data Analysis Director, Tom Pullum:

It is not true that all surveys have a couples file. Some surveys do not include men. The surveys you mentioned, in fact, did not include men and therefore do not have MR or CR files.

If a woman is asked a question about her husband, for example about his age or occupation, and the man is also asked the same thing about himself, then the man's self-response would have priority. However, the two responses can be compared. Similarly, the woman's responses in the women's survey about her age, education, etc. are given priority over the corresponding responses from the household respondent during the household survey. Self-responses are always preferable but you can learn something about data quality (and communication within the household) by comparing self-responses with what someone else said.
Previous Topic: Linking parents to anthropometric Data
Next Topic: How to weight merged PR and IR files- Afghanistan DHS
Goto Forum:
  


Current Time: Thu Nov 7 17:58:58 Coordinated Universal Time 2024