The DHS Program User Forum: Merging data files » Merging Child and Household data for a new user of Stata

Home » Data » Merging data files » Merging Child and Household data for a new user of Stata

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

Merging Child and Household data for a new user of Stata [message #26629]

Tue, 11 April 2023 14:59

rachelsb98
Messages: 6
Registered: April 2023

Member

Hello,

I am trying to merge the Child's dataset with the Household dataset. I have tried using this video as a guide: https://www.youtube.com/watch?v=SJkJmtgaqBc. I believe this merges on hvidx, hv001, hv002, and hc60. However, the variable "hvidx" is not in my dataset (currently using the Afghanistan 2015 dataset, but will eventually have to merge the data of over 50 countries). It does however include a variable called "hvidx_01" and subsequently hvidx_02, hvidx_03 . . . hvidx_21. How do I circumvent this issue? I am new to Stata and statistical modeling in general and would appreciate any help. Any advice on how to merge the child dataset and the household dataset is well appreciated.

Report message to a moderator

[Message index]

		Merging Child and Household data for a new user of Stata By: rachelsb98 on Tue, 11 April 2023 14:59
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 07:03
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 08:10
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 08:41
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 08:43
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 11:28
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Wed, 12 April 2023 15:06
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Wed, 12 April 2023 16:08
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Thu, 13 April 2023 07:15
		Re: Merging Child and Household data for a new user of Stata By: rachelsb98 on Thu, 13 April 2023 07:33
		Re: Merging Child and Household data for a new user of Stata By: Bridgette-DHS on Thu, 13 April 2023 08:07

Previous Topic:	Merging KR to MR OR (KR, IR, MR)
Next Topic:	How to merge KR and IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 7 17:58:34 Coordinated Universal Time 2024