The DHS Program User Forum: Merging data files » variables hv001 hv002 hv003 do not uniquely identify observations in the using data

Home » Data » Merging data files » variables hv001 hv002 hv003 do not uniquely identify observations in the using data

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

variables hv001 hv002 hv003 do not uniquely identify observations in the using data [message #2563]

Sat, 12 July 2014 11:03

nnalo
Messages: 5
Registered: July 2014

Member

Hello,
*urgent
I am working with Nigeria 2013 DHS.
I am trying to merge male recode with household member recode in STATA. But STATA reports is as---
variables hv001 hv002 hv003 do not uniquely identify observations in the using data---
This is the procedure I followed:

1. open the household member file and sort hv001 hv002 hv003 and then save this file

2. open male file and do:

gen hv001 = mv001

gen hv002 = mv002

gen hv003= mv003

sort hv001 hv002 hv003

merge 1:1 hv001 hv002 hv003 using "THE NAME OF THE FILE WITH SORTED HOUSEHOLD MEMBER DATA"

keep if _merge==3

save "NEW NAME"

Please help me out.
Thank you

Report message to a moderator

[Message index]

		variables hv001 hv002 hv003 do not uniquely identify observations in the using data By: nnalo on Sat, 12 July 2014 11:03
		Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data By: Bridgette-DHS on Mon, 14 July 2014 08:10

Previous Topic:	Male Recode and HH Member Recode
Next Topic:	variables hv001 hv002 hv003 do not uniquely identify observations in the using data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Dec 2 17:45:22 Coordinated Universal Time 2024