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 #16992 is a reply to message #16966]

Thu, 14 March 2019 20:37

Yawo
Messages: 45
Registered: February 2019

Member

Tom and Bridgette: thanks very much for your response. I am still reconsidering my models, and would probably end up focusing on a few years.

I have a few questions re your suggestions: you advised that:

Quote:

1. 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"

Is the goal here to ensure that each case in the women's file has a value of 2, and each case in the men's file has a value of 1? And is the command for women, gen sex==2 or gen sex=2?

Quote:

2. For each survey you need to add a line such as "gen str20 survey_label="Kenya 2003""

I believe the purpose of this command is to generate a string variable labeling each survey ...

Quote:

and it is also helpful to have a numerical variable "survey" which is 1, 2, 3, etc.

And the goal here is to ensure that within each country, we have a variable that indicates whether it is survey 1, survey 2, survey 3.? So, for Kenya, we will have two values, 1 (2003) and 2 (2008). Is that the case?

Thanks very much, .... with much appreciation. Yawo

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 16:59:18 Coordinated Universal Time 2024