| Weights when aggregating survey results [message #19408] |
Fri, 12 June 2020 05:19  |
oyinkansola
Messages: 1
Registered: June 2020
|
Member |
|
|
Hi, I am using the Nigerian DHS for the years 1990, 2003, 2008, 2010 and 2013 for my analysis. I make use of the household recode and the children's recode data sets. I am analyzing the living conditions in Nigerian cities, and the cities data comes from another data set. Since the geographical location for the DHS clusters are provided, I was able to aggregate the surveys for each year to the city level. This means that my data set for analysis is in the form of panel data with my units of observation as city, and I have an unbalanced panel.
I aggregate the surveys to city level by using the Stata command I am allowed to take the weights into account with the collapse command, which I do following the DHS recommendation to use [iweights = weight/1000000]
It is important to my analysis that I make use of fixed effects estimation model, which specifies that the weights must be the same within a panel. This means that each city must carry the same weight for all years.
My questions:
1. How can I re-weight the data in this scenario? There are 2 different weights for each unit of observation- the weight from the household and the weight for the child recode.
2. Would my results be valid to all cities in Nigeria if I do not use weights in my regressions?
3. If I am not able to re-weight my data for my regression analysis, is it sensible to report the summary statistics when it is weighted or without weights?
Thank you for your anticipated response.
[Updated on: Fri, 12 June 2020 05:26] Report message to a moderator |
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
