The DHS Program User Forum: Nutrition and Anthropometry

Home » Topics » Nutrition and Anthropometry » DHS Burundi 1987

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

Re: DHS Burundi 1987 [message #20173 is a reply to message #20144]

Mon, 05 October 2020 14:53

Trevor-DHS
Messages: 774
Registered: January 2013

Senior Member

You need to first merge the data with the PR file (which is the natural file to use for anthropometry for this survey), and then based on that to then merge the PR file with the KR file. Try the following code:

* First merge with PR file as we need the mother's line number plus the cluster and household number
use ETHW41FL.DTA, clear
rename hwhhid hhid
rename hwline hvidx
sort hhid hvidx
save ETHW41FL_sort.DTA, replace

*Members-PR file
use ETPR41FL.DTA, clear
sort hhid hvidx
merge 1:1 hhid hvidx using ETHW41FL_sort.DTA
keep if _merge==3

* Second merge resulting file with KR file
rename hv001 v001 
rename hv002 v002 
rename hc60  v003
rename hvidx b16
keep hhid v001 v002 v003 b16 hc7*
save ETHW41FL_sort2.DTA, replace

*Children-KR file
use ETKR41FL.DTA, clear
sort v001 v002 b16
* drop cases with no matching entry in the PR file
drop if b16==. | b16==0
merge 1:1 v001 v002 b16 using ETHW41FL_sort2.DTA

Note that there will be some cases in the using file that do not match. These are children listed (and weighed and measured) in the PR file that were not children of interviewed women.

Report message to a moderator

[Message index]

		DHS Burundi 1987 By: tnkunzimana on Thu, 06 November 2014 09:15
		Re: DHS Burundi 1987 By: Trevor-DHS on Fri, 07 November 2014 21:47
		Re: DHS Burundi 1987/ another REQUEST By: tnkunzimana on Mon, 10 November 2014 07:53
		Re: DHS Burundi 1987/ another REQUEST By: Trevor-DHS on Mon, 10 November 2014 11:15
		Re: DHS Burundi 1987/ another REQUEST By: tnkunzimana on Mon, 10 November 2014 11:24
		Re: DHS Burundi 1987/ another REQUEST By: Trevor-DHS on Mon, 10 November 2014 14:01
		Re: DHS Burundi 1987/ another REQUEST By: tnkunzimana on Mon, 10 November 2014 23:10
		Re: DHS Burundi 1987/ another REQUEST By: tnkunzimana on Tue, 11 November 2014 04:19
		Re: DHS Burundi 1987/ another REQUEST By: Trevor-DHS on Tue, 11 November 2014 11:46
		Re: DHS Burundi 1987/ another REQUEST By: Trevor-DHS on Tue, 11 November 2014 11:47
		Re: DHS Burundi 1987/ another REQUEST By: Trevor-DHS on Tue, 11 November 2014 11:50
		Re: DHS Burundi 1987/ another REQUEST By: tnkunzimana on Thu, 13 November 2014 04:07
		DHS Burundi 1987 and 2010 By: tnkunzimana on Wed, 19 November 2014 14:29
		Re: DHS Burundi 1987 and 2010 By: Trevor-DHS on Thu, 20 November 2014 18:26
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Fri, 28 November 2014 00:59
		Re: DHS Burundi 1987 and 2010 By: Trevor-DHS on Fri, 28 November 2014 12:37
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Fri, 06 March 2015 13:32
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Fri, 06 March 2015 13:36
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Mon, 09 March 2015 12:09
		Re: DHS Burundi 1987 and 2010 By: Trevor-DHS on Tue, 10 March 2015 12:39
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Tue, 10 March 2015 14:50
		Re: DHS Burundi 1987 and 2010 By: Reduced-For(u)m on Sat, 07 March 2015 17:23
		Re: DHS Burundi 1987 and 2010 By: tnkunzimana on Mon, 09 March 2015 05:30
		Re: DHS Burundi 1987 By: id709nvz on Mon, 28 September 2020 17:14
		Re: DHS Burundi 1987 By: Trevor-DHS on Mon, 05 October 2020 14:53
		Re: DHS Burundi 1987 By: id709nvz on Mon, 05 October 2020 16:52
		Re: DHS Burundi 1987 By: Trevor-DHS on Mon, 05 October 2020 18:17
		Re: DHS Burundi 1987 By: id709nvz on Tue, 06 October 2020 11:55
		Re: DHS Burundi 1987 By: Trevor-DHS on Tue, 06 October 2020 13:10
		Re: DHS Burundi 1987 By: id709nvz on Tue, 06 October 2020 21:39
		Re: DHS Burundi 1987 By: Trevor-DHS on Wed, 07 October 2020 00:31
		Re: DHS Burundi 1987 By: id709nvz on Wed, 07 October 2020 04:47
		Re: DHS Burundi 1987 By: Trevor-DHS on Wed, 07 October 2020 10:01
		Re: DHS Burundi 1987 By: id709nvz on Wed, 07 October 2020 10:18
		Re: DHS Burundi 1987 By: Trevor-DHS on Sat, 07 March 2015 17:41

Previous Topic:	estimating nutritional status
Next Topic:	Definition of prelacteal feed in Indonesia DHS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Aug 14 03:29:21 Coordinated Universal Time 2022