Pooled datasets - weighting data problem [message #2028] |
Wed, 16 April 2014 08:10 ![Go to next message Go to previous message](/theme/default/images/down.png) |
lukassg
Messages: 12 Registered: January 2014
|
Member |
|
|
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!
Lukas
|
|
|