Merging three different files [message #3959] |
Tue, 10 March 2015 12:16 ![Go to next message Go to previous message](/theme/default/images/down.png) |
duke2015
Messages: 27 Registered: March 2015 Location: United States
|
Member |
|
|
Hi there,
Several questions for you....thanks in advance!
I want to work with variables from the women's and household survey of the 2011 Uganda DHS.
Question 1: Is there a general syntax (I'm using Stata) from which to merge these files? My unit of analysis is children under 5.
I merged the household recode file with the children's recode file, and only 7,878 cases were matched, leaving over 4,000 unmatched.
Question 2: Can you explain why only 7878 of the child's dataset were able to match to the household data?
Question 3: Is the children's recode data made by DHS from the information in the women's questionnaire? If I'm interested in looking at maternal level of education, how can I make sure that the woman interviewed is the mother of the child I'm analyzing?
Thanks!
|
|
|