The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Weights when aggregating survey results (Weights when aggregating survey results)
Weights when aggregating survey results [message #19408] Fri, 12 June 2020 05:19 Go to previous message
oyinkansola is currently offline  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
collapse
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]
When I do this the summary statistics are slightly different than when I do not take the weights into account.

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

 
Read Message
Read Message
Previous Topic: Weight in Indonesia DHS 2002 and 2007
Next Topic: Use of weight on subsetted data
Goto Forum:
  


Current Time: Sun Jul 3 02:05:17 Coordinated Universal Time 2022