I have a dataset of observations for companies based on different years (2016-2020). Is it possible to create observations for each company for 1995-2015 based on the earliest year (in this case 2016), basically just copying the values of 2016? In the following is an example of the structure of the dataset:
| ID | Name | Year | Revenue | Net Income | ... |
| 1 | X | 2016 | 12 | ... | ... |
| 1 | X | 2017 | 14 | ... | ... |
| 1 | X | 2018 | 15 | ... | ... |
| 1 | X | 2019 | 16 | ... | ... |
| 1 | X | 2020 | 13 | ... | ... |
| ... | ... | ... | ... | ... | ... |
Thanks a lot in advance, have a nice day!
Best regards
Sebastian Ebener
0 Response to Expand observations
Post a Comment