The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Merging households members files+male files+female files
Merging households members files+male files+female files [message #6762] Fri, 10 July 2015 16:56 Go to next message
Roseline is currently offline  Roseline
Messages: 2
Registered: July 2015
Location: switzerland
Member
Hi,

i have a problem with my merge. i would like to merge households members, man and female files with the Mali's data (2006). i followed all procedure for the merging but every time i have with the results matched=0. i don't know what happens, if someone can help me, i use STATA.
thank you
Re: Merging households members files+male files+female files [message #6764 is a reply to message #6762] Fri, 10 July 2015 20:36 Go to previous messageGo to next message
Reduced-For(u)m
Messages: 292
Registered: March 2013
Senior Member

What do you mean by wanting to "merge" those two? In one case, the unit of observation is women; in the other, it is men. Do you mean you want to "merge" them into a single household in a way that gets you more information than the household recode? Or do you just want to have all the men and all the women in a single dataset?

If you just want all the men and all the women, you don't want to "merge", you want to "append" - that is, you want to add new observations, not add more information to the same observations.

If you want household-level information, you might start with that recode, and then you would merge in the additional information you need based on household ID.
Re: Merging households members files+male files+female files [message #6765 is a reply to message #6764] Fri, 10 July 2015 20:56 Go to previous messageGo to next message
Roseline is currently offline  Roseline
Messages: 2
Registered: July 2015
Location: switzerland
Member
yeah, i finally got the solution. it should be used the couple's file that contains the both (men and women's file).

Now i need to merge wealth index (wi)and household member file (PR).
Thank
Re: Merging households members files+male files+female files [message #6840 is a reply to message #6765] Tue, 21 July 2015 08:32 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3017
Registered: February 2013
Senior Member
I don't see a question here. Have you already figured out what you need to do, or are you requesting assistance?
Previous Topic: Error after using SELECT - "File does not contain dictionary"
Next Topic: Institutional deliveries
Goto Forum:
  


Current Time: Fri Mar 29 00:51:29 Coordinated Universal Time 2024