The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Denormalizing data
Denormalizing data [message #9556] Fri, 15 April 2016 11:57 Go to previous message
cbdolan is currently offline  cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
I am using the 2007 and 2013/14 DRC BR and GE files. I have listened to both the YouTube videos Yw10NjynAn2Z as well as the webinar "Analyzing DHS data: Weights and other adjustments for the survey design". I have several follow up questions:

1. How does the use of the subpop command (ie. svy, subpop (rural) logistic....) impact the process for weighting my data? I want to run my specification on a sub-sample of only rural locations. However, when making the stratification adjustment I grouped on (v024 and v025).

2. Since I am combining surveys for a single country, spanning multiple years and then making comparisons across years I think I need to denormalize the data. I have used the attached document provided by Dr.Ren as a guide. Is the following process correct for the BR file? Also, can you please verify that the process of denormalization I've outlined is correct.

V005*=V005×(total births in the country at the time of the survey)/(total number of births in the survey)


*generate weight
V005*=V005×(total births in the country at the time of the survey)/(total number of births in the survey)
gen wgt=v005*/1000000
*make unique strata values by region/urban-rural )
egen stratum=group(ADM1_CODE v025)
*tell stata the weight (using pweights for robust standard errors, cluster (psu), and strata 
svyset [pw=wgt],psu(v021)strata(stratum)
*prefix regrss with "svy:stata will now know how to weight your data and compute the right standard errors 

3. After applying the above process the standard errors are larger. Is this because the clusters are independent, but the households within the same clusters are not independent. Accounting for v021 increases the standard errors.

Read Message
Read Message
Previous Topic: Do I need to weight data for cohort analysis?
Next Topic: Sampling weights, cluster, strata in AIDS recode (AR)
Goto Forum:

Current Time: Fri Sep 29 20:40:24 Coordinated Universal Time 2023