The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Re-Numbering Survey_Year and Survey_Rounds (Creating Unique survey_year and survey_round variables)
Re-Numbering Survey_Year and Survey_Rounds [message #17629] Tue, 30 April 2019 10:44 Go to previous message
Yawo is currently offline  Yawo
Messages: 45
Registered: February 2019
Member
Hello,

I have pooled data from about 10 countries, and ready to generate new strata/cluster variables. Consistent with advice from this board, I created a new variable, "survey_year" which takes the value of 1, 2, 3, 4 (to represent each of the survey rounds within a country.

Here are the two commands I intend to use:

egen cluster=group(survey_year v001)
egen stratum=group(survey_year v024 v0025)

But I am not sure if the survey_year variable is uniquely representing the survey rounds. For example, I have the following rounds of surveys, and their corresponding "survey_year" values:

Congo2007: survey_year=1
Congo2013: survey_year=2

Gabon2012: survey_year=1

Ghana2003: survey_year=1
Ghana2014: survey_year=2

So, survey_year=1 can refer to different years. Does this matter, for generating new strata and cluster variables?

What if I create two variables: "survey_round" (with values: 1, 2, 3, 4) - to capture the different rounds of survey, and a second variable: "survey_year" (to consecutively number the survey years: 2003, 2004, 2005, 2006, .......2017).

The two new strata variables could be:

egen cluster=group(survey_year survey_round v001)
egen stratum=group(survey_year survey_round v024 v0025)

Would these new approach be ok?

Thanks - Yy
 
Read Message
Read Message
Read Message
Previous Topic: Weighting Namibia 2013 Data (PR)
Next Topic: using sample weight
Goto Forum:
  


Current Time: Fri Mar 29 02:17:56 Coordinated Universal Time 2024