The DHS Program User Forum: Merging data files » South Africa (1998): Merging Wealth Index with Individual Recode File in Stata

Home » Data » Merging data files » South Africa (1998): Merging Wealth Index with Individual Recode File in Stata

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

South Africa (1998): Merging Wealth Index with Individual Recode File in Stata [message #882]

Tue, 29 October 2013 10:48

synvox
Messages: 2
Registered: October 2013

Member

I tried to merge Wealth Index file for South Africa (ZAWI31FL.DTA) with the Individual Recode file, but was unable to. I created a new variable in the IR file called whhid, from a substring of the CASEID:

gen whhid = substr(caseid,1,12)

I then tried to merge the IR and WI files:

  merge whhid using "..."

I was told that "the variable whhid does not uniquely identify observations". How can I merge the WI and IR files in Stata?

I understand that the CASEID is 15 character string variable that is the household ID + 3 characters that represent the individual (CASEID = HHID + V003). I do not understand how to merge the two files given that it seems that there are no common/shared id variables.

Please provide Stata specific coding in your reply if possible!

Report message to a moderator

[Message index]

		South Africa (1998): Merging Wealth Index with Individual Recode File in Stata By: synvox on Tue, 29 October 2013 10:48
		Re: South Africa (1998): Merging Wealth Index with Individual Recode File in Stata By: synvox on Tue, 29 October 2013 11:17
		Re: South Africa (1998): Merging Wealth Index with Individual Recode File in Stata By: Bridgette-DHS on Fri, 01 November 2013 14:13

Previous Topic:	Merging Women's & HIV Datasets
Next Topic:	V001 and V002 do not uniquely identify observations in certain files?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 7 15:16:35 Coordinated Universal Time 2024