Hello All,

I have a dataset with the following structure: (besides 'revenue' there are several more variables)
ID Name Year Revenue
1 A 2016 10
1 A 2017 12
1 A 2018 13
2 B 2016 5
2 B 2017 6
2 B 2018 4
... ... ... ...
Is it possible to create 2 more observations (years 2019 and 2020) for each ID where I use the values of the year 2018 (Basically assuming that the variables do not change after 2018) and if possible, append them to each ID and not at the bottom of the dataset?

Since I am new to Stata I am not sure whether this is required, but the type of ID is str, the type of name is str and the type of year is int.

Thanks a lot in advance!

Best regards
Sebastian Ebener