Hello all,
I'm new in Stata...I have multıdımensonal data form as below.. I want to test autocorelation with xtserial command. Bu I can not because of "repeated time values within panel
r(451);" I dont want to make drop actually. How can I fixed it. Could please help me? I tried below command:
egen newgroup=group(ıncomelevel countries sektor fırms)
xtset newgroup yıl
repeated time values within panel

Example generated by -dataex-. To install: ssc install dataex
clear
input byte ıncomelevel long countries int(sector fırm year) double dependentvar
3 4 107 207 2016 1.050e+08
3 4 110 210 2016 18000000
3 4 120 220 2016 10000000
3 4 124 224 2016 25000000
3 4 125 225 2017 1.920e+08
3 4 125 225 2016 4.710e+08
3 4 113 213 2016 19000000
3 4 100 200 2016 1560000
3 4 113 213 2016 8000000
3 4 100 200 2017 70000000
3 4 100 200 2016 1.100e+09
3 4 100 200 2016 6000000
3 4 124 224 2016 12600000
3 4 100 200 2016 72000000
3 4 113 213 2016 1.000e+08
3 4 100 200 2016 1.500e+09
3 4 104 204 2016 6000000
3 4 112 212 2016 6500000
3 4 109 209 2017 10000000
3 4 113 213 2016 69000000
3 4 100 200 2016 4000000
3 4 112 212 2016 60000000
3 4 114 214 2016 12000000
3 4 100 200 2016 12800000
3 4 100 200 2016 4500000
3 4 100 200 2017 1.890e+08
3 4 125 225 2016 15000000
3 4 121 221 2016 34000000
3 4 125 225 2016 1000000
3 4 112 212 2016 68000000
3 4 115 215 2016 30000000
3 4 125 225 2016 3.980e+09
3 4 125 225 2016 1000000
3 4 125 225 2016 20000000
3 4 125 225 2017 8000000
3 4 125 225 2016 15000000
3 4 125 225 2016 1.100e+09
3 4 125 225 2016 84000000
3 4 121 221 2016 3.000e+08
3 4 121 221 2016 86000000
3 4 100 200 2016 700000
3 4 120 220 2016 5000000
3 4 121 221 2017 4.350e+08
3 4 120 220 2016 2.200e+08
3 4 125 225 2016 12000000
3 4 120 220 2017 22700000
3 4 120 220 2016 25000000
3 4 107 207 2016 1.030e+08
3 4 124 224 2016 3.720e+08
3 4 104 204 2017 4980000
3 4 124 224 2017 31000000
3 4 125 225 2017 18000000
3 4 100 200 2016 30000000
3 4 100 200 2016 2.000e+08
3 4 108 208 2016 16600000
3 4 100 200 2016 60000000
3 4 100 200 2016 14000000
3 4 100 200 2016 37000000
3 4 100 200 2016 2300000
3 4 106 206 2016 2.000e+08
3 4 134 234 2017 33800000
3 4 100 200 2016 1.900e+08
3 4 100 200 2016 42000000
3 4 100 200 2017 8300000
3 4 112 212 2017 2795000
3 4 100 200 2017 1.100e+09
3 4 112 212 2016 24000000
3 4 100 200 2016 2.500e+08
3 4 112 212 2017 10000000
3 4 113 213 2016 8000000
3 4 100 200 2016 40000000
3 4 121 221 2016 3.400e+08
3 4 110 210 2017 16600000
3 4 104 204 2016 25000000
3 4 103 203 2016 4000000
3 4 109 209 2016 15000000
3 4 104 204 2016 28000000
3 4 115 215 2016 27200000
3 4 100 200 2016 88500000
3 4 113 213 2016 40000000
3 4 112 212 2017 24000000
3 4 113 213 2017 21000000
3 4 107 207 2016 21300000
3 4 100 200 2016 700000
3 4 104 204 2016 60000000
3 4 110 210 2016 7000000
3 4 100 200 2017 4.000e+08
3 4 100 200 2017 44000000
3 4 124 224 2016 60000000
3 4 108 208 2016 3.000e+08
3 4 125 225 2016 6.380e+08
3 4 107 207 2016 24000000
3 4 100 200 2016 1200000
3 4 100 200 2016 1.500e+08
3 4 124 224 2016 4.800e+08
3 4 100 200 2017 20000000
3 4 112 212 2016 2.820e+09
3 4 103 203 2016 26000000
3 4 100 200 2016 13000000
3 4 112 212 2016 4830360
end
label values countries countries
label def countries 4 "Arjantin", modify


Thank you so much..