The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » Applying correct strata in SAS
Applying correct strata in SAS [message #11771] Tue, 07 February 2017 11:31 Go to previous message
Bouboulina
Messages: 6
Registered: February 2017
Member
Hello,

I am using SAS to compute frequency tables for variables from several surveys. For each, I've appended the male to the female file and merged them with the HIV file. However, I'm not sure which variable(s) to use as strata. I've seen several threads on this topic, but whether to use v022, v023, or a combination of v024 and v025 seems to depend on the sampling design of each survey. I've consulted Annex A of the respective final reports but am still uncertain which variable(s) to use. Could you advise about the following surveys?

Burundi DHS 2010 -> has both v022 and v023 but they appear to be different
Cameroon DHS 2011 -> has v022 but NOT v023
Congo AIS 2009 -> has v022; v023=0 which means that sample is self-weighted at the national level
Democratic Republic of Congo 2013-2014 -> has both and they're identical
Rwanda 2014 -> has both and they're identical

If using a combination of v024 and v025 is best for some or all, how do I do that in SAS (I've seen threads with syntax for STATA but not SAS)? This is my syntax for Burundi (the weight "wgt" was calculated as HIV05/1000000):

proc surveyfreq data=burundifin;
table v012 v025;
weight wgt;
cluster v001;
stratum ???;
run;


Thanks very much!
 
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: Fri Aug 12 11:04:22 Coordinated Universal Time 2022