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 #2562]

Sat, 12 July 2014 10:58

nnalo
Messages: 5
Registered: July 2014

Member

Hello,
I am working with Nigeria 2013 DHS.
I am trying to merge male recode with household members recode in STATA.
I followed the procedure below but STATA reported with-- variables hv001 hv002 hv003 do not uniquely identify observations in the using data---

Steps:
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 here.
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 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: Mon Dec 2 17:42:56 Coordinated Universal Time 2024