Support #1182

Pooling data for analysis by calendar year

Added by Rebecca Benson almost 5 years ago. Updated over 1 year ago.

Start date:
% Done:



I am trying to get to the mean of certain variables for each calendar year and I am uncertain about rescaling weights. I have read the note on this ( In the note, the example code is for a year where only two waves are contributing data, with the weights for data in the second wave being multiplied by (sum of w1 weights/sum of w2 weights).

For years 2013-2016, data from three waves are available. Would the appropriate modification to the weights then be:
w1 weight= w1 weight *(sum of w2 & w3 weights/sum of w1 weights)
w2 weight= w2 weight *(sum of w1 & w3 weights/sum of w2 weights)
w3 weight= w3 weight

Thanks for any guidance!


Updated by Alita Nandi almost 5 years ago

  • Status changed from New to In Progress
  • Assignee set to Olena Kaminska
  • % Done changed from 0 to 10
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

Best wishes,
Understanding Society User Support Team


Updated by Olena Kaminska almost 5 years ago

Dear Rebecca,

Thank you for your question. No, your suggestion will not work. You should base your calendar year on the month of issue, rather than a month of interview. What happens is that December month of issue has mostly response in December, but some people are followed for some time and respond later (up until March or April the following year). These numbers are small, but these people are important to keep with the previous year.

Hope this helps,


Updated by Stephanie Auty almost 5 years ago

  • Category set to Weights
  • Status changed from In Progress to Feedback
  • Assignee changed from Olena Kaminska to Rebecca Benson
  • % Done changed from 10 to 70

Updated by Understanding Society User Support Team over 1 year ago

  • Status changed from Feedback to Resolved
  • % Done changed from 70 to 100

Also available in: Atom PDF