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

Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data [message #2569 is a reply to message #2562]

Mon, 14 July 2014 08:25

Bridgette-DHS
Messages: 3230
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".

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 10:58
		Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data By: Bridgette-DHS on Mon, 14 July 2014 08:25
		Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data By: nnalo on Tue, 15 July 2014 18:49
		Re: variables hv001 hv002 hv003 do not uniquely identify observations in the using data By: Bridgette-DHS on Wed, 16 July 2014 10:25

Previous Topic:	variables hv001 hv002 hv003 do not uniquely identify observations in the using data
Next Topic:	Merging SPA and DHS data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Jul 24 17:48:40 Coordinated Universal Time 2025