The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » Missing values for anemia
Re: Missing values for anemia [message #9234 is a reply to message #9188] Thu, 25 February 2016 18:15 Go to previous messageGo to previous message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
A response from one of our experts, Dr. Tom Pullum:
Quote:

You are apparently merging an IR file with an HR file. The HR file has one very long record per household. It is much easier to merge the IR file with the PR file, which has one record per household member, as follows. Open the IR file first, then gen hv000=v000; gen hv001=v001; gen hv002=v002; gen hvidx=v003; sort hv000 hv001 hv002 hvidx; save as temp.dta, replace. Then open the PR file; sort hv000 hv001 hv002 hvidx; merge hv000 hv001 hv002 hvidx using temp.dta.

However, you do not even have to do this. v457 in the IR file is the woman's anemia level. It's not necessary to do ANY merging. For each woman, you can also get the anemia levels of her children (up to 6 children born in the past five years) with hw57_1 through hw57_6. Here the subscripts refer to the woman's children. In the HR file, the subscripts refer to the line number in the household survey.




 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Exclusive breastfeeding in Zambia 2013-14 dataset
Next Topic: Children age Namibia DHS VI
Goto Forum:
  


Current Time: Mon Dec 23 14:06:33 Coordinated Universal Time 2024