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 #29818 is a reply to message #29816]

Thu, 08 August 2024 14:01

Trevor-DHS
Messages: 802
Registered: January 2013

Senior Member

Hi Jacob

A couple of problems with your code: 1) caseid in the women's data is 15 characters, whereas hwhhid is just 12 characters for the household ID. You need to drop the woman's line number part of caseid which is the last 3 characters. 2) midx is the variable that links from the KR file to the birth history, not to the household schedule. B16 is the variable that links to the household schedule.

I think the following code should do what you need:

* Sort the children's recode data and then merge
use "${kr2003}", clear
gen hwhhid = substr(caseid,1,12)
clonevar hwline = b16
sort hwhhid hwline
merge m:1 hwhhid hwline using "${hw2003}"

and then just use those cases with _merge==3 (it looks like there are 6 cases that do not match properly, with _merge==2)

Cheers. Trevor

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: Adetunji on Thu, 08 August 2024 13:19
		Re: DHS Burundi 1987 By: Trevor-DHS on Thu, 08 August 2024 14:01
		Re: DHS Burundi 1987 By: Adetunji on Mon, 12 August 2024 13:41
		Re: DHS Burundi 1987 By: Trevor-DHS on Mon, 12 August 2024 17:33
		Re: DHS Burundi 1987 By: Trevor-DHS on Sat, 07 March 2015 17:41

Previous Topic:	Mozambique: Standard DHS, 2022-23, KR Dataset
Next Topic:	Minimum acceptable diet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Sep 1 04:14:26 Coordinated Universal Time 2024