The DHS Program User Forum: Merging data files » Couples and HIV merge in STATA

Home » Data » Merging data files » Couples and HIV merge in STATA

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

Re: Couples and HIV merge in STATA [message #3284 is a reply to message #3271]

Mon, 17 November 2014 18:22

Trevor-DHS
Messages: 805
Registered: January 2013

Senior Member

You have to do this twice. Once for women and then once for men. Here is how to merge the AR file with the CR file for women first:

* Step 1: open AR file
use "xxAR61FL.DTA", clear

* Step 2: rename identifying variables
renvars hivclust hivnumb hivline / v001 v002 v003

* Step 3: sort by identifying variables
sort v001 v002 v003

* Step 4: save results
save "xxAR61FL_mergeprep.DTA", replace

* Step 5: open IR file
use "xxCR61FL.DTA", clear

* Step 6: sort by identifying variables
sort v001 v002 v003

* Step 7: merge!
merge v001 v002 v003 using "xxAR61FL_mergeprep.DTA"

* Step 8: Keep only women
drop if _merge==2

Then rename the added hiv variables to something unique for women, e.g.

rename hiv* w_hiv*

and repeat steps 1-8 above using mv003 instead of v003 throughout to merge the men's hiv test result and then finally rename the hiv variables to be for men, e.g.

rename hiv* m_hiv*

Report message to a moderator

[Message index]

		Couples and HIV merge in STATA By: DaniD on Sat, 15 November 2014 19:47
		Re: Couples and HIV merge in STATA By: Trevor-DHS on Mon, 17 November 2014 18:22
		Re: Couples and HIV merge in STATA By: DaniD on Tue, 18 November 2014 15:39
		Re: Couples and HIV merge in STATA By: Trevor-DHS on Tue, 18 November 2014 17:20
		Re: Couples and HIV merge in STATA By: lberes on Mon, 11 April 2016 01:01

Previous Topic:	Mother's and Father's occupation
Next Topic:	Merging Birth and Household Recodes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 21:55:20 Coordinated Universal Time 2024