Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: DHS Ghana merging question


From   Tharshini Thangavelu <[email protected]>
To   [email protected]
Subject   st: DHS Ghana merging question
Date   Sun, 21 Jun 2009 12:43:17 +0200 (CEST)

Hi all,

I have  a specific question concerning the Ghana DHS survery. I am trying to
clean the dataset so to analysis using a 2SLS method and of IV method. My
dependent variable will be the anthropometric variables controlling for socio
economic factors, mothers education, fathers education ect.

Basically my question is : how does paternal (fathers and mothers) education
improve the child health in Ghana?

I know how to merge but is still confusing! I am trying as the information given
by DHS, that is. I merge first the anthropometric data set with the household
member data. Then, I merge the resulting file with the individual data
to finally merge it with the child recode data file.

The first merging (anthropometric and household member data) only information
for children is kept,which I think is correct. 

Ex. HV105 "the age of household member" gives information about the age of all
the household member. When merging the anthropometric data with the household
member data, as intuitive says HV105 excludes all age above 5 years.

In order to answer my problem question, I need mothers' fathers' age, education
level, their height and weight and other variables. So, What I basically want is
to locate each child with their parents. 

Following the information for merging given by DHS, I should now merge the
resulting file with the women file. But this doesn't give me completely the
result that I am expecting. That is, I need womens age, height and weight. I
know for sure that these variables exist but when merging, they are excluded. 
  
If someone has worked with DHS data set perhaps can give me some advise.
I do one-to-many merging but perhaps I should use many-to-one merging but this
doesn't seem reasonable. 


Regards
Tharshini
-- 
Tharshini THANGAVELU
Forskarbacken 8 / 101
114 16 Stockholm
Sweden
Phone +46 (0)735 53 43 90
E-mail [email protected]
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index