The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » variables hv001 hv002 hv003 do not uniquely identify observations in the using data
variables hv001 hv002 hv003 do not uniquely identify observations in the using data [message #2563] Sat, 12 July 2014 11:03 Go to next message
nnalo is currently offline  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


Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data [message #2568 is a reply to message #2563] Mon, 14 July 2014 08:10 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1770
Registered: February 2013
Senior Member
Following is a response from DHS Stata Specialist, Tom Pullum:

You are making a common mistake. The line number given by hv003 is not the line number of the household member; it is the line number of the household respondent, i.e. the person who provided the information for the household. It is the same for every record in the household. The line number of the household member is hvidx. This is the field that should match with v003 in the IR file or mv003 in the MR file. In other words, your line "gen hv003= mv003" should be "gen hvidx= mv003". In all other places where you have "hv003", you should replace it with "hvidx".

[Updated on: Mon, 14 July 2014 08:16]

Report message to a moderator

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:
  


Current Time: Fri Apr 3 07:37:01 Eastern Daylight Time 2020