The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Pooled datasets - weighting data problem
Pooled datasets - weighting data problem [message #2028] Wed, 16 April 2014 08:10 Go to previous message
lukassg is currently offline  lukassg
Messages: 12
Registered: January 2014
Hey all,

I have already extensively searched the forum but couldn't find a definite answer that's why I would like to raise my question:

I am pooling DHS survey, always two rounds per country, but all countries still separate. However since I pool two years together, I still need to de-normalize m weights before I do the actual pooling as far as I understood from various sources.

I am using birth recode files and thus I should proceed like this:

V005*=V005×(total females age 15-49 in the country at the time of the survey)/(number of women age 15-49
interviewed in the survey)

Now I read the one-pager by Ruilin Ren but I still don't know where to find "total number of females age 15-49 in the whole country at the time of the survey".
I guess the only way is to go and check all the censuses that have been used for my DHS surveys at hand and look for that specific number there? Is there a database at DHS maybe where all that information is stored already?

Subsequently I have a question for the procedure. I open both datafiles, let's say Ethopia 2000 and Ethopia 2011. For both datasets I de-normalize the weight according to the formula above (before that I divide v005 by 1,000,000 of course). Then I assume I can pool the two datasets by appending one to the other.
But now that I have them pooled and want to specify my svyset, do I just use the weight variable as it is, e.g. "svyset psu [pweight=v005], strata(strat_id)" ?
Or do I have to make any other adjustments?

Thanks a lot for your help, this forum is really helpful always!

Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Continuous Survey Weights
Next Topic: Normalizing weight for region/province
Goto Forum:

Current Time: Sat Jul 20 13:00:41 Coordinated Universal Time 2024