Good afternoon,
Attached is an extract of my dataset. I have cross-sectional data with two variables (GRSSWK1 and GRSSWK5, measuring the gross weekly wage in quarter 1 and quarter 5, respectively), capturing two different periods for observations 2956, 2597 and 2958.
I need to be able to transform this into panel data to assess a time-trend interaction, for example creating 't=1, 2' and a gross weekly wage variable for the same observation.
I'm aware one possibly way may be to duplicate and then match, however my econometrics and Stata knowledge aren't great, nor am I certain that I would be able to do this for 5000 observations (my full dataset) and other variables.
Any help would be greatly appreciated.
.
Attached is an extract of my dataset. I have cross-sectional data with two variables (GRSSWK1 and GRSSWK5, measuring the gross weekly wage in quarter 1 and quarter 5, respectively), capturing two different periods for observations 2956, 2597 and 2958.
I need to be able to transform this into panel data to assess a time-trend interaction, for example creating 't=1, 2' and a gross weekly wage variable for the same observation.
I'm aware one possibly way may be to duplicate and then match, however my econometrics and Stata knowledge aren't great, nor am I certain that I would be able to do this for 5000 observations (my full dataset) and other variables.
Any help would be greatly appreciated.
.
Comment