Announcement

Collapse
No announcement yet.
X
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
  • #1

    Adjustments to panel dataset

    Hey all,

    I am conducting a panel study for my master's thesis. I have two adjustments I want to make to my dataset, what is the best way to let stata do this?

    Firstly, I want to exclude firm observations with no data of 2 consecutive years: So in this case the observations of 2010 and 2012 should be dropped.
    Firm Year
    1 2010
    1 2012
    1 2014
    1 2015
    1 2016

    Secondly, I want to exclude firm observations in their first year of going public. So in this case the observation for firm 2 in 2010 should be dropped for it goes public in 2010 (IPO date variable).
    Firm Year X IPO date
    1 2011 . 1-1-1988
    1 2012 . 1-1-1988
    2 2010 . 5-6-2010
    2 2011 . 5-6-2010
    2 2012 . 5-6-2010
    Thank you.
    Tags: None
  • #2
    Please edit this question using dataex to show us what your real data look like.
    • 1 like

    Comment

    • #3
      Joeri:
      as an aside to Jared's recommendation that I fully share, please consider that deleting observations with missing values is a risky habit unless you have diagnosed the reason(s) why they're missing and considered how to deal with them (if feasible).
      Otherwise, you my end up with a subsample of (complete) observations whose relationship with the original dataset is tenuous at best.
      Kind regards,
      Carlo
      (StataNow 18.5)

      Comment

      • #4
        Dear Jared and Carlo,

        Thank you for your reply, hereby I sent you the dataex output. The variables of interest are fyear and ipodate.
        Regarding the rationale of deleting this observations, I have to be able to compare observations across years. By formulating these adjustments I followed prior researchers that conducted similar analyses on similar data.
        Code:
        * Example generated by -dataex-. For more info, type help dataex
clear
input long(gvkey datadate) int fyear str4 indfmt str1(consol popsrc) str3 datafmt str8 tic str9 cusip str30 conm str3 curcd float(at cstk dt ebit intan ni re sale wcap) long cik str1 costat int sic str3 spcsrc long ipodate
1004 20120531 2011 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"  2195.653    44.849   791.726   142.36  432.634   67.723  486.582 2074.498   590.046    1750 "A" 5080 "B"  19880101
1004 20130531 2012 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    2136.9      44.7     708.6    136.6    428.1       55    542.4   2167.1     644.7    1750 "A" 5080 "B"  19880101
1004 20140531 2013 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    2199.5      44.7       634    142.6    440.1     72.9    616.7     2035     714.8    1750 "A" 5080 "B"  19880101
1004 20150531 2014 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"      1515      44.9       154     -8.6    172.4     10.2    603.9   1594.3     542.1    1750 "A" 5080 "B"  19880101
1004 20160531 2015 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    1442.1      44.9     148.1     66.1    168.6     47.7    637.2   1662.6     544.1    1750 "A" 5080 "B"  19880101
1004 20170531 2016 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    1504.1      45.2     157.3     77.2    162.6     56.5      688   1767.6     553.4    1750 "A" 5080 "B"  19880101
1004 20180531 2017 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    1524.7      45.3     177.2       86    157.1     15.6    701.2   1748.3     609.4    1750 "A" 5080 "B"  19880101
1004 20190531 2018 "INDL" "C" "D" "STD" "AIR"   "361105"    "AAR CORP"                     "USD"    1517.2      45.3     141.7    110.7    145.6      7.5    668.9   2051.8       595    1750 "A" 5080 "B"  19880101
1045 20121231 2012 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     23510       341      8535      494      869    -1876   -12442    24855     -2232    6201 "A" 4512 "C"         .
1045 20131231 2013 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     42278         3     16799     1935     6397    -1834   -13328    26712       517    6201 "A" 4512 "C"         .
1045 20141231 2014 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     43771         7     17904     5073     6331     2882   -13121    42650     -1323    6201 "A" 4512 "C"         .
1045 20151231 2015 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     48415         6     20561     7284     6340     7610    -5962    40990     -3620    6201 "A" 4512 "C"         .
1045 20161231 2016 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     51274         5     24344     6007     6264     2676    -3443    40180     -3548    6201 "A" 4512 "C"         .
1045 20171231 2017 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     51396         5     25065     4792     6294     1919    -1793    42207     -5818    6201 "A" 4512 "C"         .
1045 20181231 2018 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     60580         5     34029     3449     6228     1412    -5138    44541     -9459    6201 "A" 4512 "C"         .
1045 20191231 2019 "INDL" "C" "D" "STD" "AAL"   "02376R102" "AMERICAN AIRLINES GROUP INC"  "USD"     59995         4     33444     3706     6175     1686    -4067    45768    -10105    6201 "A" 4512 "C"         .
1050 20121231 2012 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"    94.104      .171         0   16.683   24.357    10.85    7.379  135.052    36.781    3197 "A" 3564 "C"         .
1050 20131231 2013 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   348.536      .257    89.082   18.996  197.452    6.557   10.939  197.317    65.439    3197 "A" 3564 "C"         .
1050 20141231 2014 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   414.365      .264   112.428   24.332  245.711   13.077    12.43  263.217    67.616    3197 "A" 3564 "C"         .
1050 20151231 2015 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   598.819       .34   177.328   28.651  321.457   -5.602   -4.105  367.422    80.283    3197 "A" 3564 "C"         .
1050 20161231 2016 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   498.634      .343   131.664   37.316  252.923  -38.218  -54.783  417.011     66.62    3197 "A" 3564 "C"         .
1050 20171231 2017 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   438.549      .347   122.833   11.977  236.598   -3.029  -61.592  345.051    66.091    3197 "A" 3564 "C"         .
1050 20181231 2018 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   392.582      .349    82.791   14.062  206.373   -7.121  -72.842  337.339    56.979    3197 "A" 3564 "C"         .
1050 20191231 2019 "INDL" "C" "D" "STD" "CECE"  "125141101" "CECO ENVIRONMENTAL CORP"      "USD"   408.637      .353    87.083   19.622  197.594   17.707  -60.849  341.869     64.31    3197 "A" 3564 "C"         .
1062 20121130 2012 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   468.013     19.29         .        .        0        .   445.83        .         . 1230869 "A" 6799 ""          .
1062 20121130 2012 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   468.013     19.29         0    1.722        0 -152.257   445.83    5.817         . 1230869 "A" 6799 ""          .
1062 20131130 2013 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   252.142     19.29         .        .        0        .  229.684        .         . 1230869 "A" 6799 ""          .
1062 20131130 2013 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   252.142     19.29         0     .371        0 -212.673  229.684    4.481         . 1230869 "A" 6799 ""          .
1062 20141130 2014 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   223.333     19.29         0   -1.458        0  -27.775  201.137    2.219         . 1230869 "A" 6799 ""          .
1062 20141130 2014 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   223.333     19.29         .        .        0        .  201.137        .         . 1230869 "A" 6799 ""          .
1062 20151130 2015 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"    162.35     19.29         0   -1.713        0  -60.285  140.081    1.666         . 1230869 "A" 6799 ""          .
1062 20151130 2015 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"    162.35     19.29         .        .        0        .  140.081        .         . 1230869 "A" 6799 ""          .
1062 20161130 2016 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"    245.02     19.29         0   -2.003        0   83.257  222.566     1.21         . 1230869 "A" 6799 ""          .
1062 20161130 2016 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"    245.02     19.29         .        .        0        .  222.566        .         . 1230869 "A" 6799 ""          .
1062 20171130 2017 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   245.562     19.29         .        .        0        .  223.539        .         . 1230869 "A" 6799 ""          .
1062 20171130 2017 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   245.562     19.29         0    -1.67        0    1.744  223.539    1.408         . 1230869 "A" 6799 ""          .
1062 20181130 2018 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   196.072     19.29         0   -1.408        0  -48.789  174.171    1.629         . 1230869 "A" 6799 ""          .
1062 20181130 2018 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   196.072     19.29         .        .        0        .  174.171        .         . 1230869 "A" 6799 ""          .
1062 20191130 2019 "FS"   "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   286.612     19.29         .        .        0        .  265.216        .         . 1230869 "A" 6799 ""          .
1062 20191130 2019 "INDL" "C" "D" "STD" "ASA"   "G3156P103" "ASA GOLD AND PRECIOUS METALS" "USD"   286.612     19.29         0   -1.173        0   91.431  265.216    2.371         . 1230869 "A" 6799 ""          .
1072 20120331 2011 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2468.012     1.764         0  275.551  240.928  152.805 1857.503 1545.254  1430.072  859163 "I" 3670 "B-" 19730301
1072 20130331 2012 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2601.995     1.764         0  146.405  273.204  -64.312 1718.739   1414.4  1614.656  859163 "I" 3670 "B-" 19730301
1072 20140331 2013 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2384.988     1.764         0  159.164  280.786  127.037 1797.982 1442.604  1606.789  859163 "I" 3670 "B-" 19730301
1072 20150331 2014 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2459.015     1.764         0  212.749  275.638  225.871 1881.811 1353.228  1478.243  859163 "I" 3670 "B-" 19730301
1072 20160331 2015 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2409.819     1.764         0  169.302  270.605  101.535 1935.144 1195.529  1506.589  859163 "I" 3670 "B-" 19730301
1072 20170331 2016 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2477.413     1.764         0  202.047  266.701  125.785 1966.122 1312.661  1620.337  859163 "I" 3670 "B-" 19730301
1072 20180331 2017 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2672.766     1.764         0  182.534   444.91     4.91 1983.724 1562.474  1407.161  859163 "I" 3670 "B-" 19730301
1072 20190331 2018 "INDL" "C" "D" "STD" "AVX"   "2444107"   "AVX CORP"                     "USD"  2813.278     1.764         0  314.079  435.619  271.813  2117.09  1791.79  1470.542  859163 "I" 3670 "B-" 19730301
1075 20121231 2012 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 13379.615  2466.923         .  851.755        .  381.542 1510.094 3301.804   -77.816  764622 "A" 4911 "A"         .
1075 20131231 2013 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 13508.686  2491.558         .  846.323        .  406.074  1707.22 3454.628  -575.035  764622 "A" 4911 "A"         .
1075 20141231 2014 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 14313.532   2512.97         .  811.242        .  397.595 1857.924 3491.632  -585.708  764622 "A" 4911 "A"         .
1075 20151231 2015 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 15028.258  2541.668         .  854.602        .  437.257 2048.055 3495.443  -551.801  764622 "A" 4911 "A"         .
1075 20161231 2016 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 16004.253   2596.03         .  855.984   90.022  442.034 2211.725 3498.682  -470.727  764622 "A" 4911 "A"         .
1075 20171231 2017 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 17019.082  2614.805         .  934.427  257.189  488.456 2397.509 3565.296  -181.564  764622 "A" 4911 "A"         .
1075 20181231 2018 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 17664.201  2634.265         .  773.687  262.902  511.047 2593.475 3691.247  -723.973  764622 "A" 4911 "A"         .
1075 20191231 2019 "INDL" "C" "D" "STD" "PNW"   "723484101" "PINNACLE WEST CAPITAL CORP"   "USD" 18479.246  2659.561         .   671.96  290.564   538.32 2780.514 3471.209 -1048.335  764622 "A" 4911 "A"         .
1076 20121231 2012 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  1812.929    45.376   141.528    254.6  240.221  173.043 1086.963 2222.588         . 1808834 "A" 6141 "B"         .
1076 20131231 2013 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  1827.176    45.376   142.704  221.959  242.716  120.666 1202.155 2234.631         . 1808834 "A" 6141 "B"         .
1076 20141231 2014 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  2456.844    45.376   606.082      176  828.141   78.233 1274.143 2725.239         . 1808834 "A" 6141 "B"         .
1076 20151231 2015 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  2658.875    45.376    610.45  244.117  815.387  135.709 1402.603 3179.756         . 1808834 "A" 6141 "B"         .
1076 20161231 2016 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  2615.736    45.376   497.829  260.131  774.395  139.283 1534.452 3207.716         . 1808834 "A" 6141 "B"         .
1076 20171231 2017 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  2692.264    45.376   368.798  275.534  858.499  292.536 1820.298 3383.708         . 1808834 "A" 6141 "B"         .
1076 20181231 2018 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"  2826.692    45.376   424.752  290.087   961.77   196.21 2004.257 3828.923         . 1808834 "A" 6141 "B"         .
1076 20191231 2019 "INDL" "C" "D" "STD" "PRG"   "74319R101" "PROG HOLDINGS INC"            "USD"    3297.8    45.376   710.416  313.931  927.378   31.472 2029.594 3947.656         . 1808834 "A" 6141 "B"         .
1078 20121231 2012 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD" 67234.945 11754.552 18394.125 9783.515 24362.41  5962.92 20557.32 39873.91 18042.406    1800 "A" 3845 "B"         .
1078 20131231 2013 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     42953     12048      3397     2674    15507     2576    19967    21848      9740    1800 "A" 3845 "B"         .
1078 20141231 2014 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     41275     12383      3463     2927    16265     2284    17821    20247      4729    1800 "A" 3845 "B"         .
1078 20151231 2015 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     41247     12734      5874     3372    15200     4423    19099    20405      4969    1800 "A" 3845 "B"         .
1078 20161231 2016 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     52666     13027     20684     3622    12222     1400    18302    20853     20116    1800 "A" 3845 "B"         .
1078 20171231 2017 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     76250     23206     27718     3996    45493      477    17916    27390     11235    1800 "A" 3845 "B"         .
1078 20181231 2018 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     67173     23512     19366     4284    42196     2368    16974    30578      5620    1800 "A" 3845 "B"         .
1078 20191231 2019 "INDL" "C" "D" "STD" "ABT"   "2824100"   "ABBOTT LABORATORIES"          "USD"     67887     23853     18898     5041    40220     3687    17382    31904      4804    1800 "A" 3845 "B"         .
1084 20121231 2012 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .237       .08         0   -1.664     .007   -1.664  -29.935        0    -3.295    1961 "A" 7370 "C"  19980810
1084 20131231 2013 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .328      .093         0    -3.97     .007   -4.128  -34.161        0    -4.009    1961 "A" 7370 "C"  19980810
1084 20141231 2014 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .028      .097         0    -.816        0    -.983   -36.11        0    -4.604    1961 "A" 7370 "C"  19980810
1084 20151231 2015 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .026      .121         0    -.769        0   -4.037  -40.172        0    -5.142    1961 "A" 7370 "C"  19980810
1084 20161231 2016 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .093       .21         0    -.829        0   -1.133  -40.161        0    -4.779    1961 "A" 7370 "C"  19980810
1084 20171231 2017 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"      .184      .245       .75   -3.023        0   -2.747  -42.919        0    -4.226    1961 "A" 7370 "C"  19980810
1084 20181231 2018 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"     3.846      .057       .75   -2.893        0    1.754  -41.165        0     -.595    1961 "A" 7370 "C"  19980810
1084 20191231 2019 "INDL" "C" "D" "STD" "WDDD"  "98159J200" "WORLDS INC"                   "USD"     1.774      .057         0   -1.154        0   -1.234  -42.399        0    -1.648    1961 "A" 7370 "C"  19980810
1094 20120630 2012 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"    299.28      .269    45.765   27.011   78.746   16.981  103.663  444.388   118.328    2034 "I" 5160 "D"         .
1094 20130630 2013 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"    323.43      .278    32.069    37.66   74.357   22.328  121.517   499.69   128.393    2034 "I" 5160 "D"         .
1094 20140630 2014 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"   467.984      .288   105.501   47.516  154.471       29   146.14  510.179   157.831    2034 "I" 5160 "D"         .
1094 20150630 2015 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"   489.774      .292   110.157   53.827  146.867   33.483  160.112  546.951    185.31    2034 "I" 5160 "D"         .
1094 20160630 2016 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"   540.778      .296   118.789   56.954  146.942   34.766  188.479  558.524   253.755    2034 "I" 5160 "D"         .
1094 20170630 2017 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"  1038.185      .301   353.666   44.426  522.051   11.376  190.568  638.318    248.75    2034 "I" 5160 "D"         .
1094 20180630 2018 "INDL" "C" "D" "STD" "ACETQ" "4446100"   "ACETO CORP"                   "USD"   767.024      .308   317.398  -17.187  236.485 -316.121 -127.622  711.359   200.109    2034 "I" 5160 "D"         .
1096 20121231 2012 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD"  4386.182   113.851  1562.165  201.928   24.488  389.443 1934.437  415.917  -336.196       . "A" 6510 "B"         .
1096 20131231 2013 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD"  5452.995   112.238   2259.09  219.646   24.488  286.392 2217.734  516.882  -540.944       . "A" 6510 "B"         .
1096 20141231 2014 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD"  7993.684    110.21  3786.712  256.818   24.488  136.703 2388.395  566.326  -415.827       . "A" 6510 "B"         .
1096 20151231 2015 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD"  8602.132   108.097  4031.711  424.899   41.611   80.542 2589.627  883.559  -507.294       . "A" 6510 "B"         .
1096 20161231 2016 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD"  9588.078   107.601  4764.499  433.919   38.392  172.745 2755.211  921.976  -888.497       . "A" 6510 "B"         .
1096 20171231 2017 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD" 10111.986   106.952  4870.756  458.146   64.393   310.12 2975.721 1113.774  -919.357       . "A" 6510 "B"         .
1096 20181231 2018 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD" 11082.758   102.436  5198.151  451.277   64.237  319.851  3328.93 1157.878 -1117.201       . "A" 6510 "B"         .
1096 20191231 2019 "INDL" "C" "D" "STD" "MRCBF" "617577101" "MORGUARD CORP"                "CAD" 11703.084   102.426   5771.37  474.645   60.989  186.939  3446.48 1192.973  -937.989       . "A" 6510 "B"         .
1097 20121231 2012 "INDL" "C" "D" "STD" "ACMTA" "4616207"   "ACMAT CORP  -CL A"            "USD"    85.769     1.166     7.214    1.829     1.92    1.211   34.504    6.003         .    2062 "A" 6351 "B"         .
1097 20131231 2013 "INDL" "C" "D" "STD" "ACMTA" "4616207"   "ACMAT CORP  -CL A"            "USD"    77.654     1.072     7.236    1.604     1.92     .999   32.224    5.547         .    2062 "A" 6351 "B"         .
1097 20141231 2014 "INDL" "C" "D" "STD" "ACMTA" "4616207"   "ACMAT CORP  -CL A"            "USD"    75.698     1.006     8.055    1.489     1.92     .888   31.541    5.102         .    2062 "A" 6351 "B"         .
1097 20151231 2015 "INDL" "C" "D" "STD" "ACMTA" "4616207"   "ACMAT CORP  -CL A"            "USD"    73.518      .941     9.586    1.214     1.92     .727    29.54    3.857         .    2062 "A" 6351 "B"         .
1097 20161231 2016 "INDL" "C" "D" "STD" "ACMTA" "4616207"   "ACMAT CORP  -CL A"            "USD"    72.257      .865     8.246     1.31     1.92     .766   28.958    4.239         .    2062 "A" 6351 "B"         .
end

        Comment

        • #5
          Joeri:
          things are trickier than expected here, as some entries seem duplicated:
          Code:
          . list in 25/26

     +----------------------------------------------------------------------------------------------------------------------------------+
 25. | gvkey | datadate | fyear | indfmt | consol | popsrc | datafmt | tic |     cusip |                         conm | curcd |      at |
     |  1062 | 20121130 |  2012 |     FS |      C |      D |     STD | ASA | G3156P103 | ASA GOLD AND PRECIOUS METALS |   USD | 468.013 |
     |-------+--------------------------------------------------------------------------------------------------------------------------|
     |  cstk | dt |  ebit | intan  |       ni  |     re  |  sale  | wcap  |     cik  | costat  |  sic  | spcsrc  | ipodate  | warnin~O  |
     | 19.29 |  . |     . |     0  |        .  | 445.83  |     .  |    .  | 1230869  |      A  | 6799  |         |       .  |        .  |
     +----------------------------------------------------------------------------------------------------------------------------------+

     +----------------------------------------------------------------------------------------------------------------------------------+
 26. | gvkey | datadate | fyear | indfmt | consol | popsrc | datafmt | tic |     cusip |                         conm | curcd |      at |
     |  1062 | 20121130 |  2012 |   INDL |      C |      D |     STD | ASA | G3156P103 | ASA GOLD AND PRECIOUS METALS |   USD | 468.013 |
     |-------+--------------------------------------------------------------------------------------------------------------------------|
     |  cstk | dt |  ebit | intan  |       ni  |     re  |  sale  | wcap  |     cik  | costat  |  sic  | spcsrc  | ipodate  | warnin~O  |
     | 19.29 |  0 | 1.722 |     0  | -152.257  | 445.83  | 5.817  |    .  | 1230869  |      A  | 6799  |         |       .  |        .  |
     +----------------------------------------------------------------------------------------------------------------------------------+

.
          Kind regards,
          Carlo
          (StataNow 18.5)

          Comment

          Previous Next
          Working...
          X