The DHS Program User Forum: Reproductive Health

Home » Topics » Reproductive Health » Merging (Pooling Colombian MR and IR datasets)

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

Re: Merging [message #27738 is a reply to message #27737]

Wed, 27 September 2023 13:20

Janet-DHS
Messages: 938
Registered: April 2022

Senior Member

Following is a response from DHS staff member, Tom Pullum:

A single file that includes both the women and men would be constructed with the "append" command. The following Stata lines should do this:

* Define a workspace
cd e:\DHS\DHS_data\scratch

use ...COMR71FL.dta, clear
gen sex=1
label define sex 1 "Male" 2 "Female"
label values sex sex

* Rename variables in the MR file to match the names on the IR file
* As a minimum, this will include the mv variables but there may be others
rename mv* v*
save COMR71temp.dta, replace

use ...COIR72FL.dta, clear
gen sex=2
append using COMR71temp.dta

save COIRMR.dta, replace

If you want a merged file, in which a woman and man in the same household are combined as a couple, you should just use the CR ("couples") file. You do not actually need to do that merge--it has already been done for you.

Report message to a moderator

[Message index]

		Merging By: Deidi on Tue, 26 September 2023 15:41
		Re: Merging By: Janet-DHS on Wed, 27 September 2023 09:32
		Re: Merging By: Deidi on Wed, 27 September 2023 09:37
		Re: Merging By: Janet-DHS on Wed, 27 September 2023 13:20
		Re: Merging By: Deidi on Wed, 27 September 2023 13:22

Previous Topic:	Treating datasets with an LBW infant
Next Topic:	Kenya 2022 calendar data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Jun 23 19:51:33 Coordinated Universal Time 2025