The DHS Program User Forum: Merging data files

Home » Data » Merging data files » Merging DHS data in Stata

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

Re: Merging DHS data in Stata [message #275 is a reply to message #252]

Tue, 09 April 2013 12:07

Bridgette-DHS
Messages: 3043
Registered: February 2013

Senior Member

Below is an example syntax for merging the HIV Test data with the Women's data in SPSS. You can modify this for other datasets.

GET FILE='C:\DATAUSER\ZMAR51FL.SAV'.
SORT CASES BY
HIVCLUST (A) HIVNUMB (A) HIVLINE (A).
SAVE OUTFILE='C:\DATAUSER\HIV.sav'
/COMPRESSED.

GET FILE='C:\DATAUSER\ZMIR51FL.SAV'.
SORT CASES BY
V001 (A) V002 (A) V003 (A) .
SAVE OUTFILE='C:\DATAUSER\WOMEN.sav'
/RENAME(V001 V002 V003=
HIVCLUST HIVNUMB HIVLINE)
/COMPRESSED.

GET FILE='C:\DATAUSER\WOMEN.sav'.
MATCH FILES /FILE=*
/TABLE='C:\DATAUSER\HIV.sav'
/BY HIVCLUST HIVNUMB HIVLINE.
EXECUTE.
SAVE OUTFILE='C:\DATAUSER\ZMAR_IR.SAV'
/COMPRESSED.

Report message to a moderator

[Message index]

		Merging DHS data in Stata By: DHS user on Wed, 20 February 2013 11:45
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 20 February 2013 11:46
		Re: Merging DHS data in Stata By: kf2349 on Tue, 26 March 2013 16:20
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 28 March 2013 09:25
		Re: Merging DHS data in Stata By: jack.murphy on Tue, 15 November 2016 11:26
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 16 November 2016 09:32
		Re: Merging DHS data in Stata By: jack.murphy on Thu, 17 November 2016 16:53
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 18 November 2016 10:31
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 11:28
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 11:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 18 November 2016 14:36
		Re: Merging DHS data in Stata By: jack.murphy on Fri, 18 November 2016 14:37
		Re: Merging DHS data in Stata By: Hassen on Sun, 06 May 2018 05:58
		Re: Merging DHS data in Stata By: caragh on Tue, 02 April 2013 18:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Tue, 09 April 2013 12:07
		Re: Merging DHS data in Stata By: owraza on Sat, 28 June 2014 20:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Mon, 30 June 2014 13:20
		Re: Merging DHS data in Stata By: owraza on Wed, 02 July 2014 07:24
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 02 July 2014 10:21
		Re: Merging DHS data in Stata By: kinsukmanisinha@gmail.com on Wed, 14 October 2015 09:38
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 21 October 2015 13:55
		Re: Merging DHS data in Stata By: mianrashid on Tue, 10 May 2016 10:01
		Re: Merging DHS data in Stata By: owraza on Tue, 10 May 2016 15:24
		Re: Merging DHS data in Stata By: mianrashid on Tue, 10 May 2016 17:04
		Re: Merging DHS data in Stata By: owraza on Tue, 10 May 2016 20:33
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 12 May 2016 09:08
		Re: Merging DHS data in Stata By: mianrashid on Tue, 17 May 2016 13:01
		Re: Merging DHS data in Stata By: Bridgette-DHS on Thu, 19 May 2016 10:14
		Re: Merging DHS data in Stata By: phres110 on Wed, 02 November 2016 13:29
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 11 November 2016 10:27
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 16 May 2015 07:39
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 16 May 2015 07:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Tue, 19 May 2015 11:14
		Re: Merging DHS data in SPSS By: Malachi Arunda on Sun, 24 May 2015 08:29
		Re: Merging DHS data in Stata By: Malachi Arunda on Sat, 30 May 2015 13:46
		Re: Merging DHS data in Stata By: Bridgette-DHS on Mon, 01 June 2015 13:00
		Re: Merging DHS data in Stata By: Malachi Arunda on Tue, 09 June 2015 23:21
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 10 June 2015 10:41
		Re: Merging DHS data in Stata By: Malachi Arunda on Tue, 04 August 2015 17:55
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 05 August 2015 10:04
		Re: Merging DHS data in Stata By: Malachi Arunda on Wed, 05 August 2015 13:22
		Re: Merging DHS data in Stata By: Malachi Arunda on Sun, 30 August 2015 06:21
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Sun, 30 August 2015 14:36
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Sun, 30 August 2015 14:37
		Re: Merging DHS data in Stata By: Malachi Arunda on Mon, 31 August 2015 12:27
		Re: Merging DHS data in Stata By: Reduced-For(u)m on Mon, 31 August 2015 15:10
		Re: Merging DHS data in Stata By: Malachi Arunda on Mon, 31 August 2015 15:43
		Re: Merging DHS data in Stata By: PublicHealthMaster on Fri, 11 September 2015 08:45
		Re: Merging DHS data in Stata By: Bridgette-DHS on Wed, 30 September 2015 07:31
		Re: Merging DHS data in Stata By: pie on Tue, 02 June 2020 06:21
		Re: Merging DHS data in Stata By: Bridgette-DHS on Fri, 05 June 2020 15:32

Previous Topic:	How to match women to their husbands
Next Topic:	Merging HR and PR Files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 06:55:29 Coordinated Universal Time 2024