I am new to Stata and therefore would appreciate some help with actually running my panel regression.
Below is my data. I have already done xtset and generated qdate from that.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str43 name float acode int year byte quarter float(qdate compost loginc logpopden loghhsize) long(md11 md12 md31 md32 md33) float(comavg wasteavg) "Adur District Council" 7000223 2014 3 218 10.892403 9.899881 2.678072 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2012 4 211 5.109999 9.845911 2.65858 .8586616 1 1 0 1 0 0 0 "Adur District Council" 7000223 2013 3 214 9.623345 9.886138 2.668824 .8628899 1 1 0 1 0 0 0 "Adur District Council" 7000223 2014 4 219 6.039579 9.899881 2.678072 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2012 2 209 9.733083 9.845911 2.65858 .8586616 1 1 0 1 0 0 0 "Adur District Council" 7000223 2012 1 208 3.635365 9.845911 2.663471 .8586616 1 1 0 1 0 0 0 "Adur District Council" 7000223 2015 2 221 12.008673 9.97376 2.6887314 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2016 4 227 6.988868 9.97711 2.6927335 .8712934 1 1 0 1 0 0 0 "Adur District Council" 7000223 2013 2 213 11.354862 9.886138 2.668824 .8628899 1 1 0 1 0 0 0 "Adur District Council" 7000223 2016 1 224 4.0117025 9.97711 2.6927335 .8712934 1 1 0 1 0 0 0 "Adur District Council" 7000223 2014 2 217 13.06053 9.899881 2.668824 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2013 4 215 6.429264 9.886138 2.668824 .8628899 1 1 0 1 0 0 0 "Adur District Council" 7000223 2015 4 223 6.273902 9.97376 2.6887314 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2015 3 222 10.610566 9.97376 2.6887314 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2014 1 216 4.6309547 9.899881 2.678072 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2016 2 225 13.037227 9.97711 2.6927335 .8712934 1 1 0 1 0 0 0 "Adur District Council" 7000223 2016 3 226 12.508617 9.97711 2.6927335 .8712934 1 1 0 1 0 0 0 "Adur District Council" 7000223 2012 3 210 10.98731 9.845911 2.65858 .8586616 1 1 0 1 0 0 0 "Adur District Council" 7000223 2015 1 220 3.851408 9.97376 2.6887314 .8671005 1 1 0 1 0 0 0 "Adur District Council" 7000223 2013 1 212 2.391451 9.886138 2.668824 .8628899 1 1 0 1 0 0 0 "Allerdale Borough Council" 7000026 2014 1 216 2.9364595 9.709964 -.2984061 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2016 1 224 7.628589 9.771498 -.29437107 .8712934 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2012 3 210 23.2185 9.676775 -.29705927 .8586616 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2016 4 227 13.765405 9.771498 -.29437107 .8712934 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2016 3 226 27.984756 9.771498 -.29437107 .8712934 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2013 4 215 12.774913 9.691964 -.2984061 .8628899 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2014 4 219 13.436963 9.709964 -.2984061 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2015 4 223 11.30833 9.758347 -.29571423 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2013 1 212 6.428598 9.691964 -.2984061 .8628899 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2015 2 221 23.62139 9.758347 -.29571423 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2014 3 218 24.60719 9.709964 -.2984061 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2012 2 209 23.02372 9.676775 -.29705927 .8586616 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2014 2 217 29.104996 9.709964 -.2984061 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2015 1 220 6.617072 9.758347 -.29571423 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2012 4 211 11.482567 9.676775 -.29705927 .8586616 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2013 2 213 21.339706 9.691964 -.2984061 .8628899 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2012 1 208 17.704374 9.676775 -.3202052 .8586616 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2015 3 222 25.802023 9.758347 -.29571423 .8671005 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2013 3 214 27.43951 9.691964 -.2984061 .8628899 1 1 0 0 0 1 0 "Allerdale Borough Council" 7000026 2016 2 225 22.63528 9.771498 -.29437107 .8712934 1 1 0 0 0 1 0 "Amber Valley Borough Council" 7000032 2012 2 209 5.100012 9.700024 1.5288783 .8586616 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2015 4 223 6.8863 9.819834 1.5407307 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2014 3 218 12.400318 9.749112 1.5370823 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2013 2 213 11.47245 9.740204 1.531044 .8628899 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2016 4 227 6.131042 9.838789 1.5415872 .8712934 1 1 0 0 0 1 .8 "Amber Valley Borough Council" 7000032 2013 1 212 .5841476 9.740204 1.531044 .8628899 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2014 1 216 3.47621 9.749112 1.5370823 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2012 4 211 2.7343905 9.700024 1.5288783 .8586616 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2014 4 219 6.58514 9.749112 1.5370823 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2016 3 226 13.686172 9.838789 1.5415872 .8712934 1 1 0 0 0 1 .8 "Amber Valley Borough Council" 7000032 2016 1 224 3.255951 9.838789 1.5415872 .8712934 1 1 0 0 0 1 .8 "Amber Valley Borough Council" 7000032 2013 3 214 13.181116 9.740204 1.531044 .8628899 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2015 3 222 12.70684 9.819834 1.5407307 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2014 2 217 14.295996 9.749112 1.5370823 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2016 2 225 12.65073 9.838789 1.5415872 .8712934 1 1 0 0 0 1 .8 "Amber Valley Borough Council" 7000032 2012 3 210 5.702137 9.700024 1.5288783 .8586616 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2013 4 215 7.264445 9.740204 1.531044 .8628899 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2015 2 221 12.903378 9.819834 1.5407307 .8671005 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2012 1 208 1.366725 9.700024 1.5214807 .8586616 1 1 0 0 0 1 1 "Amber Valley Borough Council" 7000032 2015 1 220 2.8631465 9.819834 1.5407307 .8671005 1 1 0 0 0 1 1 "Arun District Council" 7000224 2014 4 219 10.163612 9.865993 1.9205923 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2012 3 210 14.908836 9.820486 1.900614 .8586616 0 0 0 0 0 1 0 "Arun District Council" 7000224 2013 4 215 10.379933 9.860788 1.911171 .8628899 0 0 0 0 0 1 0 "Arun District Council" 7000224 2013 2 213 14.527653 9.860788 1.911171 .8628899 0 0 0 0 0 1 0 "Arun District Council" 7000224 2015 4 223 10.780918 9.936874 1.9309415 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2016 3 226 15.996178 9.939385 1.939461 .8712934 0 0 0 0 0 1 0 "Arun District Council" 7000224 2013 1 212 3.751499 9.860788 1.911171 .8628899 0 0 0 0 0 1 0 "Arun District Council" 7000224 2012 1 208 6.256315 9.820486 1.9059806 .8586616 0 0 0 0 0 1 0 "Arun District Council" 7000224 2016 1 224 7.261099 9.939385 1.939461 .8712934 0 0 0 0 0 1 0 "Arun District Council" 7000224 2015 3 222 15.054287 9.936874 1.9309415 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2012 2 209 13.356665 9.820486 1.900614 .8586616 0 0 0 0 0 1 0 "Arun District Council" 7000224 2014 2 217 17.668224 9.865993 1.911171 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2016 2 225 17.891514 9.939385 1.939461 .8712934 0 0 0 0 0 1 0 "Arun District Council" 7000224 2014 1 216 7.029479 9.865993 1.9205923 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2016 4 227 10.966786 9.939385 1.939461 .8712934 0 0 0 0 0 1 0 "Arun District Council" 7000224 2014 3 218 14.52263 9.865993 1.9205923 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2012 4 211 8.587595 9.820486 1.900614 .8586616 0 0 0 0 0 1 0 "Arun District Council" 7000224 2013 3 214 13.281113 9.860788 1.911171 .8628899 0 0 0 0 0 1 0 "Arun District Council" 7000224 2015 1 220 6.921752 9.936874 1.9309415 .8671005 0 0 0 0 0 1 0 "Arun District Council" 7000224 2015 2 221 16.799276 9.936874 1.9309415 .8671005 0 0 0 0 0 1 0 "Ashfield District Council" 7000170 2016 1 224 1.9273784 9.705341 2.4285126 .8712934 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2012 2 209 11.912817 9.593151 2.394982 .8586616 1 1 0 0 0 . 1 "Ashfield District Council" 7000170 2016 2 225 26.37377 9.705341 2.4285126 .8712934 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2013 4 215 7.10045 9.608781 2.400256 .8628899 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2015 1 220 1.9483192 9.701432 2.4198346 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2014 3 218 13.430163 9.641084 2.4119775 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2013 1 212 .9463254 9.608781 2.400256 .8628899 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2012 3 210 13.49746 9.593151 2.394982 .8586616 1 1 0 0 0 . 1 "Ashfield District Council" 7000170 2013 3 214 14.160374 9.608781 2.400256 .8628899 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2015 3 222 14.858505 9.701432 2.4198346 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2016 3 226 28.49253 9.705341 2.4285126 .8712934 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2015 4 223 8.768002 9.701432 2.4198346 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2014 2 217 14.909673 9.641084 2.4119775 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2015 2 221 14.8295 9.701432 2.4198346 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2012 1 208 2.435588 9.593151 2.3737888 .8586616 1 1 0 0 0 . 1 "Ashfield District Council" 7000170 2012 4 211 5.795621 9.593151 2.394982 .8586616 1 1 0 0 0 . 1 "Ashfield District Council" 7000170 2014 1 216 2.2574463 9.641084 2.4119775 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2014 4 219 7.14231 9.641084 2.4119775 .8671005 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2016 4 227 14.496334 9.705341 2.4285126 .8712934 1 1 0 0 0 1 1 "Ashfield District Council" 7000170 2013 2 213 12.329373 9.608781 2.400256 .8628899 1 1 0 0 0 1 1 end format %tq qdate
xtreg compost loginc logpopden loghhsize md11 md12 md31 md32 md33 wasteavg comavg
Thank You!!
0 Response to Help with xtreg, time fixed effects, local authority fixed effects
Post a Comment