The DHS Program User Forum: General Data Questions » Merge wealth index 1999 TZ DHS

Home » Data » General Data Questions » Merge wealth index 1999 TZ DHS

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

Merge wealth index 1999 TZ DHS [message #14119]

Tue, 20 February 2018 12:42

kpat
Messages: 2
Registered: January 2018

Member

I am trying to merge Wealth Index (WI) files with the 1999 DHS IR file. The code works, but only matches 533 of over 12,000 observations.

Starting with the IR file, I used the following code (which worked for four other countries in the analysis):
gen whhid = substr(caseid,1,12)
merge m:1 whhid using "TZWI3AFL.DTA"

Please advise.

[Updated on: Tue, 20 February 2018 12:43]

Report message to a moderator

[Message index]

		Merge wealth index 1999 TZ DHS By: kpat on Tue, 20 February 2018 12:42
		Re: Merge wealth index 1999 TZ DHS By: Bridgette-DHS on Tue, 20 February 2018 14:47

Previous Topic:	Grouping neighboring clusters / PSUs
Next Topic:	Missing observations for h37i and h37j in Survey datasets for Myanmar, India, and Bangladesh

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Oct 30 22:17:47 Coordinated Universal Time 2025