The DHS Program User Forum: Child Health » mege databases of multiple countries over several years

Home » Topics » Child Health » mege databases of multiple countries over several years (merging database of multiple countries over several years)

Show: Today's Messages :: Show Polls :: Message Navigator

mege databases of multiple countries over several years [message #20483]

Tue, 10 November 2020 10:12

Tedy
Messages: 14
Registered: July 2020

Member

Good evening dear DHS database experts. I am once again asking for your help in merging the databases. I am working on the effect of parental substance use on the health of their children under 5 years old. I am not familiar with stata, and i would like to merge the databases of multiple countries over several years for children under 5 years old containing information from their parents (father and/or mother), their household and the family structure (single or two-parent).
thank you in advance
sincerely

Report message to a moderator

Re: mege databases of multiple countries over several years [message #20485 is a reply to message #20483]

Tue, 10 November 2020 16:56

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

What variables do you intend to use to describe "parental substance use" and child health? Which surveys and countries include those variables? I suggest that before you think about combining multiple surveys and countries you look at one survey in one country. See how you would identify/describe a relationship in that survey. It may not be as simple as you think.

Report message to a moderator

Re: mege databases of multiple countries over several years [message #20486 is a reply to message #20485]

Wed, 11 November 2020 10:07

Tedy
Messages: 14
Registered: July 2020

Member

Thank you for your response.
The variables we intend to use to describe "parental substance use" are: tobacco use and alcohol use, and we measure "child health" by the nutritional status of children under 5 years of age in terms of weight/age, height/age and weight/height.
In terms of country restriction, we will first use data from Cameroon.
We want to use the 2018, 2011, 2004 surveys from Cameroon.

Report message to a moderator

Re: mege databases of multiple countries over several years [message #20487 is a reply to message #20486]

Wed, 11 November 2020 10:53

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

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

I suggest that you first select just one of these Cameroon surveys and try to identify a relationship between the predictors of interest (tobacco use, etc.) and the outcomes (stunting, underweight, wasted), including controls for other known predictors of the outcomes. You can do most of this with just the KR file, for children who are living with the mother (b9=0). Linking the child with the father in the MR file is not trivial. Stata code for stunting, etc. is available on the website (see the GitHub link). Good luck....

Report message to a moderator

Previous Topic:	Sibling Data Set
Next Topic:	Child health and literacy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 26 05:44:18 Coordinated Universal Time 2024