I have the following data set, a panel dataset, (it is an example of what I have, the data set is much larger):
Year Individual Wage Mean_wage (this is the variable I want to create)
1998 1 60 70
1999 1 70 70
2000 1 80 70
1998 2 50 56,56
1999 2 50 56,56
2000 2 70 56,56
I would like to generate a new variable, which is the mean of the wage of each individual over the years, that is, the variable has to has the same value of the individual over the years. Probably, it's not clear, so I have create the variable mean_wage as an example. Anyone can help me?
Thanks!
Related Posts with Generate a new variable as the mean of individuals over time
Interpreting trended and de-trended dataHi Statalist team, I have detrended dataon malaria contraction rates to see the seasonal fluctuatio…
Categorical variable for each idHi, I would like to create a categorical variable (4 categories) for each variable. I organized th…
Compare values across rows within observationHi, My datasets are like following forms: Inventorid patentyear firmid 3930988 2000 13928 3930988 20…
Interpreting competing risk analysis resultsHello, I've done a competing risk analysis of the risk of dementia with kidney disease (the competi…
Extract code from variableHi, I would like to extract the code from the variable name, for instance: Code: ID_name 010000 P…
Subscribe to:
Post Comments (Atom)
0 Response to Generate a new variable as the mean of individuals over time
Post a Comment