The DHS Program User Forum: Merging data files » Merging from multiple countries

Home » Data » Merging data files » Merging from multiple countries

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

Merging from multiple countries [message #16054]

Tue, 30 October 2018 18:47

no7321
Messages: 2
Registered: January 2018
Location: usa

Member

Hi,

I created a pooled dataset with the most recent IR files of 6 South Asian countries (Afghanistan, Bangladesh, India, Maldives, Nepal, Pakistan)

I realized that I also needed a variable from the household files (how households treated their water, i.e. boiled etc.) and so wanted to merge HR data files with the pooled IR data set I created. I first created a pooled HR dataset with all of the same countries and then executed the following code:

/*merge HR to IR*/
use "E:\South Asia\dta\sasiahr.dta"
gen v000=hv000
gen v001=hv001
gen v002=hv002
gen v003=hv003
sort v000 v001 v002 v003
save "E:\South Asia\dta\sasiahr.dta", replace

use "E:\South Asia\dta\sasia.dta"
sort v000 v001 v002 v003
merge m:m v000 v001 v002 v003 using "E:\South Asia\dta\sasiahr.dta"

However, there are still many individual women from the IR dataset that are not matched to household records. The results from the merge show the following:

Result # of obs.
-----------------------------------------
not matched 935,707
from master 521,319 (_merge==1)
from using 414,388 (_merge==2)

matched 259,242 (_merge==3)

I'm wondering why I have 521,319 women from my master file (the IR file) not merged with the HR files? I thought all women interviewed would have a household record I could match them to.

Thanks for the help.

Report message to a moderator

Re: Merging from multiple countries [message #16100 is a reply to message #16054]

Mon, 05 November 2018 07:30

Bridgette-DHS
Messages: 3218
Registered: February 2013

Senior Member

Following is a response from DHS Senior Stata Specialist, Tom Pullum:

In the IR files, line number is v003, but in the HR and PR files the line number is hvidx, NOT hv003. (In those files, hv003 is the line number of the household respondent and is the same for everyone in the same household.) You just need to make that change.

Report message to a moderator

Re: Merging from multiple countries [message #18249 is a reply to message #16054]

Sat, 19 October 2019 09:43

Daniel
Messages: 4
Registered: July 2019

Member

Hi,
I want to pool the most recent IR (individual record) from different countries. I am new for STATA, please can you share me a code how to merge or pool these data.
I would like to thank any help in advance.

Daniel
Thanks

Report message to a moderator

Previous Topic:	MERGING PR and IR data
Next Topic:	Unmatched results after merging HR and IR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jan 6 16:48:18 Coordinated Universal Time 2025