| Denormalizing data [message #9556] |
Fri, 15 April 2016 11:57  |
cbdolan
Messages: 17
Registered: March 2013
Location: Williamsburg, VA
|
Member |
|
|
I am using the 2007 and 2013/14 DRC BR and GE files. I have listened to both the YouTube videos https://www.youtube.com/playlist?list=PLagqLv-gqpTN8IZQBy7vA 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)
PROCESS FOR DENORMALIZING THEN APPLYING WEIGHTS, CLUSTER AND STRATIFICATION ADJUSTMENT
*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.
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
