The DHS Program User Forum: Dataset use in Stata » merging wealth index from Ethiopia DHS 2000 to women's file

Home » Data » Dataset use in Stata » merging wealth index from Ethiopia DHS 2000 to women's file

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

Re: merging wealth index from Ethiopia DHS 2000 to women's file [message #4169 is a reply to message #4080]

Sat, 11 April 2015 17:43

Trevor-DHS
Messages: 808
Registered: January 2013

Senior Member

Try the following:

* Open wealth index data file.
get file="ETWI41FL.SAV".
* Sort cases by ID.
sort cases by WHHID.
* Save the  sorted wealth index data file.
save outfile="ETWI41FL.SAV".

* Open women's recode file.
get file="ETIR41FL.SAV".
* Create matching ID variable.
string WHHID (A12).
compute WHHID = substr(CASEID, 1, 12).

* Sort cases by ID.
sort cases by CASEID.

* Match files wealth index data to individual recode data.
match files /file=*
  /table="ETWI41FL.SAV"
  /by WHHID.
execute.

Report message to a moderator

[Message index]

		merging wealth index from Ethiopia DHS 2000 to women's file By: alex on Wed, 20 March 2013 00:22
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Fri, 22 March 2013 13:47
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: alex on Mon, 25 March 2013 07:39
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Mon, 25 March 2013 08:29
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: acp49 on Tue, 17 October 2017 15:58
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Wed, 18 October 2017 08:34
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Hassen on Sat, 05 May 2018 07:11
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: cdt_8289 on Mon, 29 July 2013 14:57
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Bridgette-DHS on Mon, 12 August 2013 12:21
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Markos Mezmur on Thu, 26 March 2015 05:22
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Trevor-DHS on Sat, 11 April 2015 17:43
		Re: merging wealth index from Ethiopia DHS 2000 to women's file By: Trevor-DHS on Tue, 17 October 2017 18:16

Previous Topic:	Hypertension in Nepal
Next Topic:	Keeping caseid in and keeping missing observations out when using Stata "collapse"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 7 05:01:48 Coordinated Universal Time 2025