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

From |
Tharshini Thangavelu <thth4658@student.su.se> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: DHS Ghana variable construction question |

Date |
Thu, 30 Jul 2009 13:57:44 +0200 (CEST) |

Friedrich, Thanks for the explanations! This means that I only need few variables from individual data, since by hhid and hvidx I can find most of the family and household characteristics. I should be able to use hhid and hvidx, with hv112 and hv114 to get all the variables I am interested of, including variables such as; Households assets; have TV, radio, hand wash but also some of the women empowerment variables in individual data; v743a - v743e which indicates final say about healthcare, ect. My research project is: does parental education improve child health in Ghana? The child health is measured by height for age Z-score (HAZ). This is the reason I was confused when I did the merging. How come we don't have to use : keep _merge == 3, since for me this is rather intuitive to work with a dataset having both using and masterdata. Particularly, since I am working with children with HAZ and their parents' and household characteristics. Tharshini On 2009-07-29, at 19:13, Friedrich Huebler wrote: > Tharshini, > > You introduce unnecessary complications by looking at variables like > v730 or v447a. You already know how to create variables with the > mother's and father's age. > > The household member recode file from the Ghana DHS 2003 allows us to > identify the mother's age for 9411 children. 9409 of these children > have mothers that are at least 15 years old. Two children supposedly > have mothers aged 5 years but we can assume that this is an error that > was introduced during data collection or subsequent processing by > survey staff. Household survey data cannot be guaranteed to be without > error. > > How do you identify the mother's and father's level of education or > any other characteristic? Take the commands used to identify the > parents' ages and replace the age variable hv105 by the respective > variable of interest, for example hv109 with a person's educational > attainment. > > bysort hhid (hvidx): gen med = hv109[hv112] > bysort hhid (hvidx): gen fed = hv109[hv114] > > Whether you have to merge your data with additional datasets, for > example the individual recode file, is determined by the needs of your > research project. > > Friedrich > > P.S. List members who follow this thread and are not familiar with the > Demographic and Health Surveys will find a description of the data > under discussion at the following URL. > > http://www.measuredhs.com/aboutsurveys/search/metadata.cfm?surv_id=235&ctry_id=14&SrvyTp=country > > On Wed, Jul 29, 2009 at 12:15 PM, Tharshini > Thangavelu<thth4658@student.su.se> wrote: >> Friedrich, >> >> Thanks! I followed the new way, which actually gave the same results as one of >> the previous case. I did it in the original dataset, ie. household member >> report. It seems strange that mothers' age have min value of 5. When tabulating, >> only one observation had value 5. I assumed that it is missing value and >> replaced it. >> >> sum mage fage >> >> Variable | Obs Mean Std. Dev. Min Max >> -------------+-------------------------------------------------------- >> mage | 9411 35.21177 8.643875 5 76 >> fage | 7265 44.92953 12.64342 19 99 >> >> ________________________________________________________________________ >> The following output is to show the difference between in the two variables >> which normally should be the same. I still have not figured out why this is not >> the case. >> >> >> . sum v730 fage >> >> Variable | Obs Mean Std. Dev. Min Max >> -------------+-------------------------------------------------------- >> v730 | 4463 40.52028 11.91459 18 99 >> fage | 7265 44.92953 12.64342 19 99 >> >> . sum v447a mage >> >> Variable | Obs Mean Std. Dev. Min Max >> -------------+-------------------------------------------------------- >> v447a | 6502 29.45709 9.297519 15 49 >> mage | 9409 35.2182 8.633561 15 76 >> >> >> >> Until now I have used the variables v730 partners age, I assumed this as fathers >> age and mothers age as v447a (womens age in years from household report.) For >> education I used hc62 and v702 respectively. The method that was introduced by >> finding the mothers and fathers age by including hhid hvidx is new for me and >> confusing. >> >> How do I now find mothers and fathers education level? >> >> >> Does this mean that I don't have to merge with the individual recode file once I >> have merged with anthropometric and household member data? >> >> I think I am getting rather confused about how to work with microlevel data. I >> actually did some regression outputs but I was working with the dataset which >> had 3402 observation. That is I had deleated _merge variable and kept == 3(both >> using and master data.) >> >> Tharshini >> >> >> On 2009-07-29, at 15:12, Friedrich Huebler wrote: >>> Tharshini, >>> >>> Your excerpt from the data shows that you changed the sort order >>> before you created the variables mage and fage. Try this: >>> >>> bysort hhid (hvidx): gen mage = hv105[hv112] >>> bysort hhid (hvidx): gen fage = hv105[hv114] >>> >>> Friedrich > > * > * 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/ -- Tharshini THANGAVELU Forskarbacken 8 / 101 114 16 Stockholm Sweden Phone +46 (0)735 53 43 90 E-mail thth4658@student.su.se * * 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/

**References**:**Re: st: DHS Ghana variable construction question***From:*Friedrich Huebler <fhuebler@gmail.com>

- Prev by Date:
**st: help with "joinby"** - Next by Date:
**st: Thanks** - Previous by thread:
**Re: st: DHS Ghana variable construction question** - Next by thread:
**st: -ml display- in Stata 11** - Index(es):

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