Home » Data » Weighting data » Weighting districtlevel data
Weighting districtlevel data [message #8779] 
Thu, 17 December 2015 04:35 
amira.elshal.1@city.ac.uk
Messages: 52 Registered: April 2013

Senior Member 


Dear Sirs,
I am collapsing Egypt DHS data on the district level in order to estimate the impact of district interventions. I run a FEs, a REs and a diffindiff model. Shall I use weights in this case? And if the answer is yes, how can I weigh data on the district level? At which stage should I weigh data (collapsing data, calculating districtlevel indicators, running the regression, etc.)?
Also, do I need to adjust for the clusters (the primary sampling units) and the strata?
Thank you.
Kind regards,
Amira



Re: Weighting districtlevel data [message #8785 is a reply to message #8779] 
Thu, 17 December 2015 17:32 
ReducedFor(u)m
Messages: 292 Registered: March 2013

Senior Member 


This is (again) a question that has no definite answer, but there are better and worse ones.
First off, since you are using these types of estimators, should I assume that you are using 2 or 3 rounds of the DHS? In that case, you have to be fairly careful when you calculate your districtlevel means (which become the observations in your estimates). There are also some big issues with calculating standard errors (pvalues) which relates to "clustering". Here is how I would do it, and then an alternative:
Weighting: you should calculate the surveyspecific district means using the survey given weights. If you do this separately by survey round, you won't have to worry at all about renoramlizing the weights because you'll be calculating a representative mean of the district level variables (what become your observations). Also note, if you wanted to make the final regression "population representative" you could weight each districtyearlevel observation by the population of the district  so larger districts would get more weight than smaller ones. This may or may not be reasonable, and is up to you and your specific interests/needs.
Clustering: clustering at PSU is not sufficient in this case, at least not usually. The rule of thumb here would be to cluster at the "district" level  the level at which you collapse observations/assign "policy intervention". The usual reference is Bertrand, Duflo and Mullainathan "How Much Should we Trust DifferenceinDifference Estimates". To do this in Stata, when you define PSU in your "svyset" command, you use the district identifier (that is common across survey rounds). You can include the strata here too, but I don't think it will make much of a difference (and if it does, it should make your pvalues slightly smaller).
Note: If you have fewer than 30 or 40 districts, you should also see Cameron, Gelbach and Miller "Bootstrap Based Improvements for Inference with Few Clusters"  there is a new Stata package that makes doing those "wildt bootstraps" very easy: see "cgmreg" group of .ado files you can download.
Now  there are also a couple more ways to do this. In particular, you could do this same analysis on individuallevel data with grouplevel covariates. Everything is the same, but now instead of weighting when you collapse, you'd have to weight in the regression. In this case, you could either follow Gary Solon in "What are We Weighting For" and argue that, with causal effects, you don't need to weight, or you can follow standard DHS recommendation and renormalize your survey weights and then apply those in the regression analysis.
Hope some of this helps. I can follow up with details on one of these methods if you decide you like one and still aren't sure what to do.




Re: Weighting districtlevel data [message #8789 is a reply to message #8788] 
Fri, 18 December 2015 12:47 
ReducedFor(u)m
Messages: 292 Registered: March 2013

Senior Member 


1) It should be very easy to recalculate the districtbysurveyround means again, this time using the weights:
collapse Y [pweight=weight], by(district)
2) You can not do the probability weighting after you collapse  you can only adjust for population differences across districts after you collapse.
3) the clustering is easy and you don't have to do anything until you run the regressions: reg Y X, cluster(district)
4) if you have 200 "districts" does that mean that PSU is your "district"? If so, now you have an entirely new problem  namely, that "districts" are probably changing from round to round. How are you matching your "districts" from survey to survey, and what (administratively or in DHSterms) is the "district" you are using?
So to sum up: you have to weight when you collapse (construct districtlevel means), you cluster in the regression, and I am not sure that you really have the information you think you do if you are using such small administrative regions (because usually these change from survey round to round, but maybe Egypt is different).




Re: Weighting districtlevel data [message #8793 is a reply to message #8791] 
Fri, 18 December 2015 15:37 
ReducedFor(u)m
Messages: 292 Registered: March 2013

Senior Member 


Interesting. Quick replies:
1  cool. My guess is that since it is usually 1 PSU going to 1 district, and all observations in some PSU have the same weight, that it is basically the numerator/denominator canceling each other out. But while we are on that  since it is a fraction, and since that fraction is an estimate of the population proportion, fewer observations means a less good estimate of the actual proportion. Clustering might not work here at all since you would lose the uncertainty generated in your first stage  you might have to bootstrap both stages. I'll leave that to you to decide how far you want to go down that rabbithole, but you may want to account for the uncertainty in your "observations" because those are estimates themselves.
2  it is nice to help (smiley face)
3  diff district_indicator, t (treated) p (t), cluster(District) ... I think the problem is the extra "," after p(t). Delete that, and I think it will run.
4 I see what you are doing. That is interesting, and I could see how it would work. But you should also know that you are not necessarily comparing "apples to apples" anymore. Suppose PSU 1 is in District 1 in round 1. Then, in Round 2, District 1 contains PSU 397 (which wasn't sampled in round 1). Then you are using different people from different towns/areas to define the same "district" variable. How many PSUs per district do you have, on average? I ask because with many, I'd think a law of large numbers might apply and you'd be fine. But with only 1 or 2 PSUs per round, much of the difference across time within district is going to be do to sampling variation and not do to real changes. Again, in theory, with many N(obs), G(groups) and T(periods) you are OK, but in finite numbers you are asking a whole lot of the data.





Re: Weighting districtlevel data [message #8814 is a reply to message #8798] 
Mon, 21 December 2015 16:08 
ReducedFor(u)m
Messages: 292 Registered: March 2013

Senior Member 


Re bootstrap: I think to account for the imprecision in the "firststage"  meaning the calculation of the percentage of women using modern methods  you'd have to bootstrap BOTH stages. That is, draw a bootstrap sample of observations within each district, estimate the proportions, run the secondstage regression on those aggregate values, and then repeat that whole process. But that is just a suggestion  you'd have to check how people in your field do that (there are probably other ways, say via multilevel modeling, to make the same kind of corrections.
As for why the FE and DnD are so similar  if you have just 2 rounds, the FE and DnD should be doing pretty much the exact same thing (though perhaps with the algorithm you are using, come to slightly different numerical results). Or, if you mean that by "clustering" your estimates change very little  in effect (using the same regression model for point estimates) it should not change the point estimates at all, only the pvalues/standard errors.




Re: Weighting districtlevel data [message #8821 is a reply to message #8814] 
Thu, 24 December 2015 04:00 
amira.elshal.1@city.ac.uk
Messages: 52 Registered: April 2013

Senior Member 


Dear Sir,
This is a kind reminder of my message below. I apologize for disturbing you again and I would appreciate your tolerance as I have a couple of more questions:
1 Do I still have to weigh the data? If I decide to follow Gary Solon in "What are We Weighting For" and argue that, with causal effects, I don't need to weight given that I carry out my analysis on districtlevel with districtlevel covariates (population size is one of the covariates I include), shall I cluster afterwards in the second stage (regression)? You have mentioned that "Clustering might not work here at all since you would lose the uncertainty generated in your first stage".
2 If I decide to weigh my data, how can I do so given that the numerator and the denominator cancel each other out in the first stage of calculating the percent of women in a district using modern methods?
3 Shall I use clustering in the second stage (regression) if I weighed my data in the first stage? Is clustering (in the second stage) related to my decision to weigh/NOT weigh data (in the first stage)?
4 If I have to cluster, shall I directly use reg Y X, cluster(district)? Or shall I first define PSU in the "svyset" command? I have not used the "svyset" command before.
5 I do not think I would be able to bootstrap the first stage by myself. Also, I think this will consume a lot of time. Do you think this is a necessary step in my case? To what extent will NOT bootstrapping affect the results given that I bootstrap standard errors in the second stage (regression)?
Once again, I would like to thank you for your guidance.
Kind regards,
Amira



Re: Weighting districtlevel data [message #8830 is a reply to message #8821] 
Mon, 28 December 2015 17:53 
ReducedFor(u)m
Messages: 292 Registered: March 2013

Senior Member 


Hi  sorry for the holidayrelated delay. Some responses:
1. I think technically you would have to bootstrap the whole procedure (first and second stages) but, given that that is a little bit overboard, you should definitely cluster in the second stage.
2. I haven't math'd it out, but I think that if the weights cancel, you can just ignore them. If it doesn't make a difference, it doesn't make a difference.
3. You cluster regardless of your weighting choice  weighting is about getting a representative sample, clustering is about getting consistent standard error/pvalue estimates.
4. You don't have to use "svyset", it is just one way to deal with it. You can just "reg Y X, cluster(district)"  or you can add your weights manually too (I also don't usually use svyset  only when trying to replicate DHS methods).
5. Your pvalues will probably be a little too small if you don't bootstrap both stages, but it is probably not a huge deal. People ignore that all the time. You are just pretending that there is no measurement error in your observations (that is  pretending that your district means are actual observations and not estimates of district means). I mean  it is basically up to your field to decide what they will/won't accept, and I think 99% of smart researchers would not even consider this an issue  just me and some other sticklers.
Good luck  I think don't sweat it too much. But FYI  the bootstrap wouldn't be so hard really. You just place what you already do in a loop, use the "bsample" command (if Stata) at the beginning of the loop, and save the point estimate from each repetition. The standard deviation of your point estimates is then used as the standard error of your estimate (I mean, it is an estimate of your standard error, but that is all anyone ever has).



Goto Forum:
Current Time: Thu Jun 8 02:03:55 Coordinated Universal Time 2023
