The DHS Program User Forum: Merging data files » V001 and V002 do not uniquely identify observations in certain files?

Home » Data » Merging data files » V001 and V002 do not uniquely identify observations in certain files?

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

V001 and V002 do not uniquely identify observations in certain files? [message #931]

Mon, 18 November 2013 21:27

cp284
Messages: 3
Registered: November 2013

Member

Hi everyone,

I'm trying to merge individual and household files for a number of countries. Per the DHS documentation on merging, I've renamed the variables HV001 and HV002 to V001 and V002 in the household files, and then merge on these two variables. This has worked for almost all of my files of interest. But for 12 household files, V001 and V002 do not uniquely identify observations. This prevents me from carrying out the m:1 merge in Stata that I have done for my other files.

V001 and V002 do not uniquely identify observations in the following files:

BOHR31FL
CMHR31FL
TFHR31FL
NIHR31FL
TGHR31FL
MLHR41FL
BJHR41FL
BOHR41FL
ETHR41FL
SNHR44FL
IAHR42FL
HNHR52FL

Has anyone else come across this problem before? How have you navigated it?

Thank you!

Report message to a moderator

[Message index]

		V001 and V002 do not uniquely identify observations in certain files? By: cp284 on Mon, 18 November 2013 21:27
		Re: V001 and V002 do not uniquely identify observations in certain files? By: Bridgette-DHS on Mon, 02 December 2013 09:30

Previous Topic:	South Africa (1998): Merging Wealth Index with Individual Recode File in Stata
Next Topic:	Merging HIV with Individual file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Feb 26 05:46:21 Coordinated Universal Time 2025