The DHS Program User Forum: Dataset use in Stata » Merging Birth's / Chidren's with Household Member Recode

Home » Data » Dataset use in Stata » Merging Birth's / Chidren's with Household Member Recode

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

Re: Merging Birth's / Chidren's with Household Member Recode [message #8702 is a reply to message #8687]

Thu, 03 December 2015 10:56

Trevor-DHS
Messages: 808
Registered: January 2013

Senior Member

You need to include the line number of the person in the merge. For the PR file that is in hvidx and for the BR or KR file it is in b16 (line number of child in household). Note that there are some children in the BR and KR files for whom b16 is 0, 99, or missing (.), because the child in the BR file either does not live in the household or is dead or had missing data - it is best to drop these before merging. Then perform a 1:1 merge to merge the data.

Report message to a moderator

[Message index]

		Merging Birth's / Chidren's with Household Member Recode By: karlo on Wed, 25 February 2015 02:12
		Re: Merging Birth's / Chidren's with Household Member Recode By: Trevor-DHS on Wed, 04 March 2015 09:28
		Re: Merging Birth's / Chidren's with Household Member Recode By: karlo on Wed, 02 December 2015 08:12
		Re: Merging Birth's / Chidren's with Household Member Recode By: Trevor-DHS on Thu, 03 December 2015 10:56
		Re: Merging Birth's / Chidren's with Household Member Recode By: karlo on Fri, 04 December 2015 01:24
		Re: Merging Birth's / Chidren's with Household Member Recode By: marron on Wed, 09 March 2016 16:29
		Re: Merging Birth's / Chidren's with Household Member Recode By: Trevor-DHS on Thu, 10 March 2016 07:42
		Re: Merging Birth's / Chidren's with Household Member Recode By: sammyladele on Mon, 10 October 2016 10:50
		Re: Merging Birth's / Chidren's with Household Member Recode By: Trevor-DHS on Mon, 10 October 2016 11:13
		Re: Merging Birth's / Chidren's with Household Member Recode By: sammyladele on Mon, 10 October 2016 11:18
		Re: Merging Birth's / Chidren's with Household Member Recode By: anikhpg42@gmail.com on Mon, 04 June 2018 03:52
		Re: Merging Birth's / Chidren's with Household Member Recode By: Joyeuse on Wed, 13 March 2024 06:32
		Re: Merging Birth's / Chidren's with Household Member Recode By: Bridgette-DHS on Mon, 18 March 2024 07:22

Previous Topic:	Measles vaccination NFHS 5 India
Next Topic:	DHS 5 India dataset IR file-r900 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 30 12:43:13 Coordinated Universal Time 2025