The DHS Program User Forum: Merging data files » Duplicates in KR file and Empty values for HV005 after merging.

Home » Data » Merging data files » Duplicates in KR file and Empty values for HV005 after merging.

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

Re: Which variable to use. [message #15143 is a reply to message #15116]

Thu, 07 June 2018 17:53

Bridgette-DHS
Messages: 3043
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

I think you may be making this more complicated than necessary. This part of table 10.1 in the NFHS report is constructed directly from the KR file, with children as units. The following lines will give you, for example, the 45.8% in the image you attached. This is the percentage of children who are stunted, given that the mother is underweight. This could be modified to give more numbers, but for simplicity I just match that number. Can you try this approach?

gen stunted=0
replace stunted=100 if hw70<-200
replace stunted=. if hw70<-600 | hw70>600

gen mo_underwt=0
replace mo_underwt=1 if v445<1850
replace mo_underwt=0 if v445>=99988

summarize stunted if mo_underwt==1 [iweight=v005/1000000]

Report message to a moderator

[Message index]

		Duplicates in KR file and Empty values for HV005 after merging. By: Mayank_Ag on Fri, 01 June 2018 06:09
		Re: Duplicates in KR file and Empty values for HV005 after merging. By: Bridgette-DHS on Tue, 05 June 2018 08:30
		Which variable to use. By: Mayank_Ag on Tue, 05 June 2018 14:10
		Re: Which variable to use. By: Bridgette-DHS on Thu, 07 June 2018 17:53
		Re: Which variable to use. By: Mayank_Ag on Fri, 08 June 2018 05:57
		Re: Which variable to use. By: Mayank_Ag on Tue, 10 July 2018 02:34

Previous Topic:	Merging HW to IR for Mali DHS IV - Missing HWCASEID
Next Topic:	Appending datasets of one country for several years

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 07:53:04 Coordinated Universal Time 2024