Support #703
closed
Longitudinal weights for periods of years
Added by Agnes Norris Keiller almost 8 years ago.
Updated over 7 years ago.
Description
Hi,
I'm working on a project that examines changes in individual incomes over different periods of years.
I'm aware you produced a note titled "Pooling data from different waves of Understanding Society for cross-sectional analysis", which describes how to construct yearly cross-sectional weights from pooled waves. How would you recommend constructing longitudinal yearly weights that would be appropriate for analysing samples defined as "all individuals observed in year X and year Y" (where X and Y are not necessarily consecutive)?
Thanks
Files
- Status changed from New to In Progress
- Assignee changed from Olena Kaminska to Agnes Norris Keiller
- % Done changed from 0 to 10
- Private changed from Yes to No
Dear Agnes,
Many thanks for your enquiry. I have passed it on to our weighting team who will look into it and respond.
Best wishes, Victoria.
On behalf of the Understanding Society User Support Team.
Hi.
I think the best way to do this would be to start with the year X weight, derived as in our note on pooling, and then make an adjustment to this, to account for attrition by year Y. This would involve fitting a model (e.g. logit) based on all year X cases in your sample, in which the dep var is a 0/1 indicator of whether they also responded at year Y (and removing from the base any known to have died or emigrated before Y). Predictor variables can be anything relevant observed at X. This will give you a predicted probability for every year X respondent of responding at year Y. Call this P. You then need to adjust the year X weight by multiplying it by 1/P for all the cases that can be included in your analysis (those who responded in both years).
In the above, "year" refers to sample year rather than calendar year of interview. e.g. 2010 would mean the wave 2 interview for the year 1 sample and the wave 1 interview for the year 2 sample (regardless of whether those interviews actually took place in 2010: some will be in the early weeks of 2011).
Hope that makes sense.
Peter
Dear Peter,
Thanks for your advice and apologies for not getting back to you sooner. What you suggest is very helpful and answers my query. To improve consistency between the wave- and year-longitudinal weights I was wondering whether the predictor variables that are used to construct the standard longitudinal weights are documented anywhere.
Thanks again,
Agnes
Sadly not. But I could copy and paste a list of variables from our syntax files if you let me know which longitudinal weights you are (most) interested in. Is it w_indinub_lw, w_indpxub_lw, w_psnenub_lw, w_indinus_lw, w_indpxus_lw, w_psnenus_lw, or....?
Peter
- Status changed from In Progress to Feedback
- % Done changed from 10 to 80
Dear Agnes,
Just checking if we can help you any further with this query?
Many thanks.
Hi,
Sorry again for the delayed response - I was finalising exactly what sort of analysis I will be undertaking. If you could let me know what predictors are used to create w_indpxub_lw and w_psnenub_lw, that should be everything.
Thanks
Agnes,
The attached extract from our weighting programmes shows the input variables for the models for each of these two weights (these do not change from wave to wave from wave 2 onwards) and also the final models for wave 6.
These weighting adjustments are applied to the wave 1 weight, which was based on model using lots of small area indicators (Census, neighbourhood stats, deprivation indices etc) as predictors.
Hope that helps,
Peter
- Status changed from Feedback to Closed
- % Done changed from 90 to 100
Also available in: Atom
PDF