Error code 451: repeated time values within panel when trying to declare data to be panel data

[Emma Anderson]

I have a dataset which contains 18 quarterly datasets from the Labour Force Survey which have been merged together for me to conduct data analysis. There are around 25000 observations and 21 variables. I wish to run panel regression as the data is from a combination of countries in the UK so this would be most accurate. However, when I try using the command 'xtset panelvar timevar' the error 451: repeated time values within panel is returned. I have tried using different panelvar however the same result is always returned. I have gathered that the reason for this may be that there are more than one panelvar timevar combinations in my dataset however I cannot figure out how to solve this problem.

[Nick Cox]

https://www.stata.com/support/faqs/d...d-time-values/ makes some suggestions.

[Carlo Lazzaro]

Emma:
welcome to this forum
As as aside to Nick's helpful advice, if you do not plan to use time-series commands, such as lags and leads, you can simply -xtset- your dataset with the -panelid- only.

[Emma Anderson]

Thank you for your help, dropping the duplicates helped solve my problem!