Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Regression help needed

    Hi,

    I want to find the relation of tobq with the follwoing variables: mb oiadpa oiadprevt capex roa rd da log_s cdaraw charaw fgaraw ndaraw bcaraw ghnraw lcbraw gibraw ghpraw epinew.
    The data is arranged as per gvkey on a yearly basis.
    So this is a time series regression and as well the observations are grouped by gvkey. I am not able to find a suitable regression model that does multi variable time based regression and as well for categorical variables.
    Here is the extract of the data doen with dataex.

    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input str6 gvkey float firmid double fyear float(mb oiadpa oiadprevt capex roa rd da log_s cdaraw charaw fgaraw ndaraw bcaraw ghnraw lcbraw gibraw ghpraw epinew)
    "001491" 1491 2018      .453347   .06469826   .07454837  .05588364    .10892415           0    .19854404 12.670706  -.004885465   .05332677  .13299207   .009174924   -.02485989 116721.58           .   -.02523143  90606.68     75.01
    "001491" 1491 2019   -.13882348  .021469384   .03049126  .05281117    .08743358           0    .26364386 12.576932  -.008798524   .04956894  .11838485   .007256824  -.015325904 112436.05           .  -.026289845  92353.51     75.01
    "001491" 1491 2020    .06674153  .021796133   .03213436 .035652485    .08920133           0     .2448996 12.451118            .           .          .            .            .         .           .            .         .      65.8
    "002018" 2018 2010     .1233655  .003153853   .12801485          0   .005341744           0    .08208855 11.301516    .01332037     .032028  .05990632   -.01336977    .01338929 121716.31 -.026294716   -.02006713  84237.04  54.64116
    "002018" 2018 2012   -.28879857   .02192684   .49948525          0    .02404828           0    .07317365 11.942883   .022734685  .028405314  .09561488  -.020082464  .0089360215  153314.9   .13796015  -.014907585  92260.73     54.64
    "002018" 2018 2013   -.23480277  .022179186    .4783385          0     .0242761           0    .06795865 11.947263   .020294007  .031202616  .11157067  -.017062265    .00640176  144180.7   .07569032  -.014609252  85142.17     54.64
    "002018" 2018 2014    -.3540841  .013853898    .3604124          0   .015721953           0     .0597727 11.775178   .012466508   .03731097  .10556445  -.011887368  .0023368085  127314.9    .1142835  -.019337654  82612.62     65.78
    "002018" 2018 2015    -.3686967  .014967623   .40857255          0   .016583472           0    .05115979 11.743872   .004499224   .04046772   .1202135   -.00551598  -.011872308 121269.41   .07218915  -.022377897  88179.83     65.78
    "002018" 2018 2017  -.036012482  .015362503    .4442876          0   .016808698           0   .034551214  11.61689  -.004970952   .04922549  .13496697    .00809244  -.029473914  113615.8  .068539985  -.025918096  90041.22     78.14
    "002018" 2018 2018   -.04487946    .0160575     .455116          0   .017299205           0    .03863612 11.692968  -.004885465   .05332677  .13299207   .009174924   -.02485989 116721.58           .   -.02523143  90606.68     75.01
    "002018" 2018 2019    .04024683  .017022856     .483912          0   .018301807           0    .04254222  11.46403  -.008798524   .04956894  .11838485   .007256824  -.015325904 112436.05           .  -.026289845  92353.51     75.01
    "002338" 2338 2010     .2282314   .07779792   .10218662 .033954177     .1155431 .0041134446      .296687 15.478646  -.015894242  -.11478703  .05652193  -.034025922  -.071884416  275349.7   .11589016    -.0317447  615815.7 68.822685
    "002338" 2338 2012    .51477695   .07527896   .11108534  .04573315    .10325319 .0018552876     .1738174  15.44891   -.03178676  -.11054555  .05406445   -.02526402   -.06262575 113745.87   .23960727   -.03231633  587446.7     68.82
    "002338" 2338 2013     .8097002   .07919829    .1032209  .04514497     .1074139  .001521684    .22981125 15.268847  -.035052836  -.10444324  .05127205  -.019068906   -.06176976  94239.74   .06362944  -.031561527  575286.9     68.82
    "002338" 2338 2014      .815507   .08851101    .1059499  .04599956    .11946806 .0013048017    .24504033 15.305223   -.04284958  -.09473773   .0413481  -.008518716   -.06241509  22549.75   .08994394  -.034019206  538845.9     77.35
    "002338" 2338 2015    1.1102089   .07706574   .09528662  .05007212    .10900474 .0012738854     .2283124 15.304218   -.04707152  -.08162951 .031687833  -.002890277   -.05409052         0  .021019934   -.03692598  523745.8     77.35
    "002411" 2411 2010     1.986331   .11818182   .13857342  .11236194    .24473237    .0464734     .3980884  14.61321  -.015894242  -.11478703  .05652193  -.034025922  -.071884416  275349.7   .11589016    -.0317447  615815.7 68.822685
    "002721" 2721 2010     .7525007    .0972815    .1045488  .04999021     .1666102   .08519704  .0010369444 16.154968  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "002721" 2721 2012    .53922343    .0818748   .09306774  .07994205      .147134     .085196  .0005352037  16.05108   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "002721" 2721 2013     .4227338   .07949565   .09038935  .05495898     .1443535   .08209402  .0003412913 15.922433  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "002721" 2721 2014     .5422934   .08148848   .09752198  .04895331    .14055653   .08289727 .00025736346 15.877385 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "002721" 2721 2015     .5022036   .08022317   .09346965  .05712759     .1419533    .0864412 .00019897136  15.78179 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "002721" 2721 2018     .3475212   .06999785   .08678073  .03906529      .121341    .0799208    .07387786 15.890655  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "002721" 2721 2019    .39160135   .03663048   .04860909  .04522968    .08640178   .08307213    .09249067 15.740915   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "004925" 4925 2020    .23856533   .04662258   .07547164  .02819309    .08139743  .069395065    .13926986 15.333427            .           .          .            .            .         .           .            .         .      75.1
    "005650" 5650 2010     .3065367   .04839168   .04771546  .05692653    .10258165   .04241179     .1654625  17.09072  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "005650" 5650 2012    .13098928   .04302356   .04667898  .07313225    .08563843   .03774995    .14370598  17.19312   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "005650" 5650 2013     .3723794   .04836306   .05540763  .07456717     .0896982  .036542494    .15082747 17.170132  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "005650" 5650 2014     .3917951   .03884266   .04940793  .07489082    .07752945  .034250885    .16858453 16.993599 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "005650" 5650 2015     .2005112   .04386318   .05486449  .08169481     .0843213  .033255916     .1658449 16.914507 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "005650" 5650 2018    -.1395222   .05388075   .05471035  .03971821    .09211276  .034080055    .07359718 17.047354  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "005650" 5650 2019    .34785825  .014424857  .016338052 .032516755    .05804565   .03349962    .10780396 17.003428   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "005691" 5691 2010    .26904458   .04924218  .063755564   .0965323    .09795405   .05454932    .17658477 17.293613  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "005691" 5691 2012    .12302422   .03995568   .05515417   .1041408    .08325994   .05671219       .19881 17.273462   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "005691" 5691 2013    .28151932   .04802711  .063355215  .12174128    .09889886   .05354466    .20701957 17.419847  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "005691" 5691 2014   -.10702932   .03639471   .05031498 .035179134     .0703269   .05029224    .21308535 17.423994 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "005691" 5691 2015    .04641826  .027613577   .03447509   .0348437     .0638582   .04929748     .2049793 17.420313 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "005691" 5691 2018    -.4554307  .035573028   .04571638 .020606566    .07091711   .05160927    .20286563 17.575344  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "005691" 5691 2019    -.3557776   .03096733   .04243765 .018092303    .06517197   .05501303     .2063014 17.521835   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "005691" 5691 2020    -.5552905   .03011756   .05012771  .01452532    .05859428   .05922318    .21510673 17.474371            .           .          .            .            .         .           .            .         .      75.1
    "006203" 6203 2010   -.27592367 -.003632665  -.14373936          0 -.0004466832           0    .06616294   11.5598    .01332037     .032028  .05990632   -.01336977    .01338929 121716.31 -.026294716   -.02006713  84237.04  54.64116
    "006203" 6203 2012    -.6040215   .02314317    .4534725          0    .02614496           0    .06115093 11.230965   .022734685  .028405314  .09561488  -.020082464  .0089360215  153314.9   .13796015  -.014907585  92260.73     54.64
    "006203" 6203 2013    -.5605166  .018882133    .3645994          0    .02198427           0    .05817253 11.409163   .020294007  .031202616  .11157067  -.017062265    .00640176  144180.7   .07569032  -.014609252  85142.17     54.64
    "006203" 6203 2014    -.6984193    .0146415   .33850965          0   .017444164           0    .05140471 11.374203   .012466508   .03731097  .10556445  -.011887368  .0023368085  127314.9    .1142835  -.019337654  82612.62     65.78
    "006203" 6203 2015    -.5799478  .011940953    .3320238          0   .014445094           0    .04662379  11.39129   .004499224   .04046772   .1202135   -.00551598  -.011872308 121269.41   .07218915  -.022377897  88179.83     65.78
    "006203" 6203 2017   -.28247386  .015079943    .3470301          0   .017050823           0    .03453108 11.804366  -.004970952   .04922549  .13496697    .00809244  -.029473914  113615.8  .068539985  -.025918096  90041.22     78.14
    "006203" 6203 2018   -.24262863    .0167868    .3804605          0   .018555373           0    .03543834  11.87512  -.004885465   .05332677  .13299207   .009174924   -.02485989 116721.58           .   -.02523143  90606.68     75.01
    "006203" 6203 2019 -.0022559334  .016822992   .38497445          0    .01861652           0    .05053055 11.731652  -.008798524   .04956894  .11838485   .007256824  -.015325904 112436.05           .  -.026289845  92353.51     75.01
    "006494" 6494 2010     .9768975   .10372955    .1209515  .04691185    .14535882  .026587967     .1354739  15.39996  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "006494" 6494 2012    .58751065   .08404052   .11225624  .05679115    .11951592   .03224843    .13655025 15.801144   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "006494" 6494 2013     .4229245   .09069958    .1230999   .0701588    .12361345  .033004258     .1173149 15.692725  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "006494" 6494 2014     .5457029   .08649993   .12233534  .07149782    .12303464  .035738543    .09979606 15.616306 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "006494" 6494 2015     .2436988   .07977232   .11244261  .06367152    .12278642   .03813335    .08132472 15.569747 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "006494" 6494 2018     .2066904   .10934086   .14597084  .05278682    .14547503  .026950624     .1298671 15.809494  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "006494" 6494 2019    .37184805   .06861755    .1025441   .0505536    .10463488   .03057872     .1227429 15.842247   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "006494" 6494 2020     .3600581   .04421005    .0764225  .04796714    .07938352   .03372441    .15337473 15.767247            .           .          .            .            .         .           .            .         .      75.1
    "006506" 6506 2010     .4431209  .063463815   .09222703 .020162847    .08335765  .026775626    .14132713 15.300455  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "006512" 6512 2010    .11034407   .08010209    .1230729  .03382572    .11685605   .03905049    .01260579  15.32745  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "006512" 6512 2012    -.1020372  .033697307    .0600959  .02558903    .06593635  .037122652   .009135499  15.67113   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "006512" 6512 2013    .05036475    .0457321   .08331117  .01930061    .07461323   .03373708   .007382702 15.597688  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "006512" 6512 2014   -.05438864    .0309243   .06120262  .01888498    .05508503  .036215983    .00591854 15.640722 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "006512" 6512 2015   -.06755128  .029936844   .06262119 .021357335    .05470124   .03970933   .005852896  15.58718 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "006512" 6512 2018    -.0856495  .031943336   .05839898  .03740641    .05346584   .04306619  .0019053555 15.336768  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "006512" 6512 2019    .14959307  .030826956  .062657714  .03296284    .05936326   .04955496    .02363473 15.212022   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "006512" 6512 2020   -.08140653   .02022173   .04626638 .035162173     .0514394   .04941853   .026317386 15.208033            .           .          .            .            .         .           .            .         .      75.1
    "006972" 6972 2010     .4143368   .11250527   .15372115  .02615253    .13279213   .02671386 .00005100575   13.4393  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "006972" 6972 2012      .397438   .10287681   .14651681  .02603555    .11997987  .027116235 .00001814166 13.775232   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "006972" 6972 2013      .572592   .10578266   .14330114 .021992946     .1223915  .022755325 .00003082133 13.757932  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "006972" 6972 2014     .4565582   .12498088    .1733829 .021073196     .1399619   .02198361  .0006657072 13.725925 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "006972" 6972 2015     .7186224   .11590183    .1526735  .02109049    .13253911  .022645134 .00005376113 13.727828 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "006972" 6972 2018     .6466641   .11511209   .15961784  .03508563      .131681   .02370673  .0001822859 13.909146  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "006972" 6972 2019     .6246107    .0949443   .13001175 .065833636     .1162158  .025179805            0  13.83063   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "006972" 6972 2020     .7887403   .10882814   .14542083  .06133147    .12911531   .02217707            0 13.865045            .           .          .            .            .         .           .            .         .      75.1
    "007471" 7471 2010   .035986956  .036868855   .03188372  .03845979    .05401073 .0003821987     .3278074 16.815794  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "007471" 7471 2012    -.3043986  .024659887  .025334546  .04056513    .04391994 .0004975304    .30848294  17.07875   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "007471" 7471 2013   -.29144427   .02501676   .02464843 .034046542    .04585382           0     .3120097 16.886635  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "007471" 7471 2014    -.3417371  .015592168   .01757231  .03100684     .0375842 .0005541276     .3302978  17.06187 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "007471" 7471 2015    -.2634909  .011093522  .012585863 .027572677   .034297567 .0006031099     .3517852   16.9929 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "007471" 7471 2018    -.3722454  .021747347   .03733929 .025759643    .03734466           0     .3188622 16.880404  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "007471" 7471 2019   -.11843914  .018365378  .031492513 .024380136    .04005932           0     .3582173 16.695322   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "007471" 7471 2020   -.34265324  .012041376   .01881443 .017233355   .033904783           0    .31922024 16.704554            .           .          .            .            .         .           .            .         .      75.1
    "007652" 7652 2010   -.17497993   .02199373  .018559271  .02190244    .06464148    .0566581    .12851079 15.623686  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "007652" 7652 2012    -.4103755   .04442019   .03732474 .017827434    .08540794   .04937998    .15382923 15.378158   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "007652" 7652 2013   -.11988617   .04238685   .03489616 .035707086     .0819162   .04690031     .1890107 15.167436  -.002691811  -.02110973  .06882333  -.017842382    -.0748612   1455234 -.030516285  -.002923703 1471606.4     63.36
    "007652" 7652 2014     .1100524   .04887486   .04363252 .016202457      .087284   .04571767    .14591941 15.004422 -.0009976317  -.02393461  .07185048  -.016652476   -.07624078 1497736.6  -.04532205 -.0007454223 1441163.5     72.35
    "007652" 7652 2015     .2358958   .04303531   .03803584  .01304302     .0790546   .04395145    .12829539 14.652215 -.0020449047  -.02881841  .07578444  -.017193608   -.08327032   1461832   -.0518573 -.0022203191 1400182.8     72.35
    "007652" 7652 2018  -.010687404   .01981435    .0200673  .01658251     .0533942  .037117902    .13154031 14.629777  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "007652" 7652 2019    .25682724   .04085771   .04122758  .02331703    .09412267  .035469692    .15155412  14.55877   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "007652" 7652 2020    .14454623   .04191259   .05135532 .016166272    .08760158   .03828461    .16460556 14.579762            .           .          .            .            .         .           .            .         .      75.1
    "007908" 7908 2010    -.4098384    .0617784   .11789507  .07174087     .1615737   .02602823    .17945126 16.107885  -.003613159  -.02338014   .0490662   -.02422514   -.09320072   1312863   .06437352  -.009993747 1379201.8  63.35617
    "007908" 7908 2012    -.5492626   .06115737    .1123257  .07826088    .15779293   .02515639      .166426  16.15286   -.00513992  -.01877925  .06352711    -.0204624   -.07302645 1356440.8   .03804919  -.006410911   1443478     63.36
    "007908" 7908 2018   -.05819148   .07597318   .14258043   .0750096    .13579099  .017788284    .12995909 16.188587  -.004177726 -.032818966  .08117782   -.01912704   -.10227702   1501486           .  -.009480687 1382629.6     74.69
    "007908" 7908 2019    .17127302  .067877896   .13127965  .08066135    .13154791  .008597061    .11054616 16.100216   -.01969285  -.03246803    .077216   -.02003967   -.09747308 1183650.8           .  -.014243094 1349276.8     74.69
    "008071" 8071 2010    .45163715  -.01227303 -.009190476  .02478512     .0624895   .07498988   .003266582 13.634456 -.0021477216    -.032769  .03533824   -.04500057   -.05775186 211989.75    .1646957  -.020289125  244579.9  65.65064
    "008544" 8544 2012    1.3028343    .1182918   .29700154  .08866952     .1993578           0    .25049698  12.47025    .02574711  .015774507 .036256388  -.003221071  -.014333994  293227.7  .036573242  -.028829437  189031.2      57.4
    "008544" 8544 2013     1.438788   .11717355   .27818406   .0721603     .1955545           0     .2225264 12.449867   .033274096  .015568532 .028395426 -.0007359032 -.0032413166  322701.6  .021823997   -.02603072    197894      57.4
    "008544" 8544 2014    1.5455645   .10220379   .26082405  .07966857    .17675884           0    .26449993    12.472     .0425348   .01531399  .02198495   .006151747   .004954907  357073.6   .05523857   -.02331031  204911.4     44.02
    "008544" 8544 2015     1.369988   .08654676   .23019467   .0948703     .1581692           0     .3163779 12.429754    .05399106   .01337044 .017246863   .009071012   .012124295 398535.75    .0513558   -.02058198  215503.7     44.02
    "008544" 8544 2018     .7761788   .04590782   .13451734  .10102744    .11286794           0     .3228068 13.150846    .07068725   .01320964 .012886624    .01902063    .02963597  518993.3           .  -.020532243  249420.3     57.65
    "008544" 8544 2019     .6496457    .0852242   .26447067  .17085026     .1568548           0     .3541418 13.347568    .07161649   .01291476  .01516091   .018096993    .03045426  539824.3           .   -.02000144  255252.2     57.65
    end
    format %ty fyear

  • #2
    Santosh:
    you are dealing with a N>T panel dataset with a continuous regressand.
    I would go:
    Code:
    xtset firmid year
    xtreg tobq i.year <otherpredictors>, fe vce(cluster clusterid)
    Kind regards,
    Carlo
    (Stata 19.0)

    Comment


    • #3
      Thank you.

      Does this mean that this is a panel data regression with fixed effects considered on year and clusterid?

      Comment


      • #4
        Santosh:
        not quite.
        The codes mean that:
        1) your dataset is -xtset- with the -panelvar- that corresponds to the fixed effect you're interested in + a -timevar- that allows you to use time-series operator, such as lags and leads, if necessary. Please note that, why the -panelvar- is mandatory to -xtset- your dataset, the -timevar- is at your discrection, being aware that no -timevar- in -xtset-=no chance of using time-series related operators in your regression;
        2) the -xtreg- code includes -i.time- (as it is highly recommended under the -fe- specification) to investigate the role of time in explaining within-panel variation of the regressand when adjusted for the remaining predictors.
        Kind regards,
        Carlo
        (Stata 19.0)

        Comment

        Working...
        X