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 #19139 is a reply to message #18063]

Sun, 26 April 2020 00:54

vpatil
Messages: 9
Registered: March 2019

Member

Hi

I am trying to merge NFHS4 household and Individual datasets and I have tried all the options discussed in the previous thread on this topic but no success. This is what I get:

merge 1:m hv001 hv002 hv003 hv024 using "/Users/drvaishalipatil/Desktop/DHS datasets/RO1 India/RO12015sort.dta"

Result # of obs.
-----------------------------------------
not matched 1,280,793
from master 591,308 (_merge==1)
from using 689,485 (_merge==2)

matched 10,201 (_merge==3)
-----------------------------------------

The final numbers are wrong. I have tried 1:1, 1:1, m:1, and all different possibilities. Please tell me what am I doing wrong.

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: Fri Apr 26 02:06:24 Coordinated Universal Time 2024