xtset naic ts
panel variable: naic (unbalanced)
time variable: ts, 1997q1 to 2012q3, but with a gap
delta: 1 quarter
Is there anyway for me to know how the panel is unbalanced/ how to fix this?
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input double naic float(year yq) double(ts l) 337121 1997 971 148 95.57533264160156 337121 1997 972 149 96.86366271972656 337121 1997 973 150 96.51200103759766 337121 1997 974 151 97.7453384399414 337121 1998 981 152 97.62833404541016 337121 1998 982 153 97.94366455078125 337121 1998 983 154 97.80799865722656 337121 1998 984 155 99.89533233642578 337121 1999 991 156 100.65899658203125 337121 1999 992 157 102.07233428955078 337121 1999 993 158 102.20899963378906 337121 1999 994 159 103.28866577148438 337121 2000 1 160 103.92900085449219 337121 2000 2 161 104.42400360107422 337121 2000 3 162 103.45933532714844 337121 2000 4 163 101.83000183105469 337121 2001 101 164 98.24366760253906 337121 2001 102 165 95.09600067138672 337121 2001 103 166 91.13400268554688 337121 2001 104 167 89.53900146484375 337121 2002 201 168 91.61033630371094 337121 2002 202 169 92.4786605834961 337121 2002 203 170 90.79966735839844 337121 2002 204 171 89.50199890136719 337121 2003 301 172 87.90033721923828 337121 2003 302 173 86.07633972167969 337121 2003 303 174 84.18333435058594 337121 2003 304 175 85.17766571044922 337121 2004 401 176 87.84566497802734 337121 2004 402 177 88.04000091552734 337121 2004 403 178 86.95866394042969 337121 2004 404 179 87.6709976196289 337121 2005 501 180 87.3776626586914 337121 2005 502 181 86.74933624267578 337121 2005 503 182 84.38966369628906 337121 2005 504 183 83.93866729736328 337121 2006 601 184 83.03633880615234 337121 2006 602 185 81.24566650390625 337121 2006 603 186 78.73533630371094 337121 2006 604 187 77.35800170898438 337121 2007 701 188 76.13633728027344 337121 2007 702 189 74.23566436767578 337121 2007 703 190 71.7699966430664 337121 2007 704 191 70.56500244140625 337121 2008 801 192 70.28633880615234 337121 2008 802 193 67.6163330078125 337121 2008 803 194 64.13133239746094 337121 2008 804 195 60.36433029174805 337121 2009 901 196 55.15999984741211 337121 2009 902 197 52.931331634521484 337121 2009 903 198 51.308998107910156 337121 2009 904 199 51.02899932861328 337121 2010 1001 200 51.3466682434082 337121 2010 1002 201 52.03066635131836 337121 2010 1003 202 51.62099838256836 337121 2010 1004 203 50.3503303527832 337121 2011 1101 204 50.68266677856445 337121 2011 1102 205 50.77033233642578 337121 2011 1103 206 50.39666748046875 337121 2011 1104 207 50.749000549316406 337121 2012 1201 208 52.44300079345703 337121 2012 1202 209 52.964332580566406 337121 2012 1203 210 52.4119987487793 337211 1997 971 148 31.117666244506836 337211 1997 972 149 31.645666122436523 337211 1997 973 150 32.244998931884766 337211 1997 974 151 32.36433410644531 337211 1998 981 152 33.00899887084961 337211 1998 982 153 33.72066879272461 337211 1998 983 154 34.0706672668457 337211 1998 984 155 34.548667907714844 337211 1999 991 156 34.12300109863281 337211 1999 992 157 33.927669525146484 337211 1999 993 158 33.86466979980469 337211 1999 994 159 34.3390007019043 337211 2000 1 160 34.244998931884766 337211 2000 2 161 34.870330810546875 337211 2000 3 162 35.48733139038086 337211 2000 4 163 35.792667388916016 337211 2001 101 164 35.465999603271484 337211 2001 102 165 34.478668212890625 337211 2001 103 166 33.31700134277344 337211 2001 104 167 31.731000900268555 337211 2002 201 168 30.307334899902344 337211 2002 202 169 29.11400032043457 337211 2002 203 170 28.66900062561035 337211 2002 204 171 28.119665145874023 337211 2003 301 172 26.6113338470459 337211 2003 302 173 25.580665588378906 337211 2003 303 174 25.306333541870117 337211 2003 304 175 25.185333251953125 337211 2004 401 176 24.277334213256836 337211 2004 402 177 23.963666915893555 337211 2004 403 178 23.93199920654297 337211 2004 404 179 23.805999755859375 337211 2005 501 180 23.669334411621094 337211 2005 502 181 23.89466667175293 337211 2005 503 182 24.40566635131836 337211 2005 504 183 24.472999572753906 337211 2006 601 184 24.952665328979492 end format %tq ts
0 Response to Problems with an unbalanced panel
Post a Comment