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 #26642 is a reply to message #26638]

Wed, 12 April 2023 11:28

rachelsb98
Messages: 6
Registered: April 2023

Member

I was able to do it with the ALbania dataset. However, with my Angola dataset, I was able to complete it. However, almost half of the data did not match. Is this okay? I just want to ensure I'm not doing something wrong.

Here is my code for reference:
set more off
clear

set maxvar 32000
set more off
clear

use "D:\Raw data sets\Angola\Angola 15-16 HH Raw\AOPR71FL.DTA"
keep hc60 hvidx hv001 hv002 hv007 hv000 hv246 hv235 hv238a hv014
drop if hc60>18
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
gsort c_line cluster_line hh_line mom_line
save "D:\Raw data sets\Angola\Angola 15-16 HH Raw\Angola 15-16 Merge.DTA", replace

use "D:\Raw data sets\Angola\Angola 15-16 Raw\Angola 15-16 Raw.DTA"
keep v000 v007 b16 v001 v002 v003 v465 v190 v012 v102 v106 m39a v113 v116 v160 v501 v157 v158 v159 m70 h43
drop if b16==0|b16==.
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
gsort c_line cluster_line hh_line mom_line

merge 1:1 c_line cluster_line hh_line mom_line using "D:\Raw data sets\Angola\Angola 15-16 HH Raw\Angola 15-16 Merge.DTA"

Thank you you've been very helpful

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 17:11:54 Coordinated Universal Time 2024