Hi fellow people. I am using Stata to make an analysis of how the level of democracy in some countries have developed or regressed during the covid-19 pandemic. From what i have understood, I need to make sure that my data is ready for doing paneldata, with panelregression as a goal. In order to do this, I have a data set that looks like the following:

My goal is to make graphs showing how all the countries included (about 90) has changed from 2010 and to 2021 in terms of the democracy variable in the far right of the photo. However when I write in tsset year (as the year is my intended variabel of setting a date) I get the error message "repeated time values in sample". Which I understand why I get because I have multiple countries with the same year in the dataset. Will it be impossible to make the paneldata with the variables I have right now and should I look for another way to reach my goal? Or do I have to change the variables in some way in order to set the year as date?
I am very thankful for any advice or suggestions on how to go forward with this. If anyone would know a better way to present this data through stata, where the countries, years, and their progression with the v2x_polyarchy variable to the right, I would be so grateful for tips. Thanks in advance.
Since I posted a photo of the data from VDem, I would also like to cite them correctly:
Coppedge, Michael, John Gerring, Carl Henrik Knutsen, Staffan I. Lindberg, Jan Teorell, David Altman, Michael Bernhard, Agnes Cornell, M. Steven Fish, Lisa Gastaldi, Haakon Gjerløw, Adam Glynn, Sandra Grahn, Allen Hicken, Katrin Kinzelbach, Kyle L. Marquardt, Kelly McMann, Valeriya Mechkova, Pamela Paxton, Daniel Pemstein, Johannes von Römer, Brigitte Seim, Rachel Sigman, Svend-Erik Skaaning, Jeffrey Staton, Eitan Tzelgov, Luca Uberti, Yi-ting Wang, Tore Wig, and Daniel Ziblatt. 2022. "V-Dem Codebook v12" Varieties of Democracy (V-Dem) Project.
My goal is to make graphs showing how all the countries included (about 90) has changed from 2010 and to 2021 in terms of the democracy variable in the far right of the photo. However when I write in tsset year (as the year is my intended variabel of setting a date) I get the error message "repeated time values in sample". Which I understand why I get because I have multiple countries with the same year in the dataset. Will it be impossible to make the paneldata with the variables I have right now and should I look for another way to reach my goal? Or do I have to change the variables in some way in order to set the year as date?
I am very thankful for any advice or suggestions on how to go forward with this. If anyone would know a better way to present this data through stata, where the countries, years, and their progression with the v2x_polyarchy variable to the right, I would be so grateful for tips. Thanks in advance.
Since I posted a photo of the data from VDem, I would also like to cite them correctly:
Coppedge, Michael, John Gerring, Carl Henrik Knutsen, Staffan I. Lindberg, Jan Teorell, David Altman, Michael Bernhard, Agnes Cornell, M. Steven Fish, Lisa Gastaldi, Haakon Gjerløw, Adam Glynn, Sandra Grahn, Allen Hicken, Katrin Kinzelbach, Kyle L. Marquardt, Kelly McMann, Valeriya Mechkova, Pamela Paxton, Daniel Pemstein, Johannes von Römer, Brigitte Seim, Rachel Sigman, Svend-Erik Skaaning, Jeffrey Staton, Eitan Tzelgov, Luca Uberti, Yi-ting Wang, Tore Wig, and Daniel Ziblatt. 2022. "V-Dem Codebook v12" Varieties of Democracy (V-Dem) Project.

Comment