Announcement

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

  • #16
    Well, as I said in #14, when you are creating latent variables in structural equation models, these variables have no inherent metric or scale and this fact leaves the model unidentified. The conventional way to identify the model is to fix the loading of the latent variable on one of its indicators at 1. But another way to identify the model is to fix the variance of the latent variable at 1, and in some contexts, or for some audiences, this approach may be the more understandable way, and it eliminates the question of which indicator variable to select to receive the unit loading, a selection that is usually completely arbitrary. Identifying the model by fixing the latent variable's variance to 1 has the advantage of treating all the indicators equally.

    When all is said and done, the purpose of data analysis is to increase our understanding of the phenomena the data represent. So we should structure the analyses and present the results in the most informative, comprehensible way we can. Most of the time, standardization is counter-productive because it converts variables measured in units that people understand to variables measured in units that are obscure, even secret, and irreproducible. They make the results less understandable. That's why I think they should only be used when the variables are, themselves, already measured in obscure or arbitrary units--at least then they don't make anything worse.

    Comment


    • #17
      Dear Clyde,

      I centered the data and this was what I got.
      What do you think? The constant is disturbing.
      I am still running the second model DCE, with a long Not Concave running.

      Code:
      xtlogit csr lib lthce lltce roece bsce bice levce sizce Polrightinvce religdiverce lingdiverce ethnicce democracyce autocracyce RuleofLawce ShRightsce CredRightce mcapce lngdpce  i.industry i.year , vce(cluster idc)
      And the output:

      Click image for larger version

Name:	CSR centered.png
Views:	2
Size:	52.8 KB
ID:	1431407






      Comment


      • #18
        And some of the coefficients of the other variables, including some of the industry indicators, are still in the outlandish range. For some of the continuous ones it could be a scaling issue (e.g. if you have some variable that is in units of, kilometers when it would be more appropriately used in units of meters). But the constant term is also clearly preposterous, given that you have centered the continuous variables. I can only conclude that there must be something truly peculiar going on in your data, but without seeing it, I can't say what. Your data set is evidently quite large, so posting the whole thing here would not be a good idea. I wonder if you can select a relatively small sample of your data, containing only several dozen observations perhaps, that produces similar results, and post that using -dataex-.
        Last edited by Clyde Schechter; 23 Feb 2018, 11:25.

        Comment


        • #19
          Hello Clyde, first time using dataex, hope it helps.
          Thank you !!

          Code:
          * Example generated by -dataex-. To install: ssc install dataex
          clear
          input byte(csr lib) double(lth llt roe) byte bs double(bi lev siz) byte Polrightinv double(religdiver lingdiver ethnic) byte(democracy autocracy RuleofLaw) double ShRights byte CredRight double mcap float(lngdp industry) int year
          0 1 25.6926952141058 25.6926952141058  .13901753614769927  8                .75    .299619417073097  19.95318145496617 6 .258 .353 .4901 10 0 14              7.25 1 100.8 10.816 7 2011
          0 1 25.6926952141058 25.6926952141058  .08107084043777962  8                .75  .12986203984990596 20.333834498197394 6 .258 .353 .4901 10 0 14              7.25 1 115.6 10.848 7 2012
          0 1 25.6926952141058 25.6926952141058 .008992176180817154  9  .7777777777777778 .005835632417413186  21.14589611037559 6 .258 .353 .4901 10 0 14              7.25 1   144 10.874 7 2013
          1 1 25.6926952141058 25.6926952141058 -1.0012923014881325 10                 .8 .009165150709467969 20.610405042161563 6 .258 .353 .4901 10 0 14              7.25 1 151.4 10.908 7 2014
          0 1 25.6926952141058 25.6926952141058   .2700163913756147 10                 .9  .14432565789473684 24.176929158511868 6 .258 .353 .4901 10 0 14              7.25 1 100.8 10.816 5 2011
          0 1 25.6926952141058 25.6926952141058  .24634146341463414 10                 .9  .14721336639508797 24.245972636005764 6 .258 .353 .4901 10 0 14              7.25 1 115.6 10.848 5 2012
          0 1 25.6926952141058 25.6926952141058     .37711155075331 12  .9166666666666666  .21714797403178868 24.165893028371705 6 .258 .353 .4901 10 0 14              7.25 1   144 10.874 5 2013
          0 1 25.6926952141058 25.6926952141058  .41142419341108366 10                 .9  .26893453145057766  24.21119122211839 6 .258 .353 .4901 10 0 14              7.25 1 151.4 10.908 5 2014
          0 0 81.8639798488665                0 -.18876893686969654  7 .42857142857142855   .6084118114732988  18.56520655324707 6 .273 .734 .5554  8 0 15              6.25 2  43.5 10.773 9 2011
          0 1 81.8639798488665 81.8639798488665   1.583673469387755  5                 .2   .5000707689041436  18.12731758866535 6 .273 .734 .5554  8 0 15              6.25 2  60.2 10.709 9 2012
          0 0 51.1335012594458                0 -.12192693574327947  5                 .4  .04033156006433255 18.573001730339588 6 .319 .139 .1211 10 0 15 6.582316875457764 4 118.6 10.627 3 2011
          0 0 51.1335012594458                0  .40572878897751996  6  .3333333333333333  .07934952327165211 18.358094242783555 6 .319 .139 .1211 10 0 14              6.58 4 112.1 10.634 3 2012
          0 0 51.1335012594458                0   .4045305514157973  6  .3333333333333333                   0 18.244870546174088 6 .319 .139 .1211 10 0 15              6.58 4 126.1 10.655 3 2013
          0 0 51.1335012594458                0   1.162544420753376  6  .3333333333333333                   0 18.128468425414052 6 .319 .139 .1211 10 0 15              6.58 4 117.4 10.745 3 2014
          0 0 51.1335012594458                0   .0159496863640485  7  .2857142857142857                   0  19.41071252352884 6 .319 .139 .1211 10 0 15 6.582316875457764 4 118.6 10.627 3 2011
          end

          Comment


          • #20
            Thanks, but this one won't quite do the trick. It doesn't contain the firm variable (needed for -xtset-) It is also lacks several of the other variables that appear in the regression commands that are giving you trouble. In particular, it doesn't contain fememp or dcs, two of the outcome variables that have been involved. I need a data set that will enable me to run those commands.

            Also, this example is not quite large enough. If I do -tab csr-, the only outcome variable from your analyses that is in the data example, the result is 14 zeros and a single 1. I need a data set that contains several observations with each value (but more or less in proportion to how they are in the whole data.)

            However, even in this very limited data set there are some suggestions that the data are "pathological." If I compare the distributions of lib, lth, roe, lev, religdiver, democracy, RuleofLaw, ShRights, CredRight, mcap, and lngdp, disaggregated by csr, in each case there is no overlap. That is, the one observation where csr = 1 has values for these variables that are either just at the boundary of or outside the range of the values of these variables when csr = 0. Now, perhaps that is a coincidence in this very small sample with only one observation having csr = 1. But if this phenomenon is true, or close to true, in the full data, that would explain why you are getting these bizarre results. This phenomenon is called "perfect prediction", and it makes it impossible to estimate logistic (or probit) models in the data using maximum likelihood. For single-level data there are alternatives available (-ssc desc firthlogit-, credit to Joseph Coveney), but I'm not aware of any that work with multi-level (including panel) data. So you should check this in your full data set. Probably the easiest way to check this is graphically. Run commands like -graph box lib, over(csr)- and see if the distributions are separated, or show only a very small amount of overlap. If so, that variable is not usable.

            Comment


            • #21
              Hello Clyde,
              I am sorry, was the first time I used dataex and I was literal on the dozen observations.
              Now I am posting 150, but I dont know how to put an equal number of observations having csr=1, actually, I have 13319 obs with 0 and 1550 obs with 1; now, for DCE I have 13856 obs with 0 and 9211 with 1.
              I am posting all the variables for DCE and CSR, but I couldn´t add for FEMP because I received a message saying limit the variables and the max number of characters are 30,000-

              Thank you for your help again:

              Code:
              * Example generated by -dataex-. To install: ssc install dataex
              clear
              input byte(csr dce lib) double(pdh lpd lth llt roe) byte bs double(bi lev siz) byte Polrightinv double(religdiver lingdiver ethnic) byte(democracy autocracy RuleofLaw) double ShRights byte CredRight double mcap float(lngdp industry) int year float idc
              0 0 1 40 40   25.6926952141058  25.6926952141058    .13901753614769927  8                .75       .299619417073097  19.95318145496617 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 7 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .08107084043777962  8                .75     .12986203984990596 20.333834498197394 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 7 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058   .008992176180817154  9  .7777777777777778    .005835632417413186  21.14589611037559 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 7 2013 40
              1 1 1 40 40   25.6926952141058  25.6926952141058   -1.0012923014881325 10                 .8    .009165150709467969 20.610405042161563 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 7 2014 40
              . 0 0 40  0   25.6926952141058                 0    .34868477057972247 10                 .9     .16554628654733944 23.929826136091965 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 5 2007 40
              . 0 0 40  0   25.6926952141058                 0      .350237878327766 10                 .9      .2044858496105218 23.963785729872484 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 5 2008 40
              . 0 1 40 40   25.6926952141058  25.6926952141058    .24003909186588482 10                 .9      .1909724770642202 24.028319358055665 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 5 2009 40
              . 0 1 40 40   25.6926952141058  25.6926952141058    .25504151838671413 10                 .9     .14182915506035282  24.12964974529587 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 5 2010 40
              0 1 1 40 40   25.6926952141058  25.6926952141058     .2700163913756147 10                 .9     .14432565789473684 24.176929158511868 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .24634146341463414 10                 .9     .14721336639508797 24.245972636005764 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058       .37711155075331 12  .9166666666666666     .21714797403178868 24.165893028371705 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .41142419341108366 10                 .9     .26893453145057766  24.21119122211839 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40
              0 0 0 65  0   81.8639798488665                 0   -.18876893686969654  7 .42857142857142855      .6084118114732988  18.56520655324707 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 9 2011  3
              0 0 1 65 65   81.8639798488665  81.8639798488665     1.583673469387755  5                 .2      .5000707689041436  18.12731758866535 6 .273 .734 .5554  8 0 15               6.25 2  60.2 10.708646 9 2012  3
              0 0 0 35  0   51.1335012594458                 0   -.12192693574327947  5                 .4     .04033156006433255 18.573001730339588 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39
              0 0 0 35  0   51.1335012594458                 0    .40572878897751996  6  .3333333333333333     .07934952327165211 18.358094242783555 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39
              0 0 0 35  0   51.1335012594458                 0     .4045305514157973  6  .3333333333333333                      0 18.244870546174088 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39
              0 0 0 35  0   51.1335012594458                 0     1.162544420753376  6  .3333333333333333                      0 18.128468425414052 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39
              . 0 1 35 35   51.1335012594458  51.1335012594458     .3692020662805871  8               .375                      0 19.020511256342612 6 .319 .139 .1211 10 0 15              6.625 4 125.6 10.818758 3 2007 39
              . 0 1 35 35   51.1335012594458  51.1335012594458      .333917025862069  8               .375                      0  19.02224977202266 6 .319 .139 .1211 10 0 14              6.625 4    65 10.747702 3 2008 39
              . 0 1 35 35   51.1335012594458  51.1335012594458     .2050619322873658  8               .375                      0 19.120465844692493 6 .319 .139 .1211 10 0 14              6.625 4    94 10.545605 3 2009 39
              . 0 0 35  0   51.1335012594458                 0    .06723386062419838  7 .42857142857142855                      0 19.420429881816602 6 .319 .139 .1211 10 0 14              6.625 4 121.7 10.563853 3 2010 39
              0 0 0 35  0   51.1335012594458                 0     .0159496863640485  7  .2857142857142857                      0  19.41071252352884 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39
              0 0 0 35  0   51.1335012594458                 0     .2388663967611336  5                 .4                      0 19.466595243620027 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39
              0 0 0 35  0   51.1335012594458                 0     .2862049227246709  5                 .4                      0 19.621247755143468 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39
              0 0 0 35  0   51.1335012594458                 0    .30740140464613724  6                 .5                      0  19.72141721671061 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39
              0 0 1 40 40   25.6926952141058  25.6926952141058   .009037378944416884  7  .7142857142857143   .0001336884991126426 19.516632830752297 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 8 2013 40
              0 0 1 40 40   25.6926952141058  25.6926952141058   .007075393720312551  7  .7142857142857143                      0   19.5045989345409 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 8 2014 40
              0 0 0 35  0   51.1335012594458                 0  -.030640297978006385  9  .3333333333333333      .6638175908634475 21.927976479003128 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39
              . 0 0 57  0  70.02518891687657                 0   -.12512764119079414  4                .25      .2767302902422342 19.245457871659614 6  .55 .069 .3222  9 0 14               5.25 3  36.5  9.816512 3 2007  8
              . 0 0 57  0  70.02518891687657                 0   -.25448930573029854  4                 .5      .2807397328055418  18.72083002873732 6  .55 .069 .3222  9 0 14               5.25 3  17.4  10.02787 3 2008  8
              . 0 1 57 57  70.02518891687657 70.02518891687657     .3705707330267785  3  .6666666666666666     .24585054893164918 18.623545340144307 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.888272 3 2009  8
              . 0 1 57 57  70.02518891687657 70.02518891687657     .3533600663716814  3  .6666666666666666     .20198778084840072  18.49651588946879 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.891618 3 2010  8
              0 1 0 57  0  70.02518891687657                 0     .4008137957760124  3  .6666666666666666      .3127123678270168 18.506010034527527 6  .55 .069 .3222  9 0 14 3.7750000953674316 3  17.4   9.98585 3 2011  8
              0 1 0 57  0  70.02518891687657                 0     .4753136468379278  3  .3333333333333333     .13541087774853464  18.65044122382914 6  .55 .069 .3222  9 0 14               3.78 3  17.4  9.889895 3 2012  8
              0 0 1 40 40   25.6926952141058  25.6926952141058     .1141677006465095  7  .7142857142857143                      0 19.002790212919827 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .19870996698905427  7  .7142857142857143                      0  19.08075189406916 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .25369558597946673  7  .5714285714285714                      0 19.267051031419648 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058     .2555807688438279  7  .7142857142857143                      0  19.26592220568617 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40
              0 0 1 40 40   25.6926952141058  25.6926952141058     .0835950192089205 11  .8181818181818182     .19357678783044466 21.256084041250734 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .07820009191452411 11  .8181818181818182      .3049156674574717 21.509745333536127 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058     .0728490056960128 11  .8181818181818182      .2565583087065242 21.511495898753047 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058   .012069577564785232 11  .8181818181818182    .056105610561056105 21.138681275907743 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40
              . 0 0 31  0 52.896725440806044                 0    .13034454130344542 10                 .5     .45207180760980015 20.982583009896054 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 2 2007 34
              . 0 0 31  0 52.896725440806044                 0  .0004268032437046522 10                 .5      .4476439790575916   21.2710966598876 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 2 2008 34
              . 0 0 31  0 52.896725440806044                 0     .2822002049880424 10                 .5      .3997415717138494 20.896315862284084 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 2 2009 34
              . 0 0 31  0 52.896725440806044                 0    .19573400250941028 10                 .4     .33625162127107655 20.945995382572093 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 2 2010 34
              0 1 0 31  0 52.896725440806044                 0     .1688639551192146  8                .25      .3408863043914177  21.17605992793267 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 2 2011 34
              0 1 0 31  0 52.896725440806044                 0    .16314045373438696  8               .375     .28422131147540985 21.112935382739476 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 2 2012 34
              0 1 0 31  0 52.896725440806044                 0     .1677360219981668  8                 .5     .22787456445993032 21.141519653142122 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 2 2013 34
              0 1 0 31  0 52.896725440806044                 0    .15155172413793103  8                 .5     .20284526854219948 21.311178360594653 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 2 2014 34
              0 0 1 40 40   25.6926952141058  25.6926952141058    .11649842200226511  9  .5555555555555556     .08863158149530674 21.274359125620382 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .15230969100258246 10                 .7     .07709788965811677   21.3182096063417 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .06394087228580467  9  .7777777777777778     .20086134895011648 21.622143436406255 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058     .0993028044413289 10                 .9     .17047510695312867  21.70116893794809 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40
              . 0 0 68  0  63.47607052896725                 0   -1.5612213930983234  6 .16666666666666666     .34232571347437174 16.829493078024065 6 .443 .272 .1032  9 0 15               7.25 0  72.2   10.6366 4 2009 10
              . 0 0 68  0  63.47607052896725                 0    -.6418859500777921  6 .16666666666666666     .22117150826586843  17.48679070379101 6 .443 .272 .1032  9 0 15               7.25 0  72.2 10.614058 4 2010 10
              0 0 0 68  0  63.47607052896725                 0    -1.248350795498642  6 .16666666666666666     .21434390061774491 17.456272768696792 6 .443 .272 .1032  9 0 14               7.25 0  54.3 10.687617 4 2011 10
              0 0 1 68 68  63.47607052896725 63.47607052896725   -1.5612213930983234  6 .16666666666666666      .3211927156293777 17.493284847361032 6 .443 .272 .1032  9 0 15               7.25 0  67.4  10.61737 4 2012 10
              0 0 1 68 68  63.47607052896725 63.47607052896725   -1.5612213930983234  5                 .2      .5056035569408475  17.91275541526159 6 .443 .272 .1032  9 0 15               7.25 0  81.9  10.65853 4 2013 10
              0 0 1 68 68  63.47607052896725 63.47607052896725    1.0250621771570692  5                 .2      .6638175908634475 17.452364649794333 6 .443 .272 .1032  9 0 15               7.25 0  73.2  10.66791 4 2014 10
              . 0 0 60  0  45.34005037783375                 0    .32650250306813466 11 .18181818181818182     .09258873472864557  20.27066776478885 6 .054 .175 .1576 10 0 14                  5 1  83.2 10.269068 3 2007 12
              . 0 0 60  0  45.34005037783375                 0     .2406984790706577  7  .2857142857142857      .1975088766489538  20.57284052107584 6 .054 .175 .1576 10 0 13                  5 1  25.4 10.373398 3 2008 12
              0 0 1 40 40   25.6926952141058  25.6926952141058    .08619728665623073  7  .8571428571428571    .003962604908105812  19.05333454408335 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .08192884188127797  6  .8333333333333334    .004306078004355573   19.0186157399063 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .07315022999649333  6  .8333333333333334    .002677592102716304 19.195343393294447 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .12412236482374633  6  .8333333333333334   .0017839621800017837 19.410459827483677 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40
              0 0 0 28  0  24.43324937027708                 0    .05099159915129003  7 .42857142857142855                      0  19.44156046061093 6 .015 .223  .155 10 0 15               5.81 1  45.1 10.869863 2 2011 15
              0 0 0 28  0  24.43324937027708                 0   .042936023821225175  7 .42857142857142855                      0  19.40817181594081 6 .015 .223  .155 10 0 15               5.34 1  48.3 10.804278 2 2012 15
              0 0 0 28  0  24.43324937027708                 0    .09868531939996629  7 .42857142857142855                      0 19.565014560003004 6 .015 .223  .155 10 0 15               5.34 1  71.1 10.859672 2 2013 15
              0 0 0 28  0  24.43324937027708                 0    .16039634430285435  7 .42857142857142855                      0  19.76270511444581 6 .015 .223  .155 10 0 15               5.34 1    60 10.924192 2 2014 15
              . 0 0 40  0   25.6926952141058                 0    .20284646545779347 13  .9230769230769231     .23890333778147937  24.40496769362659 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 4 2007 40
              . 0 0 40  0   25.6926952141058                 0    .27922450639607393 13  .9230769230769231     .20540996007374396 24.470867021173273 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 4 2008 40
              . 0 1 40 40   25.6926952141058  25.6926952141058     .2509238831552616 13  .9230769230769231     .21493742548046257 24.682489610790142 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 4 2009 40
              . 0 1 40 40   25.6926952141058  25.6926952141058    .20582294439196483 10                 .9     .21061284479135053 24.808607763443757 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 4 2010 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .19279218156787378 12  .9166666666666666     .19974191436841313 24.822214666576066 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .22238721538679113 11  .9090909090909091     .26898664480184586 24.931458949322366 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .10555016405564029 11  .9090909090909091     .08256814052089642 24.443522826752602 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40
              1 1 1 40 40   25.6926952141058  25.6926952141058     .2073994185501266 11  .9090909090909091     .14233762455451304  24.44284421980962 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40
              . 0 0 31  0 52.896725440806044                 0      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 5 2007 34
              . 0 0 31  0 52.896725440806044                 0    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 5 2008 34
              . 0 0 31  0 52.896725440806044                 0    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 5 2009 34
              . 0 0 31  0 52.896725440806044                 0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 5 2010 34
              0 1 0 31  0 52.896725440806044                 0    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 5 2011 34
              0 1 0 31  0 52.896725440806044                 0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 5 2012 34
              0 1 0 31  0 52.896725440806044                 0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 5 2013 34
              0 1 0 31  0 52.896725440806044                 0     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 5 2014 34
              . 0 1 34 34    73.551637279597   73.551637279597      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .146 .547 .5314 10 0 15                4.6 1   267 11.054423 5 2007 35
              . 0 1 34 34    73.551637279597   73.551637279597    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .146 .547 .5314 10 0 15                4.6 1 159.6 11.186087 5 2008 35
              . 0 1 34 34    73.551637279597   73.551637279597    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .146 .547 .5314 10 0 15                4.6 1 197.3 11.151554 5 2009 35
              . 0 0 34  0    73.551637279597                 0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .146 .547 .5314 10 0 15                4.6 1 211.5 11.215557 5 2010 35
              0 1 1 34 34    73.551637279597   73.551637279597    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .146 .547 .5314 10 0 15 3.8329267501831055 1 156.5  11.38507 5 2011 35
              0 1 0 34  0    73.551637279597                 0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .146 .547 .5314 10 0 15               3.83 1 185.5  11.32857 5 2012 35
              0 1 0 34  0    73.551637279597                 0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .146 .547 .5314 10 0 15               3.83 1   225 11.346387 5 2013 35
              0 1 1 34 34    73.551637279597   73.551637279597     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .146 .547 .5314 10 0 15               3.83 1 212.8  11.35258 5 2014 35
              1 1 1 40 40   25.6926952141058  25.6926952141058     1.568539994052929  9  .8888888888888888      .5416913507109005 24.019398955359957 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    1.0183696900114811  9  .8888888888888888      .3835263368061858  24.03915947369411 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    1.3039290240811154  9  .8888888888888888      .5511781338360038 24.694500702006405 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40
              . 0 1 57 57  47.60705289672544 47.60705289672544                     0 14  .2857142857142857      .4721387603395052 23.203072893182277 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33
              . 0 1 57 57  47.60705289672544 47.60705289672544                     0 15  .3333333333333333     .44079724648612933 23.335624296955046 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33
              . 0 1 57 57  47.60705289672544 47.60705289672544                     0 14 .35714285714285715     .44844630416189024 23.607329829319212 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33
              . 0 1 57 57  47.60705289672544 47.60705289672544                     0 15                 .4      .4712944506441859  23.84529184847622 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33
              0 1 1 57 57  47.60705289672544 47.60705289672544    .09613177735489459 15  .3333333333333333      .4859527399259272 23.914446595250475 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33
              0 1 0 57  0  47.60705289672544                 0     .0684705116711782 15 .26666666666666666      .5228897638435305 24.023076053860066 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33
              0 1 0 57  0  47.60705289672544                 0   .053903770886786766 15 .26666666666666666      .4950301484268428 24.096471361256903 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33
              0 1 0 57  0  47.60705289672544                 0   .055819500773192365 16              .3125      .3132146334981014 24.145960193657146 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33
              . 0 0 40  0   25.6926952141058                 0    .30042475007062563  8               .875                      0  21.53333657280418 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 3 2007 40
              . 0 0 40  0   25.6926952141058                 0     .2939462267188115  8               .875                      0 21.666236668464066 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 3 2008 40
              . 0 1 40 40   25.6926952141058  25.6926952141058      .147517471491316  9  .8888888888888888    .035110128183566985 21.769946381847497 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 3 2009 40
              . 0 1 40 40   25.6926952141058  25.6926952141058 .00013895598104290293  9  .8888888888888888     .02523613807317569 21.760664205195766 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 3 2010 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .07948184456817911  9  .8888888888888888    .023259253530137705  21.80435956784442 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .06854282732048435  9  .7777777777777778    .018979034188900623 21.837801670361387 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .03158613535874386  9  .7777777777777778     .06339045604046585  21.77093459461403 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40
              1 1 1 40 40   25.6926952141058  25.6926952141058    .03728931619103677 12  .9166666666666666     .13593576206002345   21.6453998634734 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40
              . 0 1 57 57  47.60705289672544 47.60705289672544    .17532862229864052 21 .19047619047619047      .5602375146987079  24.14623054674291 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33
              . 0 1 57 57  47.60705289672544 47.60705289672544     .1833457322701381 20                 .2      .5743933748686636 24.154811689940555 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33
              . 0 1 57 57  47.60705289672544 47.60705289672544    .15215914333244795 19 .21052631578947367       .562068652843642 24.296330463685663 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33
              . 0 1 57 57  47.60705289672544 47.60705289672544    .12131973663798652 19 .21052631578947367      .5633275408971288  24.24411455546138 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33
              0 1 1 57 57  47.60705289672544 47.60705289672544     .1587499006389229 20                 .2      .5917730275730636 24.105456510441705 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33
              0 1 0 57  0  47.60705289672544                 0    .14717047758179727 20                 .2      .5325691588528321 24.370718827150903 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33
              0 1 0 57  0  47.60705289672544                 0    .08619597813107063 17 .29411764705882354      .5264111879020381  24.38165912396481 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33
              0 1 0 57  0  47.60705289672544                 0     .1057567826266792 17 .29411764705882354      .5303278812204696 24.241175612719445 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33
              0 1 1 40 40   25.6926952141058  25.6926952141058   .011837177446811882  7  .8571428571428571                      0 18.851885071238648 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40
              0 1 1 40 40   25.6926952141058  25.6926952141058   .043664205568062345  7  .8571428571428571                      0 19.140503934722233 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40
              0 1 1 40 40   25.6926952141058  25.6926952141058    .38993003155439704  7  .8571428571428571                      0 19.639641663210682 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40
              . 0 0 65  0   81.8639798488665                 0   -.11575687543332563  7 .42857142857142855   .0004540852787041448 19.102544634944273 6 .273 .734 .5554  8 0 15                  5 2  81.7 10.701085 4 2007  3
              . 0 0 65  0   81.8639798488665                 0   -.16217108767444338  7 .42857142857142855 .000023711103909961036 18.986460689230416 6 .273 .734 .5554  8 0 15                  5 2  32.2  10.78777 4 2008  3
              . 0 0 65  0   81.8639798488665                 0    -.2626566481885295  7 .42857142857142855                      0 18.808519496566078 6 .273 .734 .5554  8 0 15                  5 2  53.6  10.71177 4 2009  3
              . 0 0 65  0   81.8639798488665                 0    -.2427820220259946  7 .42857142857142855    .008630859508786884 18.984026447666686 6 .273 .734 .5554  8 0 15                  5 2  55.6 10.700544 4 2010  3
              0 1 0 65  0   81.8639798488665                 0    -.7486781511171755  7 .42857142857142855    .017781566848339068 18.663522392393784 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 4 2011  3
              end


              Comment


              • #22
                I am sorry, I forgot the firm as you asked, the problema is I can´t ask for all the variables at the same time, dataex has a limit.

                Then, for CSR:


                Code:
                * Example generated by -dataex-. To install: ssc install dataex
                clear
                input byte(csr dce lib) double(lth llt roe) byte bs double(bi lev siz) byte Polrightinv double(religdiver lingdiver ethnic) byte(democracy autocracy RuleofLaw) double ShRights byte CredRight double mcap float(lngdp industry) int year float idc int firm
                0 0 1   25.6926952141058  25.6926952141058    .13901753614769927  8                .75       .299619417073097  19.95318145496617 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 7 2011 40  1
                0 1 1   25.6926952141058  25.6926952141058    .08107084043777962  8                .75     .12986203984990596 20.333834498197394 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 7 2012 40  1
                0 1 1   25.6926952141058  25.6926952141058   .008992176180817154  9  .7777777777777778    .005835632417413186  21.14589611037559 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 7 2013 40  1
                1 1 1   25.6926952141058  25.6926952141058   -1.0012923014881325 10                 .8    .009165150709467969 20.610405042161563 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 7 2014 40  1
                . 0 0   25.6926952141058                 0    .34868477057972247 10                 .9     .16554628654733944 23.929826136091965 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 5 2007 40  2
                . 0 0   25.6926952141058                 0      .350237878327766 10                 .9      .2044858496105218 23.963785729872484 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 5 2008 40  2
                . 0 1   25.6926952141058  25.6926952141058    .24003909186588482 10                 .9      .1909724770642202 24.028319358055665 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 5 2009 40  2
                . 0 1   25.6926952141058  25.6926952141058    .25504151838671413 10                 .9     .14182915506035282  24.12964974529587 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 5 2010 40  2
                0 1 1   25.6926952141058  25.6926952141058     .2700163913756147 10                 .9     .14432565789473684 24.176929158511868 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40  2
                0 1 1   25.6926952141058  25.6926952141058    .24634146341463414 10                 .9     .14721336639508797 24.245972636005764 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40  2
                0 1 1   25.6926952141058  25.6926952141058       .37711155075331 12  .9166666666666666     .21714797403178868 24.165893028371705 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40  2
                0 1 1   25.6926952141058  25.6926952141058    .41142419341108366 10                 .9     .26893453145057766  24.21119122211839 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40  2
                0 0 0   81.8639798488665                 0   -.18876893686969654  7 .42857142857142855      .6084118114732988  18.56520655324707 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 9 2011  3  3
                0 0 1   81.8639798488665  81.8639798488665     1.583673469387755  5                 .2      .5000707689041436  18.12731758866535 6 .273 .734 .5554  8 0 15               6.25 2  60.2 10.708646 9 2012  3  3
                0 0 0   51.1335012594458                 0   -.12192693574327947  5                 .4     .04033156006433255 18.573001730339588 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39  4
                0 0 0   51.1335012594458                 0    .40572878897751996  6  .3333333333333333     .07934952327165211 18.358094242783555 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39  4
                0 0 0   51.1335012594458                 0     .4045305514157973  6  .3333333333333333                      0 18.244870546174088 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39  4
                0 0 0   51.1335012594458                 0     1.162544420753376  6  .3333333333333333                      0 18.128468425414052 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  4
                . 0 1   51.1335012594458  51.1335012594458     .3692020662805871  8               .375                      0 19.020511256342612 6 .319 .139 .1211 10 0 15              6.625 4 125.6 10.818758 3 2007 39  5
                . 0 1   51.1335012594458  51.1335012594458      .333917025862069  8               .375                      0  19.02224977202266 6 .319 .139 .1211 10 0 14              6.625 4    65 10.747702 3 2008 39  5
                . 0 1   51.1335012594458  51.1335012594458     .2050619322873658  8               .375                      0 19.120465844692493 6 .319 .139 .1211 10 0 14              6.625 4    94 10.545605 3 2009 39  5
                . 0 0   51.1335012594458                 0    .06723386062419838  7 .42857142857142855                      0 19.420429881816602 6 .319 .139 .1211 10 0 14              6.625 4 121.7 10.563853 3 2010 39  5
                0 0 0   51.1335012594458                 0     .0159496863640485  7  .2857142857142857                      0  19.41071252352884 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39  5
                0 0 0   51.1335012594458                 0     .2388663967611336  5                 .4                      0 19.466595243620027 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39  5
                0 0 0   51.1335012594458                 0     .2862049227246709  5                 .4                      0 19.621247755143468 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39  5
                0 0 0   51.1335012594458                 0    .30740140464613724  6                 .5                      0  19.72141721671061 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  5
                0 0 1   25.6926952141058  25.6926952141058   .009037378944416884  7  .7142857142857143   .0001336884991126426 19.516632830752297 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 8 2013 40  6
                0 0 1   25.6926952141058  25.6926952141058   .007075393720312551  7  .7142857142857143                      0   19.5045989345409 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 8 2014 40  6
                0 0 0   51.1335012594458                 0  -.030640297978006385  9  .3333333333333333      .6638175908634475 21.927976479003128 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  7
                . 0 0  70.02518891687657                 0   -.12512764119079414  4                .25      .2767302902422342 19.245457871659614 6  .55 .069 .3222  9 0 14               5.25 3  36.5  9.816512 3 2007  8  8
                . 0 0  70.02518891687657                 0   -.25448930573029854  4                 .5      .2807397328055418  18.72083002873732 6  .55 .069 .3222  9 0 14               5.25 3  17.4  10.02787 3 2008  8  8
                . 0 1  70.02518891687657 70.02518891687657     .3705707330267785  3  .6666666666666666     .24585054893164918 18.623545340144307 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.888272 3 2009  8  8
                . 0 1  70.02518891687657 70.02518891687657     .3533600663716814  3  .6666666666666666     .20198778084840072  18.49651588946879 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.891618 3 2010  8  8
                0 1 0  70.02518891687657                 0     .4008137957760124  3  .6666666666666666      .3127123678270168 18.506010034527527 6  .55 .069 .3222  9 0 14 3.7750000953674316 3  17.4   9.98585 3 2011  8  8
                0 1 0  70.02518891687657                 0     .4753136468379278  3  .3333333333333333     .13541087774853464  18.65044122382914 6  .55 .069 .3222  9 0 14               3.78 3  17.4  9.889895 3 2012  8  8
                0 0 1   25.6926952141058  25.6926952141058     .1141677006465095  7  .7142857142857143                      0 19.002790212919827 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40  9
                0 1 1   25.6926952141058  25.6926952141058    .19870996698905427  7  .7142857142857143                      0  19.08075189406916 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40  9
                0 1 1   25.6926952141058  25.6926952141058    .25369558597946673  7  .5714285714285714                      0 19.267051031419648 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40  9
                0 1 1   25.6926952141058  25.6926952141058     .2555807688438279  7  .7142857142857143                      0  19.26592220568617 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40  9
                0 0 1   25.6926952141058  25.6926952141058     .0835950192089205 11  .8181818181818182     .19357678783044466 21.256084041250734 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40 10
                0 1 1   25.6926952141058  25.6926952141058    .07820009191452411 11  .8181818181818182      .3049156674574717 21.509745333536127 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40 10
                0 1 1   25.6926952141058  25.6926952141058     .0728490056960128 11  .8181818181818182      .2565583087065242 21.511495898753047 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40 10
                0 1 1   25.6926952141058  25.6926952141058   .012069577564785232 11  .8181818181818182    .056105610561056105 21.138681275907743 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40 10
                . 0 0 52.896725440806044                 0    .13034454130344542 10                 .5     .45207180760980015 20.982583009896054 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 2 2007 34 11
                . 0 0 52.896725440806044                 0  .0004268032437046522 10                 .5      .4476439790575916   21.2710966598876 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 2 2008 34 11
                . 0 0 52.896725440806044                 0     .2822002049880424 10                 .5      .3997415717138494 20.896315862284084 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 2 2009 34 11
                . 0 0 52.896725440806044                 0    .19573400250941028 10                 .4     .33625162127107655 20.945995382572093 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 2 2010 34 11
                0 1 0 52.896725440806044                 0     .1688639551192146  8                .25      .3408863043914177  21.17605992793267 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 2 2011 34 11
                0 1 0 52.896725440806044                 0    .16314045373438696  8               .375     .28422131147540985 21.112935382739476 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 2 2012 34 11
                0 1 0 52.896725440806044                 0     .1677360219981668  8                 .5     .22787456445993032 21.141519653142122 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 2 2013 34 11
                0 1 0 52.896725440806044                 0    .15155172413793103  8                 .5     .20284526854219948 21.311178360594653 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 2 2014 34 11
                0 0 1   25.6926952141058  25.6926952141058    .11649842200226511  9  .5555555555555556     .08863158149530674 21.274359125620382 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40 12
                0 1 1   25.6926952141058  25.6926952141058    .15230969100258246 10                 .7     .07709788965811677   21.3182096063417 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40 12
                0 1 1   25.6926952141058  25.6926952141058    .06394087228580467  9  .7777777777777778     .20086134895011648 21.622143436406255 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40 12
                0 1 1   25.6926952141058  25.6926952141058     .0993028044413289 10                 .9     .17047510695312867  21.70116893794809 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40 12
                . 0 0  63.47607052896725                 0   -1.5612213930983234  6 .16666666666666666     .34232571347437174 16.829493078024065 6 .443 .272 .1032  9 0 15               7.25 0  72.2   10.6366 4 2009 10 13
                . 0 0  63.47607052896725                 0    -.6418859500777921  6 .16666666666666666     .22117150826586843  17.48679070379101 6 .443 .272 .1032  9 0 15               7.25 0  72.2 10.614058 4 2010 10 13
                0 0 0  63.47607052896725                 0    -1.248350795498642  6 .16666666666666666     .21434390061774491 17.456272768696792 6 .443 .272 .1032  9 0 14               7.25 0  54.3 10.687617 4 2011 10 13
                0 0 1  63.47607052896725 63.47607052896725   -1.5612213930983234  6 .16666666666666666      .3211927156293777 17.493284847361032 6 .443 .272 .1032  9 0 15               7.25 0  67.4  10.61737 4 2012 10 13
                0 0 1  63.47607052896725 63.47607052896725   -1.5612213930983234  5                 .2      .5056035569408475  17.91275541526159 6 .443 .272 .1032  9 0 15               7.25 0  81.9  10.65853 4 2013 10 13
                0 0 1  63.47607052896725 63.47607052896725    1.0250621771570692  5                 .2      .6638175908634475 17.452364649794333 6 .443 .272 .1032  9 0 15               7.25 0  73.2  10.66791 4 2014 10 13
                . 0 0  45.34005037783375                 0    .32650250306813466 11 .18181818181818182     .09258873472864557  20.27066776478885 6 .054 .175 .1576 10 0 14                  5 1  83.2 10.269068 3 2007 12 14
                . 0 0  45.34005037783375                 0     .2406984790706577  7  .2857142857142857      .1975088766489538  20.57284052107584 6 .054 .175 .1576 10 0 13                  5 1  25.4 10.373398 3 2008 12 14
                0 0 1   25.6926952141058  25.6926952141058    .08619728665623073  7  .8571428571428571    .003962604908105812  19.05333454408335 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40 15
                0 1 1   25.6926952141058  25.6926952141058    .08192884188127797  6  .8333333333333334    .004306078004355573   19.0186157399063 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 15
                0 1 1   25.6926952141058  25.6926952141058    .07315022999649333  6  .8333333333333334    .002677592102716304 19.195343393294447 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 15
                0 1 1   25.6926952141058  25.6926952141058    .12412236482374633  6  .8333333333333334   .0017839621800017837 19.410459827483677 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 15
                0 0 0  24.43324937027708                 0    .05099159915129003  7 .42857142857142855                      0  19.44156046061093 6 .015 .223  .155 10 0 15               5.81 1  45.1 10.869863 2 2011 15 16
                0 0 0  24.43324937027708                 0   .042936023821225175  7 .42857142857142855                      0  19.40817181594081 6 .015 .223  .155 10 0 15               5.34 1  48.3 10.804278 2 2012 15 16
                0 0 0  24.43324937027708                 0    .09868531939996629  7 .42857142857142855                      0 19.565014560003004 6 .015 .223  .155 10 0 15               5.34 1  71.1 10.859672 2 2013 15 16
                0 0 0  24.43324937027708                 0    .16039634430285435  7 .42857142857142855                      0  19.76270511444581 6 .015 .223  .155 10 0 15               5.34 1    60 10.924192 2 2014 15 16
                . 0 0   25.6926952141058                 0    .20284646545779347 13  .9230769230769231     .23890333778147937  24.40496769362659 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 4 2007 40 17
                . 0 0   25.6926952141058                 0    .27922450639607393 13  .9230769230769231     .20540996007374396 24.470867021173273 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 4 2008 40 17
                . 0 1   25.6926952141058  25.6926952141058     .2509238831552616 13  .9230769230769231     .21493742548046257 24.682489610790142 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 4 2009 40 17
                . 0 1   25.6926952141058  25.6926952141058    .20582294439196483 10                 .9     .21061284479135053 24.808607763443757 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 4 2010 40 17
                1 1 1   25.6926952141058  25.6926952141058    .19279218156787378 12  .9166666666666666     .19974191436841313 24.822214666576066 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40 17
                1 1 1   25.6926952141058  25.6926952141058    .22238721538679113 11  .9090909090909091     .26898664480184586 24.931458949322366 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 17
                1 1 1   25.6926952141058  25.6926952141058    .10555016405564029 11  .9090909090909091     .08256814052089642 24.443522826752602 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 17
                1 1 1   25.6926952141058  25.6926952141058     .2073994185501266 11  .9090909090909091     .14233762455451304  24.44284421980962 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 17
                . 0 0 52.896725440806044                 0      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 5 2007 34 18
                . 0 0 52.896725440806044                 0    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 5 2008 34 18
                . 0 0 52.896725440806044                 0    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 5 2009 34 18
                . 0 0 52.896725440806044                 0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 5 2010 34 18
                0 1 0 52.896725440806044                 0    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 5 2011 34 18
                0 1 0 52.896725440806044                 0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 5 2012 34 18
                0 1 0 52.896725440806044                 0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 5 2013 34 18
                0 1 0 52.896725440806044                 0     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 5 2014 34 18
                . 0 1    73.551637279597   73.551637279597      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .146 .547 .5314 10 0 15                4.6 1   267 11.054423 5 2007 35 19
                . 0 1    73.551637279597   73.551637279597    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .146 .547 .5314 10 0 15                4.6 1 159.6 11.186087 5 2008 35 19
                . 0 1    73.551637279597   73.551637279597    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .146 .547 .5314 10 0 15                4.6 1 197.3 11.151554 5 2009 35 19
                . 0 0    73.551637279597                 0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .146 .547 .5314 10 0 15                4.6 1 211.5 11.215557 5 2010 35 19
                0 1 1    73.551637279597   73.551637279597    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .146 .547 .5314 10 0 15 3.8329267501831055 1 156.5  11.38507 5 2011 35 19
                0 1 0    73.551637279597                 0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .146 .547 .5314 10 0 15               3.83 1 185.5  11.32857 5 2012 35 19
                0 1 0    73.551637279597                 0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .146 .547 .5314 10 0 15               3.83 1   225 11.346387 5 2013 35 19
                0 1 1    73.551637279597   73.551637279597     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .146 .547 .5314 10 0 15               3.83 1 212.8  11.35258 5 2014 35 19
                1 1 1   25.6926952141058  25.6926952141058     1.568539994052929  9  .8888888888888888      .5416913507109005 24.019398955359957 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 20
                1 1 1   25.6926952141058  25.6926952141058    1.0183696900114811  9  .8888888888888888      .3835263368061858  24.03915947369411 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 20
                1 1 1   25.6926952141058  25.6926952141058    1.3039290240811154  9  .8888888888888888      .5511781338360038 24.694500702006405 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 20
                . 0 1  47.60705289672544 47.60705289672544                     0 14  .2857142857142857      .4721387603395052 23.203072893182277 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33 21
                . 0 1  47.60705289672544 47.60705289672544                     0 15  .3333333333333333     .44079724648612933 23.335624296955046 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33 21
                . 0 1  47.60705289672544 47.60705289672544                     0 14 .35714285714285715     .44844630416189024 23.607329829319212 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33 21
                . 0 1  47.60705289672544 47.60705289672544                     0 15                 .4      .4712944506441859  23.84529184847622 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33 21
                0 1 1  47.60705289672544 47.60705289672544    .09613177735489459 15  .3333333333333333      .4859527399259272 23.914446595250475 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33 21
                0 1 0  47.60705289672544                 0     .0684705116711782 15 .26666666666666666      .5228897638435305 24.023076053860066 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33 21
                0 1 0  47.60705289672544                 0   .053903770886786766 15 .26666666666666666      .4950301484268428 24.096471361256903 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33 21
                0 1 0  47.60705289672544                 0   .055819500773192365 16              .3125      .3132146334981014 24.145960193657146 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33 21
                . 0 0   25.6926952141058                 0    .30042475007062563  8               .875                      0  21.53333657280418 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 3 2007 40 22
                . 0 0   25.6926952141058                 0     .2939462267188115  8               .875                      0 21.666236668464066 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 3 2008 40 22
                . 0 1   25.6926952141058  25.6926952141058      .147517471491316  9  .8888888888888888    .035110128183566985 21.769946381847497 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 3 2009 40 22
                . 0 1   25.6926952141058  25.6926952141058 .00013895598104290293  9  .8888888888888888     .02523613807317569 21.760664205195766 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 3 2010 40 22
                1 1 1   25.6926952141058  25.6926952141058    .07948184456817911  9  .8888888888888888    .023259253530137705  21.80435956784442 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40 22
                1 1 1   25.6926952141058  25.6926952141058    .06854282732048435  9  .7777777777777778    .018979034188900623 21.837801670361387 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40 22
                1 1 1   25.6926952141058  25.6926952141058    .03158613535874386  9  .7777777777777778     .06339045604046585  21.77093459461403 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40 22
                1 1 1   25.6926952141058  25.6926952141058    .03728931619103677 12  .9166666666666666     .13593576206002345   21.6453998634734 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40 22
                . 0 1  47.60705289672544 47.60705289672544    .17532862229864052 21 .19047619047619047      .5602375146987079  24.14623054674291 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33 23
                . 0 1  47.60705289672544 47.60705289672544     .1833457322701381 20                 .2      .5743933748686636 24.154811689940555 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33 23
                . 0 1  47.60705289672544 47.60705289672544    .15215914333244795 19 .21052631578947367       .562068652843642 24.296330463685663 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33 23
                . 0 1  47.60705289672544 47.60705289672544    .12131973663798652 19 .21052631578947367      .5633275408971288  24.24411455546138 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33 23
                0 1 1  47.60705289672544 47.60705289672544     .1587499006389229 20                 .2      .5917730275730636 24.105456510441705 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33 23
                0 1 0  47.60705289672544                 0    .14717047758179727 20                 .2      .5325691588528321 24.370718827150903 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33 23
                0 1 0  47.60705289672544                 0    .08619597813107063 17 .29411764705882354      .5264111879020381  24.38165912396481 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33 23
                0 1 0  47.60705289672544                 0     .1057567826266792 17 .29411764705882354      .5303278812204696 24.241175612719445 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33 23
                0 1 1   25.6926952141058  25.6926952141058   .011837177446811882  7  .8571428571428571                      0 18.851885071238648 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 24
                0 1 1   25.6926952141058  25.6926952141058   .043664205568062345  7  .8571428571428571                      0 19.140503934722233 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 24
                0 1 1   25.6926952141058  25.6926952141058    .38993003155439704  7  .8571428571428571                      0 19.639641663210682 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 24
                . 0 0   81.8639798488665                 0   -.11575687543332563  7 .42857142857142855   .0004540852787041448 19.102544634944273 6 .273 .734 .5554  8 0 15                  5 2  81.7 10.701085 4 2007  3 25
                . 0 0   81.8639798488665                 0   -.16217108767444338  7 .42857142857142855 .000023711103909961036 18.986460689230416 6 .273 .734 .5554  8 0 15                  5 2  32.2  10.78777 4 2008  3 25
                . 0 0   81.8639798488665                 0    -.2626566481885295  7 .42857142857142855                      0 18.808519496566078 6 .273 .734 .5554  8 0 15                  5 2  53.6  10.71177 4 2009  3 25
                . 0 0   81.8639798488665                 0    -.2427820220259946  7 .42857142857142855    .008630859508786884 18.984026447666686 6 .273 .734 .5554  8 0 15                  5 2  55.6 10.700544 4 2010  3 25
                0 1 0   81.8639798488665                 0    -.7486781511171755  7 .42857142857142855    .017781566848339068 18.663522392393784 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 4 2011  3 25
                end

                Comment


                • #23
                  Now, for DCE:

                  Code:
                  * Example generated by -dataex-. To install: ssc install dataex
                  clear
                  input byte(dce lib) double(pdh lpd roe) byte bs double(bi lev siz) byte Polrightinv double(religdiver lingdiver ethnic) byte(democracy autocracy RuleofLaw) double ShRights byte CredRight double mcap float(lngdp industry) int year float idc int firm
                  0 1 40 40    .13901753614769927  8                .75       .299619417073097  19.95318145496617 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 7 2011 40  1
                  1 1 40 40    .08107084043777962  8                .75     .12986203984990596 20.333834498197394 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 7 2012 40  1
                  1 1 40 40   .008992176180817154  9  .7777777777777778    .005835632417413186  21.14589611037559 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 7 2013 40  1
                  1 1 40 40   -1.0012923014881325 10                 .8    .009165150709467969 20.610405042161563 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 7 2014 40  1
                  0 0 40  0    .34868477057972247 10                 .9     .16554628654733944 23.929826136091965 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 5 2007 40  2
                  0 0 40  0      .350237878327766 10                 .9      .2044858496105218 23.963785729872484 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 5 2008 40  2
                  0 1 40 40    .24003909186588482 10                 .9      .1909724770642202 24.028319358055665 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 5 2009 40  2
                  0 1 40 40    .25504151838671413 10                 .9     .14182915506035282  24.12964974529587 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 5 2010 40  2
                  1 1 40 40     .2700163913756147 10                 .9     .14432565789473684 24.176929158511868 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40  2
                  1 1 40 40    .24634146341463414 10                 .9     .14721336639508797 24.245972636005764 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40  2
                  1 1 40 40       .37711155075331 12  .9166666666666666     .21714797403178868 24.165893028371705 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40  2
                  1 1 40 40    .41142419341108366 10                 .9     .26893453145057766  24.21119122211839 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40  2
                  0 0 65  0   -.18876893686969654  7 .42857142857142855      .6084118114732988  18.56520655324707 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 9 2011  3  3
                  0 1 65 65     1.583673469387755  5                 .2      .5000707689041436  18.12731758866535 6 .273 .734 .5554  8 0 15               6.25 2  60.2 10.708646 9 2012  3  3
                  0 0 35  0   -.12192693574327947  5                 .4     .04033156006433255 18.573001730339588 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39  4
                  0 0 35  0    .40572878897751996  6  .3333333333333333     .07934952327165211 18.358094242783555 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39  4
                  0 0 35  0     .4045305514157973  6  .3333333333333333                      0 18.244870546174088 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39  4
                  0 0 35  0     1.162544420753376  6  .3333333333333333                      0 18.128468425414052 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  4
                  0 1 35 35     .3692020662805871  8               .375                      0 19.020511256342612 6 .319 .139 .1211 10 0 15              6.625 4 125.6 10.818758 3 2007 39  5
                  0 1 35 35      .333917025862069  8               .375                      0  19.02224977202266 6 .319 .139 .1211 10 0 14              6.625 4    65 10.747702 3 2008 39  5
                  0 1 35 35     .2050619322873658  8               .375                      0 19.120465844692493 6 .319 .139 .1211 10 0 14              6.625 4    94 10.545605 3 2009 39  5
                  0 0 35  0    .06723386062419838  7 .42857142857142855                      0 19.420429881816602 6 .319 .139 .1211 10 0 14              6.625 4 121.7 10.563853 3 2010 39  5
                  0 0 35  0     .0159496863640485  7  .2857142857142857                      0  19.41071252352884 6 .319 .139 .1211 10 0 15  6.582316875457764 4 118.6 10.627164 3 2011 39  5
                  0 0 35  0     .2388663967611336  5                 .4                      0 19.466595243620027 6 .319 .139 .1211 10 0 14               6.58 4 112.1 10.634364 3 2012 39  5
                  0 0 35  0     .2862049227246709  5                 .4                      0 19.621247755143468 6 .319 .139 .1211 10 0 15               6.58 4 126.1 10.655068 3 2013 39  5
                  0 0 35  0    .30740140464613724  6                 .5                      0  19.72141721671061 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  5
                  0 1 40 40   .009037378944416884  7  .7142857142857143   .0001336884991126426 19.516632830752297 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 8 2013 40  6
                  0 1 40 40   .007075393720312551  7  .7142857142857143                      0   19.5045989345409 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 8 2014 40  6
                  0 0 35  0  -.030640297978006385  9  .3333333333333333      .6638175908634475 21.927976479003128 6 .319 .139 .1211 10 0 15               6.58 4 117.4 10.745314 3 2014 39  7
                  0 0 57  0   -.12512764119079414  4                .25      .2767302902422342 19.245457871659614 6  .55 .069 .3222  9 0 14               5.25 3  36.5  9.816512 3 2007  8  8
                  0 0 57  0   -.25448930573029854  4                 .5      .2807397328055418  18.72083002873732 6  .55 .069 .3222  9 0 14               5.25 3  17.4  10.02787 3 2008  8  8
                  0 1 57 57     .3705707330267785  3  .6666666666666666     .24585054893164918 18.623545340144307 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.888272 3 2009  8  8
                  0 1 57 57     .3533600663716814  3  .6666666666666666     .20198778084840072  18.49651588946879 6  .55 .069 .3222  9 0 14               5.75 3  17.4  9.891618 3 2010  8  8
                  1 0 57  0     .4008137957760124  3  .6666666666666666      .3127123678270168 18.506010034527527 6  .55 .069 .3222  9 0 14 3.7750000953674316 3  17.4   9.98585 3 2011  8  8
                  1 0 57  0     .4753136468379278  3  .3333333333333333     .13541087774853464  18.65044122382914 6  .55 .069 .3222  9 0 14               3.78 3  17.4  9.889895 3 2012  8  8
                  0 1 40 40     .1141677006465095  7  .7142857142857143                      0 19.002790212919827 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40  9
                  1 1 40 40    .19870996698905427  7  .7142857142857143                      0  19.08075189406916 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40  9
                  1 1 40 40    .25369558597946673  7  .5714285714285714                      0 19.267051031419648 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40  9
                  1 1 40 40     .2555807688438279  7  .7142857142857143                      0  19.26592220568617 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40  9
                  0 1 40 40     .0835950192089205 11  .8181818181818182     .19357678783044466 21.256084041250734 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 5 2011 40 10
                  1 1 40 40    .07820009191452411 11  .8181818181818182      .3049156674574717 21.509745333536127 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 5 2012 40 10
                  1 1 40 40     .0728490056960128 11  .8181818181818182      .2565583087065242 21.511495898753047 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 5 2013 40 10
                  1 1 40 40   .012069577564785232 11  .8181818181818182    .056105610561056105 21.138681275907743 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 5 2014 40 10
                  0 0 31  0    .13034454130344542 10                 .5     .45207180760980015 20.982583009896054 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 2 2007 34 11
                  0 0 31  0  .0004268032437046522 10                 .5      .4476439790575916   21.2710966598876 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 2 2008 34 11
                  0 0 31  0     .2822002049880424 10                 .5      .3997415717138494 20.896315862284084 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 2 2009 34 11
                  0 0 31  0    .19573400250941028 10                 .4     .33625162127107655 20.945995382572093 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 2 2010 34 11
                  1 0 31  0     .1688639551192146  8                .25      .3408863043914177  21.17605992793267 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 2 2011 34 11
                  1 0 31  0    .16314045373438696  8               .375     .28422131147540985 21.112935382739476 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 2 2012 34 11
                  1 0 31  0     .1677360219981668  8                 .5     .22787456445993032 21.141519653142122 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 2 2013 34 11
                  1 0 31  0    .15155172413793103  8                 .5     .20284526854219948 21.311178360594653 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 2 2014 34 11
                  0 1 40 40    .11649842200226511  9  .5555555555555556     .08863158149530674 21.274359125620382 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40 12
                  1 1 40 40    .15230969100258246 10                 .7     .07709788965811677   21.3182096063417 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40 12
                  1 1 40 40    .06394087228580467  9  .7777777777777778     .20086134895011648 21.622143436406255 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40 12
                  1 1 40 40     .0993028044413289 10                 .9     .17047510695312867  21.70116893794809 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40 12
                  0 0 68  0   -1.5612213930983234  6 .16666666666666666     .34232571347437174 16.829493078024065 6 .443 .272 .1032  9 0 15               7.25 0  72.2   10.6366 4 2009 10 13
                  0 0 68  0    -.6418859500777921  6 .16666666666666666     .22117150826586843  17.48679070379101 6 .443 .272 .1032  9 0 15               7.25 0  72.2 10.614058 4 2010 10 13
                  0 0 68  0    -1.248350795498642  6 .16666666666666666     .21434390061774491 17.456272768696792 6 .443 .272 .1032  9 0 14               7.25 0  54.3 10.687617 4 2011 10 13
                  0 1 68 68   -1.5612213930983234  6 .16666666666666666      .3211927156293777 17.493284847361032 6 .443 .272 .1032  9 0 15               7.25 0  67.4  10.61737 4 2012 10 13
                  0 1 68 68   -1.5612213930983234  5                 .2      .5056035569408475  17.91275541526159 6 .443 .272 .1032  9 0 15               7.25 0  81.9  10.65853 4 2013 10 13
                  0 1 68 68    1.0250621771570692  5                 .2      .6638175908634475 17.452364649794333 6 .443 .272 .1032  9 0 15               7.25 0  73.2  10.66791 4 2014 10 13
                  0 0 60  0    .32650250306813466 11 .18181818181818182     .09258873472864557  20.27066776478885 6 .054 .175 .1576 10 0 14                  5 1  83.2 10.269068 3 2007 12 14
                  0 0 60  0     .2406984790706577  7  .2857142857142857      .1975088766489538  20.57284052107584 6 .054 .175 .1576 10 0 13                  5 1  25.4 10.373398 3 2008 12 14
                  0 1 40 40    .08619728665623073  7  .8571428571428571    .003962604908105812  19.05333454408335 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40 15
                  1 1 40 40    .08192884188127797  6  .8333333333333334    .004306078004355573   19.0186157399063 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 15
                  1 1 40 40    .07315022999649333  6  .8333333333333334    .002677592102716304 19.195343393294447 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 15
                  1 1 40 40    .12412236482374633  6  .8333333333333334   .0017839621800017837 19.410459827483677 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 15
                  0 0 28  0    .05099159915129003  7 .42857142857142855                      0  19.44156046061093 6 .015 .223  .155 10 0 15               5.81 1  45.1 10.869863 2 2011 15 16
                  0 0 28  0   .042936023821225175  7 .42857142857142855                      0  19.40817181594081 6 .015 .223  .155 10 0 15               5.34 1  48.3 10.804278 2 2012 15 16
                  0 0 28  0    .09868531939996629  7 .42857142857142855                      0 19.565014560003004 6 .015 .223  .155 10 0 15               5.34 1  71.1 10.859672 2 2013 15 16
                  0 0 28  0    .16039634430285435  7 .42857142857142855                      0  19.76270511444581 6 .015 .223  .155 10 0 15               5.34 1    60 10.924192 2 2014 15 16
                  0 0 40  0    .20284646545779347 13  .9230769230769231     .23890333778147937  24.40496769362659 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 4 2007 40 17
                  0 0 40  0    .27922450639607393 13  .9230769230769231     .20540996007374396 24.470867021173273 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 4 2008 40 17
                  0 1 40 40     .2509238831552616 13  .9230769230769231     .21493742548046257 24.682489610790142 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 4 2009 40 17
                  0 1 40 40    .20582294439196483 10                 .9     .21061284479135053 24.808607763443757 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 4 2010 40 17
                  1 1 40 40    .19279218156787378 12  .9166666666666666     .19974191436841313 24.822214666576066 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 4 2011 40 17
                  1 1 40 40    .22238721538679113 11  .9090909090909091     .26898664480184586 24.931458949322366 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 17
                  1 1 40 40    .10555016405564029 11  .9090909090909091     .08256814052089642 24.443522826752602 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 17
                  1 1 40 40     .2073994185501266 11  .9090909090909091     .14233762455451304  24.44284421980962 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 17
                  0 0 31  0      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .541 .167   .06 10 0 16               6.25 1 120.1 10.884142 5 2007 34 18
                  0 0 31  0    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .541 .167   .06 10 0 16               6.25 1  66.1  10.92858 5 2008 34 18
                  0 0 31  0    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .541 .167   .06 10 0 16               6.25 1 103.8 10.740887 5 2009 34 18
                  0 0 31  0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .541 .167   .06 10 0 16               6.25 1 120.1  10.86046 5 2010 34 18
                  1 0 31  0    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .541 .167   .06 10 0 16               6.25 1  95.6 10.995294 5 2011 34 18
                  1 0 31  0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .541 .167   .06 10 0 16               6.25 1 106.2 10.953155 5 2012 34 18
                  1 0 31  0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .541 .167   .06 10 0 16               6.25 1   128 11.006805 5 2013 34 18
                  1 0 31  0     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .541 .167   .06 10 0 15               6.25 1 135.2 10.988338 5 2014 34 18
                  0 1 34 34      .289404033950899  8                  1     .06896551724137931 24.157285298975793 6 .146 .547 .5314 10 0 15                4.6 1   267 11.054423 5 2007 35 19
                  0 1 34 34    .28132281770926687  8                  1     .06054669841174166 24.225243259892284 6 .146 .547 .5314 10 0 15                4.6 1 159.6 11.186087 5 2008 35 19
                  0 1 34 34    .20913705583756345  8                  1     .06254319281271596 24.270812114943702 6 .146 .547 .5314 10 0 15                4.6 1 197.3 11.151554 5 2009 35 19
                  0 0 34  0    .16502781731142452  8                  1     .03138173302107728 24.314945827683214 6 .146 .547 .5314 10 0 15                4.6 1 211.5 11.215557 5 2010 35 19
                  1 1 34 34    .19337659157688541  8                  1     .08149213075060532 24.403306342393144 6 .146 .547 .5314 10 0 15 3.8329267501831055 1 156.5  11.38507 5 2011 35 19
                  1 0 34  0    .15476326951736788  8                  1     .15353576523334012 24.616513687048222 6 .146 .547 .5314 10 0 15               3.83 1 185.5  11.32857 5 2012 35 19
                  1 0 34  0    .14702207413577675  8                  1     .15749833555259654  24.59579929308808 6 .146 .547 .5314 10 0 15               3.83 1   225 11.346387 5 2013 35 19
                  1 1 34 34     .1528397264347309  8                  1      .1635099603369134 24.527213533888023 6 .146 .547 .5314 10 0 15               3.83 1 212.8  11.35258 5 2014 35 19
                  1 1 40 40     1.568539994052929  9  .8888888888888888      .5416913507109005 24.019398955359957 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 20
                  1 1 40 40    1.0183696900114811  9  .8888888888888888      .3835263368061858  24.03915947369411 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 20
                  1 1 40 40    1.3039290240811154  9  .8888888888888888      .5511781338360038 24.694500702006405 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 20
                  0 1 57 57                     0 14  .2857142857142857      .4721387603395052 23.203072893182277 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33 21
                  0 1 57 57                     0 15  .3333333333333333     .44079724648612933 23.335624296955046 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33 21
                  0 1 57 57                     0 14 .35714285714285715     .44844630416189024 23.607329829319212 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33 21
                  0 1 57 57                     0 15                 .4      .4712944506441859  23.84529184847622 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33 21
                  1 1 57 57    .09613177735489459 15  .3333333333333333      .4859527399259272 23.914446595250475 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33 21
                  1 0 57  0     .0684705116711782 15 .26666666666666666      .5228897638435305 24.023076053860066 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33 21
                  1 0 57  0   .053903770886786766 15 .26666666666666666      .4950301484268428 24.096471361256903 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33 21
                  1 0 57  0   .055819500773192365 16              .3125      .3132146334981014 24.145960193657146 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33 21
                  0 0 40  0    .30042475007062563  8               .875                      0  21.53333657280418 6 .258 .353 .4901 10 0 14               7.25 1 137.6 10.780247 3 2007 40 22
                  0 0 40  0     .2939462267188115  8               .875                      0 21.666236668464066 6 .258 .353 .4901 10 0 14               7.25 1  78.7 10.787275 3 2008 40 22
                  0 1 40 40      .147517471491316  9  .8888888888888888    .035110128183566985 21.769946381847497 6 .258 .353 .4901 10 0 14               7.25 1 104.6 10.757945 3 2009 40 22
                  0 1 40 40 .00013895598104290293  9  .8888888888888888     .02523613807317569 21.760664205195766 6 .258 .353 .4901 10 0 14               7.25 1 115.5 10.786717 3 2010 40 22
                  1 1 40 40    .07948184456817911  9  .8888888888888888    .023259253530137705  21.80435956784442 6 .258 .353 .4901 10 0 14               7.25 1 100.8  10.81559 3 2011 40 22
                  1 1 40 40    .06854282732048435  9  .7777777777777778    .018979034188900623 21.837801670361387 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 3 2012 40 22
                  1 1 40 40    .03158613535874386  9  .7777777777777778     .06339045604046585  21.77093459461403 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 3 2013 40 22
                  1 1 40 40    .03728931619103677 12  .9166666666666666     .13593576206002345   21.6453998634734 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 3 2014 40 22
                  0 1 57 57    .17532862229864052 21 .19047619047619047      .5602375146987079  24.14623054674291 6 .106 .438 .4165 10 0 14               4.75 2 121.7 10.395406 5 2007 33 23
                  0 1 57 57     .1833457322701381 20                 .2      .5743933748686636 24.154811689940555 6 .106 .438 .4165 10 0 14               4.75 2    58  10.47951 5 2008 33 23
                  0 1 57 57    .15215914333244795 19 .21052631578947367       .562068652843642 24.296330463685663 6 .106 .438 .4165 10 0 14               4.75 2  95.7 10.383843 5 2009 33 23
                  0 1 57 57    .12131973663798652 19 .21052631578947367      .5633275408971288  24.24411455546138 6 .106 .438 .4165 10 0 14               4.75 2  81.8  10.33319 5 2010 33 23
                  1 1 57 57     .1587499006389229 20                 .2      .5917730275730636 24.105456510441705 6 .106 .438 .4165 10 0 14               4.75 2  69.3  10.36829 5 2011 33 23
                  1 0 57  0    .14717047758179727 20                 .2      .5325691588528321 24.370718827150903 6 .106 .438 .4165 10 0 14               7.25 2  74.5 10.259832 5 2012 33 23
                  1 0 57  0    .08619597813107063 17 .29411764705882354      .5264111879020381  24.38165912396481 6 .106 .438 .4165 10 0 14               4.75 2    82 10.282267 5 2013 33 23
                  1 0 57  0     .1057567826266792 17 .29411764705882354      .5303278812204696 24.241175612719445 6 .106 .438 .4165 10 0 15               4.75 2  72.2  10.29553 5 2014 33 23
                  1 1 40 40   .011837177446811882  7  .8571428571428571                      0 18.851885071238648 6 .258 .353 .4901 10 0 14               7.25 1 115.6 10.848366 4 2012 40 24
                  1 1 40 40   .043664205568062345  7  .8571428571428571                      0 19.140503934722233 6 .258 .353 .4901 10 0 14               7.25 1   144  10.87402 4 2013 40 24
                  1 1 40 40    .38993003155439704  7  .8571428571428571                      0 19.639641663210682 6 .258 .353 .4901 10 0 14               7.25 1 151.4  10.90777 4 2014 40 24
                  0 0 65  0   -.11575687543332563  7 .42857142857142855   .0004540852787041448 19.102544634944273 6 .273 .734 .5554  8 0 15                  5 2  81.7 10.701085 4 2007  3 25
                  0 0 65  0   -.16217108767444338  7 .42857142857142855 .000023711103909961036 18.986460689230416 6 .273 .734 .5554  8 0 15                  5 2  32.2  10.78777 4 2008  3 25
                  0 0 65  0    -.2626566481885295  7 .42857142857142855                      0 18.808519496566078 6 .273 .734 .5554  8 0 15                  5 2  53.6  10.71177 4 2009  3 25
                  0 0 65  0    -.2427820220259946  7 .42857142857142855    .008630859508786884 18.984026447666686 6 .273 .734 .5554  8 0 15                  5 2  55.6 10.700544 4 2010  3 25
                  1 0 65  0    -.7486781511171755  7 .42857142857142855    .017781566848339068 18.663522392393784 6 .273 .734 .5554  8 0 15               6.25 2  43.5  10.77275 4 2011  3 25
                  end


                  Comment


                  • #24
                    Hello, I did the graph for dce and csr, no overlap.

                    Click image for larger version

Name:	Graph box lib over(csr).png
Views:	1
Size:	40.0 KB
ID:	1431430


                    Comment


                    • #25
                      After playing around a bit with the dce model, my conclusion is that you have the following problems:

                      dce is always zero in all years before 2011. So you cannot include the indicators for years before 2011 in your model, and you should consider excluding all the data from those years as well..

                      Even more important, I think, there is a very strong, nearly perfect, multicolinearity relationship in your data involving variables lib lingdiver lpd ethnic pdh democracy lngdp bi siz bs RuleofLaw and religdiver (R2 = 0.97). By including all of these variables in your model, you are ending up in a situation where a great deal of the explanatory power these variables are competing for is ending up stacked into a few variables that end up with absurdly large coefficients. You will need to remove some of these variables, and possibly some of the others from the model, using a more compact set of variables that are more independent of each other.

                      Given the pervasiveness of this problem in this model, I'm pretty sure it's affecting the others as well. Here's what I would do. I would rank my predictor variables in order of importance with respect to your research goals (which may not be the same as their order of importance as predictors of your outcomes in the real world). I would start building up my model one variable at a time. Begin with just the most important predictor. See if the model produces sensible results. If it does, try adding the next most important one and run it again. Keep going until adding more variables wrecks things. Then stick with the last model that produced sensible results.

                      Comment


                      • #26
                        Hello Clyde,

                        Thank you so much for the analysis, it is absolutely clear. I really appreciate your help.
                        I would like to ask you a couple more question to have in consideration for the future.
                        How did you get the R2 =0.97? I never got one in the outcome. I didn´t know that a high R2 could be considerer as an indicator of multicolinearity, I know VIF but I didn´t used it. What is the difference?
                        Thank you very very much again.
                        best regards !!!

                        Comment


                        • #27
                          Hello Clyde,

                          I forgot to say that I checked the data of DCE and I have 7934 zeros and 264 ones observations between 2007 and 2010 and
                          between 2011 and 2014
                          I have 8947 one observations and 5922 zeros . Do you recommend me to drop those observations anyway?
                          Thank you !!

                          Comment


                          • #28
                            I got the R2 by just doing -regress lib lingdiver lpd ethnic pdh democracy lngdp bi siz bs RuleofLaw religdiver- I chose those variables after looking at some scatter plots and also seeing which variables were proving problematic.

                            The distribution of DCE between 2007 and 2010 that you show is pretty lopsided, but I think there are enough ones there to still include those years. But if you get ridiculous coefficients for those years, then drop them.

                            Comment


                            • #29
                              Thank you Clyde, I am going to do what you recommend me. Thank you very much for all your help and thank you again.
                              best regards

                              Comment


                              • #30
                                Hello Clyde again, I am writing you because I am trying to learn all the analysis you did. Once you said post #20 "Run commands like -graph box lib, over(csr)- and see if the distributions are separated, or show only a very small amount of overlap. If so, that variable is not usable". When I did that, I had no overlap, that is ok or should I have an overlap to be ok?

                                On the other hand, you told me post #20 "the one observation where csr = 1 has values for these variables that are either just at the boundary of or outside the range of the values of these variables when csr = 0" and at post #18 "
                                And some of the coefficients of the other variables, including some of the industry indicators, are still in the outlandish range." my question is, when I can consider a coefficient in the outlanding range or just in the boundary? How can I test that? I am asking you because in a logit regression with CSR I had a constant of 52.364 and until your help I didn´t realise that could be bad and I would like to learn about that too.

                                Thank you very much for your help and patience.

                                Comment

                                Working...
                                X