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?