The DHS Program User Forum: Merging data files » Merging Women-Men-HIV Data: Different Countries, Different Years

Home » Data » Merging data files » Merging Women-Men-HIV Data: Different Countries, Different Years

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

Re: Merging Women-Men-HIV Data: Different Countries, Different Years [message #16966 is a reply to message #16859]

Thu, 14 March 2019 14:35

Bridgette-DHS
Messages: 3214
Registered: February 2013

Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:

You have to be very cautious about interpreting the results from this kind of pooling. It's likely that the stigma has been declining over time and it less in countries with higher prevalence. The surveys have a wide range in dates. Is it appropriate to include more than one survey from a country? We have had a few relevant reports; here are links to two of them: https://www.dhsprogram.com/pubs/pdf/AS35/AS35.pdf and https://www.dhsprogram.com/pubs/pdf/AS40/AS40.pdf.

Appending the IR and MR files and merging with the AR file, and then appending the merged files from all the surveys is the correct approach, and your Stata code looks good. When you prepare the women's file you need a line "gen sex=2", and when you prepare the men's file you need "gen sex==1" and "rename mv* v*". For each survey you need to add a line such as "gen str20 survey_label="Kenya 2003"" and it is also helpful to have a numerical variable "survey" which is 1, 2, 3, etc. When we do this sort of thing at DHS we loop through the files using sub-programs and local notation. I hesitate to describe that process in detail.

You can alter the weights, clusters, and strata afterwards, in the final merged and appended file. There are many forum postings on the options and strategies for doing this.

Report message to a moderator

[Message index]

		Merging Women-Men-HIV Data: Different Countries, Different Years By: Yawo on Sun, 10 March 2019 17:24
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Bridgette-DHS on Thu, 14 March 2019 14:35
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Yawo on Thu, 14 March 2019 20:37
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Bridgette-DHS on Fri, 15 March 2019 08:26
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Yawo on Sat, 16 March 2019 14:09
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Yawo on Mon, 18 March 2019 10:08
		Re: Merging Women-Men-HIV Data: Different Countries, Different Years By: Bridgette-DHS on Fri, 29 March 2019 08:50

Previous Topic:	Merging KR with PR for Ethiopia 2011
Next Topic:	Merging different countries - representativeness?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Dec 18 17:00:18 Coordinated Universal Time 2024