The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » Applying correct strata in SAS
Re: Applying correct strata in SAS [message #11787 is a reply to message #11771] Thu, 09 February 2017 08:46 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3040
Registered: February 2013
Senior Member
Following is a response from DHS Senior Sampling Specialist, Mahmoud Elkasabi:

Quote:
I recommend you to always consult the sampling design in Appendix A or B. although both v022, v023 should be consistent with the sampling design, in some cases they are not. In these scenario, you better construct the stratification variable guided by the sampling design in the Appendix. Below are my answers for each of your questions.

Burundi DHS 2010 -> has both v022 and v023 but they appear to be different
V022 is the one you should use. It is consistent with the sampling stratification as appears in Table A.3 in Appendix A in the survey report. Since V024 was reserved for the country regions, not provinces, the cross-classification of V024 and V025 is not a valid stratification variable for this survey.

Cameroon DHS 2011 -> has v022 but NOT v023
Either V022 or the cross-classification of V024 and V025 can be used.

Congo AIS 2009 -> has v022; v023=0 which means that sample is self-weighted at the national level
V022 is not correctly coded. You can use the cross-classification of V024 and SHURBRUR as indicated in Appendix A in the survey report. SHURBRUR is the three-category residence variable that was used for stratification.

Democratic Republic of Congo 2013-2014 -> has both and they're identical
Either V022 or V023 can be used. It is consistent with the sampling stratification as appears in Table B.3 in Appendix B in the survey report. Since V024 was reserved for the country "old" provinces, the cross-classification of V024 and V05 is not a valid stratification variable for this survey. However, the cross-classification of SNPROVIN (the new provinces) and V026 can be used for stratification.

Rwanda 2014 -> has both and they're identical
Either V022 or V023 can be used. Since V024 was reserved for the country 5 provinces, the cross-classification of V024 and V05 is not a valid stratification variable for this survey. However, the cross-classification of SDISTRICT (the country districts) and V025 can be used for stratification.

Regarding the SAS code, in case if you are using two variables cross classifications, you can write the stratification statement as below, however note that none of the stratification variables can appear in the "table" statement

proc surveyfreq data=burundifin;
table v012;
weight wgt;
cluster v001;
strata v024 v025;
run;
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Opening databases in RStudio
Next Topic: Importing DHS to R studio
Goto Forum:
  


Current Time: Thu Apr 25 16:01:51 Coordinated Universal Time 2024