Hello everyone,

I am using 4 rounds of a labor force panel survey for the years (1998, 2006, 2012 and 2018). My sample is the working age population who are wage workers. I intend to aggregate this data to the 4-digit occupation level to see how employment growth over each two successive years of the survey differs with occupations' skill-level. For instance, for the two years (1998 & 2006), I will rank occupations based on their mean wage in 1998 (as a measure of skills), group them into quantiles and see changes in employment share over the period for each skill quantile. The same analysis will be repeated after using a measure of task content of each occupation instead of its skill level.

So, in this case the list of variables will be: occupation, wage98, task content (constant in all years), employment98, employment06. The data files I have include expansion weights for cross-section analysis for each wave and panel weights for individuals observed in 98-06, 98-12, 06-12, 12-18, 06-18 and 98-18.

I am confused on how we use weights already available to adjust variables from survey data in STATA before collapsing it (like the example I've just mentioned). I will appreciate any help in this regard or any useful materials to understand well this step of my analysis.

Thanks