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 #678 is a reply to message #661]

Mon, 12 August 2013 12:21

Bridgette-DHS
Messages: 3230
Registered: February 2013

Senior Member

Following is an example syntax for merging the wealth index with the women. You can use this, and just change the women's variable names to the men's variable names.

GET
FILE='C:\et\ETWI41FL.SAV'.

SORT CASES BY
whhid (A) .

SAVE OUTFILE='C:\et\wisort.sav'
/RENAME(WHHID=
HHID)
/COMPRESSED.

GET
FILE='C:\et\ETIR41FL.SAV'.

STRING hhid (A12).
COMPUTE hhid = SUBSTR(caseid,1,12) .
VARIABLE LABELS hhid 'hhid' .
EXECUTE .

SORT CASES BY
hhid (A) .

SAVE OUTFILE='C:\et\WOMENSORT.SAV'
/COMPRESSED.

MATCH FILES /FILE=*
/TABLE='C:\et\wisort.sav'
/BY hhid.
EXECUTE.

SAVE OUTFILE='C:\et\WI_IR.SAV'
/COMPRESSED.
COMPUTE wt = v005 / 1000000 .
EXECUTE .
WEIGHT
BY wt .

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: Tue Jul 29 15:36:45 Coordinated Universal Time 2025