The DHS Program User Forum: Merging data files » STATA codes to merge women and household datasets

Home » Data » Merging data files » STATA codes to merge women and household datasets

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

Re: STATA codes to merge women and household datasets [message #17989 is a reply to message #13961]

Sun, 11 August 2019 08:48

Isabelle
Messages: 2
Registered: July 2019

Member

Hello Mrinal and the community,

I am working with the NFHS-2 and I am trying to merge the datasets "household" and "individual" exactly like you described earlier. I used the same code, however, I am not able to merge the datasets as
"variables v001 v002 v003 do not uniquely identify observations in the master data".

I added the commands I used. I cannot identify what I am doing wrong, so I am thankful for any advice.
___________

use "C:\Users\Isabelle\Desktop\DHS Data India\1998-99\Household\IAHR42FL.dta" // household dataset
gen int v001 = hv001
gen int v002 = hv002
gen byte v003 = hv003
sort v001 v002 v003
save "C:\Users\Isabelle\Desktop\DHS Data India\Single Datasets Recode\1998-99Recode\1998-99HouseholdSort.dta", replace

use "C:\Users\Isabelle\Desktop\DHS Data India\1998-99\Individual\IAIR42FL" //women dataset
sort v001 v002 v003
merge 1:m v001 v002 v003 using "C:\Users\Isabelle\Desktop\DHS Data India\Single Datasets Recode\1998-99Recode\1998-99HouseholdSort.dta"

save "C:\Users\Isabelle\Desktop\DHS Data India\Single Datasets Recode\1998-99Recode\1998-99RecMerge.dta"
___________

Kind regards,
Isabelle

Report message to a moderator

[Message index]

		STATA codes to merge women and household datasets By: Mrinal on Fri, 26 January 2018 11:53
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Mon, 29 January 2018 20:05
		Re: STATA codes to merge women and household datasets By: Mrinal on Tue, 30 January 2018 03:28
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 February 2018 11:14
		Re: STATA codes to merge women and household datasets By: Mrinal on Mon, 05 February 2018 01:07
		Re: STATA codes to merge women and household datasets By: boyle014 on Mon, 05 February 2018 13:08
		Re: STATA codes to merge women and household datasets By: Gowokani on Wed, 18 April 2018 18:52
		Re: STATA codes to merge women and household datasets By: boyle014 on Fri, 20 April 2018 14:00
		Re: STATA codes to merge women and household datasets By: priyoma on Tue, 23 October 2018 17:18
		Re: STATA codes to merge women and household datasets By: boyle014 on Thu, 01 November 2018 17:20
		Re: STATA codes to merge women and household datasets By: Isabelle on Sun, 11 August 2019 08:48
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Fri, 23 August 2019 13:40
		Re: STATA codes to merge women and household datasets By: Isabelle on Sat, 24 August 2019 09:56
		Re: STATA codes to merge women and household datasets By: Bridgette-DHS on Tue, 03 September 2019 15:37
		Re: STATA codes to merge women and household datasets By: vpatil on Sun, 26 April 2020 00:54

Previous Topic:	SPA 2012-2017 Senegal
Next Topic:	sample weights in women file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 11:29:49 Coordinated Universal Time 2024