Announcement

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

  • Firm fixed effects in SEM (unbalanced panel data)

    Dear all,

    that is my first post here on Statalist; I hope my request is in line with this forum's policy.

    I am currently working with unbalanced panel data. More specifically, that means that my data set consists of two components:
    1) archival data for each year between 2008 and 2017 (let's call the variable of my main interest VPerf)
    2) survey data, but only for the years 2009, 2010, 2013, 2016, 2017 (let's call the variable my main interest VSurvey)

    Although this data set does not represent quite a good starting point, I would still like to show that VSurvey in t0
    1) does affect VPerf in t+1 positively and in t+2 negatively and
    2) is also dependent on the VPerf t-1

    Because of the bidirectional relationship I am hypothesizing in 2), I quickly thought of using SEM in Stata.
    However, if I work in the Wide format, I have on the one hand a very weak data set in terms of numbers of observations and on the other hand, I also find mixed evidence (e.g. the impact of VSurvey2009 on VPerf2010 is not the same as the one from VSurvey2013 on VPerf2014).

    I do not want to give up at this stage since the number of observations is small and I could still imagine that there is a significant relationship if I would be able to work in the Long format.

    The problem with the Long format: without firm fixed effects, Stata believes that several observations from the same company are independent of each other. Therefore, the coefficient is over-estimated. For that reason, I am looking for solutions how I can include firm fixed effects in my SEM.

    What might be also helpful to know:
    • Because of my weak data set I am using full information maximum likelihood (mlmv).
    • I have already read about the “xtdpdml” command. However, I do not think that it is suitable for my problem. On the one hand it cannot account for the bidirectional relationship I am hypothesizing. On the other hand, even if I am only looking for unidirectional relationships, Stata calculates for hours and hours if I use the “fiml” option (“mlmv”-equivalent option) without reaching any results. Probably my data set is too weak.
    Thank you very much for any kind of help!

    Best,
    Eric


  • #2
    Eric, you are providing an extensive account of your doubts, but at the end it is not very clear what you want to do.

    If you clarify this, look up the help for -dataex- and provide some minimal data example on which people who want to help you can work.

    You might be confused regarding the difference between single equation, and system estimators. And the difference is this of efficiency (and possibly of joint hypothesis testing). That is, the fact that you have bi-directional relationship does not imply that you have to use a system estimator.

    I think for your case dynamic panel estimators such as Anderson Hsiao and Arrelano Bond should do the trick.

    Comment


    • #3
      Joro, thank you very much for your quick reply. I have included an excert of my data set as well as my SEM code below.
      What do I exactly want? I am just looking for a solution how I can include firm fixed effects into my SEM.

      Of course, I am also open for other methods. But for example with regards to Arellano–Bond: I have tried xtabond2 already. The common tests fail - I think one particular reason for that is the fact that my panel is unbalanced (my survey item is missing for 2011, 2012, 2014, 2015, 2016).

      Code:
      sem       (vsurvey -> f1.vperf f2.vperf) ///
                    (vsurvey <- l.vperf) ///
                    ///
                    (l.vsurvey -> vsurvey) ///
                    ///
                    (l.vperf l.size l.finlev l.logofemployees l.wconassets-> vperf) ///
                    ///
      ,standardized method (mlmv)
      estat gof, stats(all)
      Comment with regards to my dataset: VSurvey is a likert scale from 1 to 7 and in many cases it's missing (in total there are 1.780 values for VSurvey).

      Code:
      * Example generated by -dataex-. To install: ssc install dataex
      clear
      input int(ID year) double VSurvey float(VPerf size wconassets finlev logofemployees)
      
      1002 2015                  .   21.052 17.896938    .19433643  .7087114 11.705634
      1002 2016                  1   16.039 17.868164     .1940231  .7230605 11.781287
      1002 2017                2.5   13.877 18.234941    .19004664  .6672222 12.576015
      1003 2008                  .   53.486 14.819277    .04480281  .6199084 9.2748165
      1003 2009                  4   26.222  14.77547    .04397809  .5921183  9.281731
      1003 2010                2.5    15.46 14.878115    .04697073 .50804746  9.355566
      1003 2011                  .   14.989  14.97393    .04776119  .5389134 9.4638195
      1003 2012                  .   12.241 14.822483    .05166174  .5314047  9.399306
      1003 2013                2.5   10.787  14.84563    .04725795  .5267502  9.460554
      1003 2014                  .   35.904 14.926677    .04102654  .5588859  9.540867
      1003 2015                  .   12.187 15.007886    .03814165  .6122342  9.617337
      1003 2016                  .   17.062  15.00646    .03974474  .5897587  9.637111
      1003 2017                  .   13.522  15.08603    .03911057  .5640189  9.670041
      1004 2008                  .  -122.02  8.811053    .20474672  .8890675  3.713572
      1004 2009                  2 -136.612 8.5342455    .08182507  .7164445  3.433987
      1004 2010                  1   -4.704   8.27333    .09820613  .6332907 3.3322046
      1004 2011                  .  -10.287  8.052693    .06859698   .768115  3.218876
      1004 2012                  .   30.699  8.021716    .09281268   .584639 3.2580965
      1004 2013                  .  -41.726  7.938882    .07865348  .7451755  3.433987
      1004 2014                  .        .         .    .19294466  .6903916    3.7612
      1004 2015                  .        .         .    .16484945  .7054457 3.4011974
      1004 2016                  .        .         .    .20546134  .7381914  3.465736
      1004 2017                  .        .         .            .         .         .
      1005 2008                  .   -8.106 13.306792   .000680353  .3040074  9.431001
      1005 2009                  .   -2.182   13.4036  -.007105026  .3136086   9.44169
      1005 2010                  .     -2.6 13.409563  -.004285638  .3092934  9.445571
      1005 2011                  .   -2.386 13.427493  -.003222452  .3157916 9.2748165
      1005 2012                  .   -1.872 13.459172 -.0041296673  .3133976  9.455245
      1005 2013                  .    4.133 13.515485  -.001405326   .270986  9.465447
      1005 2014                  .     .218 13.592933  -.004251084 .25592515  9.488956
      1005 2015                  .      .51 13.617697  -.003075186  .2466775  9.510149
      1005 2016                  .     .317 13.985928   .007322695  .2514399  9.536546
      1005 2017                  .        .         .            .         .         .
      1006 2008                  .    1.453  8.287879      .008407 .13125852  5.556828
      1006 2009                  .    2.001  8.138376   .003750394  .1335458  5.609472
      1006 2010                  .    4.262  8.245428   .008342497  .1224891  5.648974
      1006 2011                  .   -1.416  8.355492 -.0003626472 .15202034  5.673323
      1006 2012                  .     .007  8.279816 -.0004830607 .13267876  5.723585
      1006 2013                  .     .122  8.296003  .0008403313 .13678898  5.768321
      1006 2014                  .    3.466  8.385896  .0006124717 .14002164  5.777652
      1006 2015                  .    6.933   8.43404  .0080047045  .1736977  5.783825
      1006 2016                  .    6.419  8.412367  .0002078989  .1577545  5.817111
      1006 2017                  .        .         .            .         .         .
      1008 2008                  .        .         .            .         .         .
      1008 2009                  2        .         .            .         .         .
      1008 2010                2.5        .         .            .         .         .
      1008 2011                  .        .         .            .         .         .
      1008 2012                  .        .         .            .         .         .
      1008 2013                2.5        .         .            .         .         .
      1008 2014                  .        .         .            .         .         .
      1008 2015                  .        .         .            .         .         .
      1008 2016                  .    4.773 11.512466     .6612524  .6912195  6.986567
      1008 2017                  .        .         .            .         .         .
      1009 2008                  .        .  10.74412   -.16037473  .7863488   5.83773
      1009 2009                  .        .  10.86998   -.15859155  .7903335  5.953243
      1009 2010                  .        . 11.090697    -.1097304   .413794    5.7301
      1009 2011                  .        . 11.158011   -.03675961  .2416819  6.146329
      1009 2012                  .        . 10.902482   -.04347145 .23964816  6.142037
      1009 2013                  .        . 10.900432   -.05117054 .29787534  6.098074
      1009 2014                  .        .    10.969   -.04420376  .3256602  5.774551
      1009 2015                  .        . 11.021613   -.05789337  .3309103    5.9428
      1009 2016                  .        . 11.065958   -.05515567  .4191966  5.860786
      1009 2017                  .        .         .            .         .         .
      1010 2008                  .        .         .            .         .         .
      1010 2009                  .   29.752  11.41795   .016443446   .814358   7.17549
      1010 2010                  1   11.962 11.549384   -.00693442  .8800349  7.320527
      end
      label values VSurvey

      Comment

      Working...
      X