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

Re: Merging Child and Household data for a new user of Stata [message #26636 is a reply to message #26634]

Wed, 12 April 2023 08:10

rachelsb98
Messages: 6
Registered: April 2023

Member

Thank you, I was wondering if you could help me with another issue I'm coming across. I followed the video, but am still receiving an error that variables "do not uniquely identify observations in the master data". I am using the following code

use "D:\Raw data sets\Albania\Albania 17-18 HH Raw\ALPR71FL.DTA"
*Merging HH and CHild dataset using "https://www.youtube.com/watch?v=SJkJmtgaqBc"
drop if hc60>12
rename hvidx c_line
rename hv001 cluster_line
rename hv002 hh_line
rename hc60 mom_line
order c_line cluster_line hh_line mom_line
save "D:\Raw data sets\Albania\Albania 17-18 HH Raw\Albania 17-18 Merge.DTA", replace

use "D:\Raw data sets\Albania\Albania 17-18 Raw\Albania 17-18 Raw.DTA"
drop if b16==0
rename b16 c_line
rename v001 cluster_line
rename v002 hh_line
rename v003 mom_line
order c_line cluster_line hh_line mom_line

merge 1:1 c_line cluster_line hh_line mom_line using "D:\Raw data sets\Albania\Albania 17-18 HH Raw\Albania 17-18 Merge.DTA"

Do you know what could be the issue? Btw i tried looking at other posts, but couldn't find any with this issue. Thank you!

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: Tue Nov 26 15:12:58 Coordinated Universal Time 2024