I’m new to understanding society data and stata and just wanted to check I’m weighting the data properly (both in terms of the weight used and the code entered). I’m looking at how individuals move between employment status over waves a, b and c at local authority level using special license data, the sectors they move into, how their pay changes as they move, their reason for changing jobs and whether they are permanently or temporarily employed. I’d like to extract the data and then analysis it in excel. I’m using the wave_indresp and wave_oslaua data. Before merging the data the code I’m using for wave b is
Keep pidp b_hidp b_strata b_psu b_indpxus_lw b_jbstat b_jbsect b_paygu_dv b_jbterm1 b_jbterm2 (etc)
Svyset b_psu [pweight = b_indpxus_lw], strata (b_strata)
Will this give me the correctly weighted data in terms of the proportion moving from employment to unemployment etc and from one sector to another and changes in their pay as they move between sectors? Or will I need to enter separate weights for each variable and look at each variable separately?
For wave a I’m using weight a_indpxus_xw and for wave c c_indpxub_lw are these correct?
Updated by Olena Kaminska over 6 years ago
If you are using three waves in one model then use c_indpxub_lw. If you are using each wave separately, then use cross-sectional weights ending with _xw (a b and c respectively).
Note, the weight n_indPXub_lw (with PX) is suitable only if ALL your questions are asked to proxy respondents as well as individual respondents (check this with the questionnaire and look at Universe for each question). Otherwise use _indINub_lw type weight. Please, read the documentation part of weights - this should be helpful.