Daniel Lawson
Thanks for the great help.
Your assumptions about the data are correct.
This worked perfectly:
gen individual_ID = 1
replace individual_ID = individual_ID[_n-1] + 1 if (_n>1) & (year[_n] ==
year[_n-1])
quietly sum individual_ID
replace individual_ID=individual_ID + (id - 1)*r(max)
tsset individual_ID year
The programming below worked great and got me the output that I needed.
I transformed my repeated time unbalanced panel data for in time series: for
different years, the same individual.
I would really happy with your help on this.
Thank you very much.