The DHS Program User Forum: Merging data files » Issue merging NFHS 2 women and household dataset

Home » Data » Merging data files » Issue merging NFHS 2 women and household dataset

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

Issue merging NFHS 2 women and household dataset [message #13962]

Tue, 30 January 2018 03:45

Mrinal
Messages: 14
Registered: January 2018
Location: Bhubaneswar, India

Member

I am trying to merge the women and the household dataset of NFHS 2. However, after merging the results are not making any sense!! NFHS 2 women dataset has 90,303 observations and household dataset contains 92,486 observations but after merging the merged file shows 104,979 observation, I am trying to understand the result, is it correct or the merging has some issue?? I am also getting an error saying
Quote:

variables v001 v002 do not uniquely identify observations in the master data
variables v001 v002 do not uniquely identify observations in D:\Dropbox\stata\nfhs\IAHR42FL_sort.DTA

Complete result of merging and codes used to merge is given below for reference.

"_merge" result

tab _merge

     _merge |      Freq.     Percent        Cum.
------------+-----------------------------------
          2 |      5,722        5.45        5.45
          3 |     99,257       94.55      100.00
------------+-----------------------------------
      Total |    104,979      100.00

Merging codes

**Merging household on women dataset**
	**Round 2**
	use "D:\Desktop\dhs\data\nfhs\2\IAHR42FL.DTA", clear
	gen int v001 = hv001
	gen int v002 = hv002
	sort v001 v002
	save "D:\Dropbox\stata\nfhs\IAHR42FL_sort.DTA", replace
	
	use "D:\Desktop\dhs\data\nfhs\2\IAIR42FL.DTA", clear
	sort v001 v002 
	merge v001 v002 using "D:\Dropbox\stata\nfhs\IAHR42FL_sort.DTA"
    
	save "D:\Desktop\dhs\data\nfhs\2\IA_HR_IR_42FL.DTA", replace

Thanks
Mrinal

Report message to a moderator

[Message index]

		Issue merging NFHS 2 women and household dataset By: Mrinal on Tue, 30 January 2018 03:45
		Re: Issue merging NFHS 2 women and household dataset By: Bridgette-DHS on Tue, 30 January 2018 08:42
		Re: Issue merging NFHS 2 women and household dataset By: Mrinal on Wed, 31 January 2018 02:38
		Re: Issue merging NFHS 2 women and household dataset By: Bridgette-DHS on Thu, 01 February 2018 07:13
		Re: Issue merging NFHS 2 women and household dataset By: priyoma on Tue, 23 October 2018 17:26
		Re: Issue merging NFHS 2 women and household dataset By: Mrinal on Wed, 24 October 2018 01:07

Previous Topic:	Appending Indonesian DHS 2007 and 2012
Next Topic:	merging variables from HR to BR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 16:45:05 Coordinated Universal Time 2024