Announcement

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

    Reshape Data

    I have data in this form

    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str23 variablename int year float(alconincswxalc argenxseenxtbrargx astellaspharmainctse4503 astrazenecaplclseazn bayeraktiengesellschaftxtrabayn celltrioninckosea068270 chugaipharmaceuticalcoltdtse4519 cochlearlimitedasxcoh)
"Capital Expenditure " 2011   . .308 405.8  839 2098.1 93.7 146.1 86.8
"Capital Expenditure " 2012   . .115 578.6  672 2543.3 14.1   174 21.3
"Capital Expenditure " 2013   .  .09 332.6  742 2970.5 6.97 110.2 19.3
"Capital Expenditure " 2014   . .211 284.2 1012 2869.9 28.8 135.5 22.2
"Capital Expenditure " 2015 446 .298 201.3 1328 2733.6   43 152.8 18.4
end
    ------------------ copy up to and including the previous line ------------------

    But i want to convert it into this format

    ----------------------- copy starting from the next line -----------------------
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str23 companyname int year float(capitalexpenditure dividendspershare)
"Alcon Inc. (SWX:ALC)"    2011    .    0
"Alcon Inc. (SWX:ALC)"    2012    .    .
"Alcon Inc. (SWX:ALC)"    2013    .    .
"Alcon Inc. (SWX:ALC)"    2014    .    .
"Alcon Inc. (SWX:ALC)"    2015  446    0
"Alcon Inc. (SWX:ALC)"    2016  444    0
"Alcon Inc. (SWX:ALC)"    2017  415    0
"Alcon Inc. (SWX:ALC)"    2018  524    0
"Alcon Inc. (SWX:ALC)"    2019  553    0
"Alcon Inc. (SWX:ALC)"    2020  479 .113
"Alcon Inc. (SWX:ALC)"    2021  700 .219
"Alcon Inc. (SWX:ALC)"    2022  636 .227
"argenx SE (ENXTBR:ARGX)" 2011 .308    0
"argenx SE (ENXTBR:ARGX)" 2012 .115    0
"argenx SE (ENXTBR:ARGX)" 2013  .09    0
"argenx SE (ENXTBR:ARGX)" 2014 .211    0
"argenx SE (ENXTBR:ARGX)" 2015 .298    0
"argenx SE (ENXTBR:ARGX)" 2016 .887    0
"argenx SE (ENXTBR:ARGX)" 2017 .414    0
"argenx SE (ENXTBR:ARGX)" 2018 .712    0
"argenx SE (ENXTBR:ARGX)" 2019  1.8    0
"argenx SE (ENXTBR:ARGX)" 2020 1.07    0
"argenx SE (ENXTBR:ARGX)" 2021 3.62    0
"argenx SE (ENXTBR:ARGX)" 2022    .    .
end
    ------------------ copy up to and including the previous line ------------------

    Anyone can share the code if possible
    Tags: None
  • #2
    Code:
    * Example generated by -dataex-. To install: ssc install dataex
clear
input str23 variablename int year float(alconincswxalc argenxseenxtbrargx astellaspharmainctse4503 astrazenecaplclseazn bayeraktiengesellschaftxtrabayn celltrioninckosea068270 chugaipharmaceuticalcoltdtse4519 cochlearlimitedasxcoh)
"Capital Expenditure " 2011   . .308 405.8  839 2098.1 93.7 146.1 86.8
"Capital Expenditure " 2012   . .115 578.6  672 2543.3 14.1   174 21.3
"Capital Expenditure " 2013   .  .09 332.6  742 2970.5 6.97 110.2 19.3
"Capital Expenditure " 2014   . .211 284.2 1012 2869.9 28.8 135.5 22.2
"Capital Expenditure " 2015 446 .298 201.3 1328 2733.6   43 152.8 18.4
end

foreach var of varlist *{
    if length("`var'")>=29{
        rename `var' `=substr("`var'", 1, 28)'
    }
}

rename (alconincswxalc-cochlearlimitedasxcoh) val=
reshape long val, i(variablename year) j(which) string
    Res.:


    Code:
    . sort which year

. l, sepby(which)

     +---------------------------------------------------------------------+
     |         variablename   year                          which      val |
     |---------------------------------------------------------------------|
  1. | Capital Expenditure    2011                 alconincswxalc        . |
  2. | Capital Expenditure    2012                 alconincswxalc        . |
  3. | Capital Expenditure    2013                 alconincswxalc        . |
  4. | Capital Expenditure    2014                 alconincswxalc        . |
  5. | Capital Expenditure    2015                 alconincswxalc      446 |
     |---------------------------------------------------------------------|
  6. | Capital Expenditure    2011             argenxseenxtbrargx     .308 |
  7. | Capital Expenditure    2012             argenxseenxtbrargx     .115 |
  8. | Capital Expenditure    2013             argenxseenxtbrargx      .09 |
  9. | Capital Expenditure    2014             argenxseenxtbrargx     .211 |
 10. | Capital Expenditure    2015             argenxseenxtbrargx     .298 |
     |---------------------------------------------------------------------|
 11. | Capital Expenditure    2011       astellaspharmainctse4503    405.8 |
 12. | Capital Expenditure    2012       astellaspharmainctse4503    578.6 |
 13. | Capital Expenditure    2013       astellaspharmainctse4503    332.6 |
 14. | Capital Expenditure    2014       astellaspharmainctse4503    284.2 |
 15. | Capital Expenditure    2015       astellaspharmainctse4503    201.3 |
     |---------------------------------------------------------------------|
 16. | Capital Expenditure    2011           astrazenecaplclseazn      839 |
 17. | Capital Expenditure    2012           astrazenecaplclseazn      672 |
 18. | Capital Expenditure    2013           astrazenecaplclseazn      742 |
 19. | Capital Expenditure    2014           astrazenecaplclseazn     1012 |
 20. | Capital Expenditure    2015           astrazenecaplclseazn     1328 |
     |---------------------------------------------------------------------|
 21. | Capital Expenditure    2011   bayeraktiengesellschaftxtrab   2098.1 |
 22. | Capital Expenditure    2012   bayeraktiengesellschaftxtrab   2543.3 |
 23. | Capital Expenditure    2013   bayeraktiengesellschaftxtrab   2970.5 |
 24. | Capital Expenditure    2014   bayeraktiengesellschaftxtrab   2869.9 |
 25. | Capital Expenditure    2015   bayeraktiengesellschaftxtrab   2733.6 |
     |---------------------------------------------------------------------|
 26. | Capital Expenditure    2011        celltrioninckosea068270     93.7 |
 27. | Capital Expenditure    2012        celltrioninckosea068270     14.1 |
 28. | Capital Expenditure    2013        celltrioninckosea068270     6.97 |
 29. | Capital Expenditure    2014        celltrioninckosea068270     28.8 |
 30. | Capital Expenditure    2015        celltrioninckosea068270       43 |
     |---------------------------------------------------------------------|
 31. | Capital Expenditure    2011   chugaipharmaceuticalcoltdtse    146.1 |
 32. | Capital Expenditure    2012   chugaipharmaceuticalcoltdtse      174 |
 33. | Capital Expenditure    2013   chugaipharmaceuticalcoltdtse    110.2 |
 34. | Capital Expenditure    2014   chugaipharmaceuticalcoltdtse    135.5 |
 35. | Capital Expenditure    2015   chugaipharmaceuticalcoltdtse    152.8 |
     |---------------------------------------------------------------------|
 36. | Capital Expenditure    2011          cochlearlimitedasxcoh     86.8 |
 37. | Capital Expenditure    2012          cochlearlimitedasxcoh     21.3 |
 38. | Capital Expenditure    2013          cochlearlimitedasxcoh     19.3 |
 39. | Capital Expenditure    2014          cochlearlimitedasxcoh     22.2 |
 40. | Capital Expenditure    2015          cochlearlimitedasxcoh     18.4 |
     +---------------------------------------------------------------------+

.

    Comment

    • #3
      Respected Andrew Musau,

      Still have issues, because variables should be row wise while only companies and years should be column wise. I have this total data


      ----------------------- copy starting from the next line -----------------------
      Code:
      * Example generated by -dataex-. To install: ssc install dataex
clear
input str23 variablename int year float(alconinc argenxse astellasp astrazenec bayerakti celltrion)
"Capital Expenditure "    2011    .  .308   405.8     839   2098.1   93.7
"Capital Expenditure "    2012    .  .115   578.6     672   2543.3   14.1
"Capital Expenditure "    2013    .   .09   332.6     742   2970.5   6.97
"Capital Expenditure "    2014    .  .211   284.2    1012   2869.9   28.8
"Capital Expenditure "    2015  446  .298   201.3    1328   2733.6     43
"Capital Expenditure "    2016  444  .887   298.3    1446   2721.4   11.8
"Capital Expenditure "    2017  415  .414   260.2    1326     2841   19.7
"Capital Expenditure "    2018  524  .712   236.1    1043   2968.9   71.3
"Capital Expenditure "    2019  553   1.8   227.3     979   2973.9   81.7
"Capital Expenditure "    2020  479  1.07   383.5     961   2957.8     80
"Capital Expenditure "    2021  700  3.62   283.8    1091   2969.4   53.2
"Capital Expenditure "    2022  636     .   253.1    1091   3151.7      .
"Dividends per share "    2010    0     .    .267    2.55     2.01   .056
"Dividends per share "    2011    .     0    .302     2.8     2.14   .072
"Dividends per share "    2012    .     0    .303     2.8     2.51   .021
"Dividends per share "    2013    .     0    .276     2.8     2.89      0
"Dividends per share "    2014    .     0    .262     2.8     2.72      0
"Dividends per share "    2015    0     0     .25     2.8     2.72      0
"Dividends per share "    2016    0     0    .285     2.8     2.85      0
"Dividends per share "    2017    0     0    .305     2.8     3.36      0
"Dividends per share "    2018    0     0    .339     2.8     3.21      0
"Dividends per share "    2019    0     0    .343     2.8     3.14      0
"Dividends per share "    2020 .113     0    .372     2.8     2.45      0
"Dividends per share "    2021 .219     0     .38    2.87     2.27   .594
"Dividends per share "    2022 .227     .    .412     2.9     2.56      .
"R&D Exp. "               2011    .     0  2622.7    4506     3809   16.5
"R&D Exp. "               2012    .     0  2303.6    4266   3972.6   29.2
"R&D Exp. "               2013    .     0  1931.7    4281   4691.9     24
"R&D Exp. "               2014    .     0  1859.7    5001   4278.9   63.8
"R&D Exp. "               2015  457     0  1721.8    5660   4569.1   31.7
"R&D Exp. "               2016  481     0  2008.4    5679   4561.4     73
"R&D Exp. "               2017  545     0  1866.6    5455   5129.7   74.6
"R&D Exp. "               2018  653     0  2078.8    5299   5382.4   97.1
"R&D Exp. "               2019  690     0  1883.2    5349   5927.5   98.4
"R&D Exp. "               2020  612     0  2083.8    5901   5974.3  157.5
"R&D Exp. "               2021  662     0  2029.8    8021   6154.9  105.6
"R&D Exp. "               2022  700     .  2025.9    9529   7023.6      .
"Cost Of Goods Sold "     2011    .  6.27  3571.7    6103  23351.7     45
"Cost Of Goods Sold "     2012    .  14.6  3866.4    5257  25143.4   88.3
"Cost Of Goods Sold "     2013    .  12.9    3441    5135  26761.7   65.1
"Cost Of Goods Sold "     2014    .  15.3  3211.5    5735  24001.7    119
"Cost Of Goods Sold "     2015 3527  22.4  2776.9    4488  22373.1  199.3
"Cost Of Goods Sold "     2016 3479  33.3  2986.8    3996  11975.1  232.5
"Cost Of Goods Sold "     2017 3588  62.1  2874.5    4137  13471.4  235.2
"Cost Of Goods Sold "     2018 3585  95.7  2770.6    4504  14963.4  387.3
"Cost Of Goods Sold "     2019 3852 220.8  2635.6    4848    18430  428.7
"Cost Of Goods Sold "     2020 3774 370.9  2571.9    5246  19237.9  754.8
"Cost Of Goods Sold "     2021 3595 580.5  2224.8    9799  19124.3  676.5
"Cost Of Goods Sold "     2022 3910     .  2083.5    8619  21236.5      .
"Return on Assets % "     2011    .     .    5.52    14.8     5.48   8.78
"Return on Assets % "     2012    .  29.9    6.01    11.3     6.19   7.78
"Return on Assets % "     2013    .  18.4    6.76    7.82     6.32   3.35
"Return on Assets % "     2014    .  16.1    7.39    4.59     5.62   6.01
"Return on Assets % "     2015    .  18.7    8.23    4.29     5.87   6.38
"Return on Assets % "     2016 .125  17.6    9.38    3.98     5.25   4.91
"Return on Assets % "     2017  .12  6.01    9.45    3.66     5.46   10.1
"Return on Assets % "     2018 .278  10.8    9.24    1.75     2.64   5.94
"Return on Assets % "     2019 .217  11.1     9.4    3.14     3.45   6.48
"Return on Assets % "     2020  .57  15.4    7.93    4.26     3.64   10.1
"Return on Assets % "     2021 1.97  8.77    6.83    3.88      3.6   8.85
"Return on Assets % "     2022 1.84     .    5.92    5.55     3.49      .
"Total Debt/Equity % "    2011    .  7.86    1.59    39.8     57.7   46.3
"Total Debt/Equity % "    2012    .  13.4     .12    43.1     51.4     57
"Total Debt/Equity % "    2013    .     .    .108    44.6     43.4   68.9
"Total Debt/Equity % "    2014    .     .    .095    55.3    108.1   62.7
"Total Debt/Equity % "    2015 1.28     .    .082    81.4     78.3     44
"Total Debt/Equity % "    2016  1.2     .    .224     113     61.4   32.9
"Total Debt/Equity % "    2017 .847     .    .163   118.1     39.1   26.6
"Total Debt/Equity % "    2018 .897     .    .383   149.4     89.7   19.9
"Total Debt/Equity % "    2019 19.8   .62     .22   139.9     82.4   17.2
"Total Debt/Equity % "    2020 23.9  .577    32.3   145.2    136.2   22.6
"Total Debt/Equity % "    2021 23.3  .452    20.1    84.9    123.2   18.4
"Total Debt/Equity % "    2022 25.8     .    14.6      84      107      .
"Capex as % of Revenues " 2011    .  7.69    3.53     2.5     4.42     39
"Capex as % of Revenues " 2012    .  2.87    4.92     2.4     4.85   4.29
"Capex as % of Revenues " 2013    .  1.24    3.12    2.88     5.37   3.25
"Capex as % of Revenues " 2014    .  3.24    2.57    3.81     5.74   6.68
"Capex as % of Revenues " 2015 6.58  2.75    1.94    5.38     5.46   8.38
"Capex as % of Revenues " 2016 6.73   4.9    2.44    6.29     7.38   2.11
"Capex as % of Revenues " 2017 6.11  .836    2.21     5.9     6.76   2.21
"Capex as % of Revenues " 2018 7.33  2.13    1.93    4.72     7.06   8.09
"Capex as % of Revenues " 2019 7.37  1.94    1.93    4.02     6.09   8.36
"Capex as % of Revenues " 2020 7.01  1.72    3.17    3.61     5.84   4.71
"Capex as % of Revenues " 2021 8.44  .686    2.51    2.92     5.92   3.32
"Capex as % of Revenues " 2022  7.3     .    2.37    2.46     5.81      .
"Quick Ratio "            2011    .  7.79    1.83     1.3     .837   .569
"Quick Ratio "            2012    .  3.56    1.86    1.09     .864   1.13
"Quick Ratio "            2013    .  7.35    1.95       1     .788   .738
"Quick Ratio "            2014    .   6.8    2.24    .724     .836   1.05
"Quick Ratio "            2015 1.04  5.03    1.89    .905     .839   1.23
"Quick Ratio "            2016 1.01  3.06    1.74      .7     1.02   1.69
"Quick Ratio "            2017 1.04  14.8    1.69     .55     1.42   2.25
"Quick Ratio "            2018  .98  14.2     1.6    .646     .828   2.16
"Quick Ratio "            2019 1.13  8.53    1.36    .629     .872   2.21
"Quick Ratio "            2020 1.43   6.1    .874    .674     .654   1.91
"Quick Ratio "            2021 1.36  7.88    1.16    .672     .705   1.94
"Quick Ratio "            2022 1.06     .    1.08    .615     .673      .
"Market Capitalization "  2011    .     .   19228 57307.8  59776.9 3867.7
"Market Capitalization "  2012    .     . 24679.4 57008.7  83012.7      .
"Market Capitalization "  2013    .     . 28105.4   83848 109772.9 4070.5
end
      ------------------ copy up to and including the previous line ------------------

      I want them to convert into long panel style to run panel data.

      Comment

      • #4
        Code:
        * Example generated by -dataex-. To install: ssc install dataex
clear
input str23 variablename int year float(alconinc argenxse astellasp astrazenec bayerakti celltrion)
"Capital Expenditure "    2011    .  .308   405.8     839   2098.1   93.7
"Capital Expenditure "    2012    .  .115   578.6     672   2543.3   14.1
"Capital Expenditure "    2013    .   .09   332.6     742   2970.5   6.97
"Capital Expenditure "    2014    .  .211   284.2    1012   2869.9   28.8
"Capital Expenditure "    2015  446  .298   201.3    1328   2733.6     43
"Capital Expenditure "    2016  444  .887   298.3    1446   2721.4   11.8
"Capital Expenditure "    2017  415  .414   260.2    1326     2841   19.7
"Capital Expenditure "    2018  524  .712   236.1    1043   2968.9   71.3
"Capital Expenditure "    2019  553   1.8   227.3     979   2973.9   81.7
"Capital Expenditure "    2020  479  1.07   383.5     961   2957.8     80
"Capital Expenditure "    2021  700  3.62   283.8    1091   2969.4   53.2
"Capital Expenditure "    2022  636     .   253.1    1091   3151.7      .
"Dividends per share "    2010    0     .    .267    2.55     2.01   .056
"Dividends per share "    2011    .     0    .302     2.8     2.14   .072
"Dividends per share "    2012    .     0    .303     2.8     2.51   .021
"Dividends per share "    2013    .     0    .276     2.8     2.89      0
"Dividends per share "    2014    .     0    .262     2.8     2.72      0
"Dividends per share "    2015    0     0     .25     2.8     2.72      0
"Dividends per share "    2016    0     0    .285     2.8     2.85      0
"Dividends per share "    2017    0     0    .305     2.8     3.36      0
"Dividends per share "    2018    0     0    .339     2.8     3.21      0
"Dividends per share "    2019    0     0    .343     2.8     3.14      0
"Dividends per share "    2020 .113     0    .372     2.8     2.45      0
"Dividends per share "    2021 .219     0     .38    2.87     2.27   .594
"Dividends per share "    2022 .227     .    .412     2.9     2.56      .
"R&D Exp. "               2011    .     0  2622.7    4506     3809   16.5
"R&D Exp. "               2012    .     0  2303.6    4266   3972.6   29.2
"R&D Exp. "               2013    .     0  1931.7    4281   4691.9     24
"R&D Exp. "               2014    .     0  1859.7    5001   4278.9   63.8
"R&D Exp. "               2015  457     0  1721.8    5660   4569.1   31.7
"R&D Exp. "               2016  481     0  2008.4    5679   4561.4     73
"R&D Exp. "               2017  545     0  1866.6    5455   5129.7   74.6
"R&D Exp. "               2018  653     0  2078.8    5299   5382.4   97.1
"R&D Exp. "               2019  690     0  1883.2    5349   5927.5   98.4
"R&D Exp. "               2020  612     0  2083.8    5901   5974.3  157.5
"R&D Exp. "               2021  662     0  2029.8    8021   6154.9  105.6
"R&D Exp. "               2022  700     .  2025.9    9529   7023.6      .
"Cost Of Goods Sold "     2011    .  6.27  3571.7    6103  23351.7     45
"Cost Of Goods Sold "     2012    .  14.6  3866.4    5257  25143.4   88.3
"Cost Of Goods Sold "     2013    .  12.9    3441    5135  26761.7   65.1
"Cost Of Goods Sold "     2014    .  15.3  3211.5    5735  24001.7    119
"Cost Of Goods Sold "     2015 3527  22.4  2776.9    4488  22373.1  199.3
"Cost Of Goods Sold "     2016 3479  33.3  2986.8    3996  11975.1  232.5
"Cost Of Goods Sold "     2017 3588  62.1  2874.5    4137  13471.4  235.2
"Cost Of Goods Sold "     2018 3585  95.7  2770.6    4504  14963.4  387.3
"Cost Of Goods Sold "     2019 3852 220.8  2635.6    4848    18430  428.7
"Cost Of Goods Sold "     2020 3774 370.9  2571.9    5246  19237.9  754.8
"Cost Of Goods Sold "     2021 3595 580.5  2224.8    9799  19124.3  676.5
"Cost Of Goods Sold "     2022 3910     .  2083.5    8619  21236.5      .
"Return on Assets % "     2011    .     .    5.52    14.8     5.48   8.78
"Return on Assets % "     2012    .  29.9    6.01    11.3     6.19   7.78
"Return on Assets % "     2013    .  18.4    6.76    7.82     6.32   3.35
"Return on Assets % "     2014    .  16.1    7.39    4.59     5.62   6.01
"Return on Assets % "     2015    .  18.7    8.23    4.29     5.87   6.38
"Return on Assets % "     2016 .125  17.6    9.38    3.98     5.25   4.91
"Return on Assets % "     2017  .12  6.01    9.45    3.66     5.46   10.1
"Return on Assets % "     2018 .278  10.8    9.24    1.75     2.64   5.94
"Return on Assets % "     2019 .217  11.1     9.4    3.14     3.45   6.48
"Return on Assets % "     2020  .57  15.4    7.93    4.26     3.64   10.1
"Return on Assets % "     2021 1.97  8.77    6.83    3.88      3.6   8.85
"Return on Assets % "     2022 1.84     .    5.92    5.55     3.49      .
"Total Debt/Equity % "    2011    .  7.86    1.59    39.8     57.7   46.3
"Total Debt/Equity % "    2012    .  13.4     .12    43.1     51.4     57
"Total Debt/Equity % "    2013    .     .    .108    44.6     43.4   68.9
"Total Debt/Equity % "    2014    .     .    .095    55.3    108.1   62.7
"Total Debt/Equity % "    2015 1.28     .    .082    81.4     78.3     44
"Total Debt/Equity % "    2016  1.2     .    .224     113     61.4   32.9
"Total Debt/Equity % "    2017 .847     .    .163   118.1     39.1   26.6
"Total Debt/Equity % "    2018 .897     .    .383   149.4     89.7   19.9
"Total Debt/Equity % "    2019 19.8   .62     .22   139.9     82.4   17.2
"Total Debt/Equity % "    2020 23.9  .577    32.3   145.2    136.2   22.6
"Total Debt/Equity % "    2021 23.3  .452    20.1    84.9    123.2   18.4
"Total Debt/Equity % "    2022 25.8     .    14.6      84      107      .
"Capex as % of Revenues " 2011    .  7.69    3.53     2.5     4.42     39
"Capex as % of Revenues " 2012    .  2.87    4.92     2.4     4.85   4.29
"Capex as % of Revenues " 2013    .  1.24    3.12    2.88     5.37   3.25
"Capex as % of Revenues " 2014    .  3.24    2.57    3.81     5.74   6.68
"Capex as % of Revenues " 2015 6.58  2.75    1.94    5.38     5.46   8.38
"Capex as % of Revenues " 2016 6.73   4.9    2.44    6.29     7.38   2.11
"Capex as % of Revenues " 2017 6.11  .836    2.21     5.9     6.76   2.21
"Capex as % of Revenues " 2018 7.33  2.13    1.93    4.72     7.06   8.09
"Capex as % of Revenues " 2019 7.37  1.94    1.93    4.02     6.09   8.36
"Capex as % of Revenues " 2020 7.01  1.72    3.17    3.61     5.84   4.71
"Capex as % of Revenues " 2021 8.44  .686    2.51    2.92     5.92   3.32
"Capex as % of Revenues " 2022  7.3     .    2.37    2.46     5.81      .
"Quick Ratio "            2011    .  7.79    1.83     1.3     .837   .569
"Quick Ratio "            2012    .  3.56    1.86    1.09     .864   1.13
"Quick Ratio "            2013    .  7.35    1.95       1     .788   .738
"Quick Ratio "            2014    .   6.8    2.24    .724     .836   1.05
"Quick Ratio "            2015 1.04  5.03    1.89    .905     .839   1.23
"Quick Ratio "            2016 1.01  3.06    1.74      .7     1.02   1.69
"Quick Ratio "            2017 1.04  14.8    1.69     .55     1.42   2.25
"Quick Ratio "            2018  .98  14.2     1.6    .646     .828   2.16
"Quick Ratio "            2019 1.13  8.53    1.36    .629     .872   2.21
"Quick Ratio "            2020 1.43   6.1    .874    .674     .654   1.91
"Quick Ratio "            2021 1.36  7.88    1.16    .672     .705   1.94
"Quick Ratio "            2022 1.06     .    1.08    .615     .673      .
"Market Capitalization "  2011    .     .   19228 57307.8  59776.9 3867.7
"Market Capitalization "  2012    .     . 24679.4 57008.7  83012.7      .
"Market Capitalization "  2013    .     . 28105.4   83848 109772.9 4070.5
end

rename (alco-cell) val=
reshape long val, i(var year) j(company) string
replace variablename= ustrregexra(variablename,"[^a-zA-Z0-9]", "")
reshape wide val, i(company year) j(variablename) string
rename val* *
        Res.:

        Code:
        . l, sepby(company)

     +--------------------------------------------------------------------------------------------------------------------+
     | year      company   Capexa~s   Capita~e   CostOf~d   Divide~e   Market~n   QuickR~o    RDExp   Return~s   TotalD~y |
     |--------------------------------------------------------------------------------------------------------------------|
  1. | 2010     alconinc          .          .          .          0          .          .        .          .          . |
  2. | 2011     alconinc          .          .          .          .          .          .        .          .          . |
  3. | 2012     alconinc          .          .          .          .          .          .        .          .          . |
  4. | 2013     alconinc          .          .          .          .          .          .        .          .          . |
  5. | 2014     alconinc          .          .          .          .          .          .        .          .          . |
  6. | 2015     alconinc       6.58        446       3527          0          .       1.04      457          .       1.28 |
  7. | 2016     alconinc       6.73        444       3479          0          .       1.01      481       .125        1.2 |
  8. | 2017     alconinc       6.11        415       3588          0          .       1.04      545        .12       .847 |
  9. | 2018     alconinc       7.33        524       3585          0          .        .98      653       .278       .897 |
 10. | 2019     alconinc       7.37        553       3852          0          .       1.13      690       .217       19.8 |
 11. | 2020     alconinc       7.01        479       3774       .113          .       1.43      612        .57       23.9 |
 12. | 2021     alconinc       8.44        700       3595       .219          .       1.36      662       1.97       23.3 |
 13. | 2022     alconinc        7.3        636       3910       .227          .       1.06      700       1.84       25.8 |
     |--------------------------------------------------------------------------------------------------------------------|
 14. | 2010     argenxse          .          .          .          .          .          .        .          .          . |
 15. | 2011     argenxse       7.69       .308       6.27          0          .       7.79        0          .       7.86 |
 16. | 2012     argenxse       2.87       .115       14.6          0          .       3.56        0       29.9       13.4 |
 17. | 2013     argenxse       1.24        .09       12.9          0          .       7.35        0       18.4          . |
 18. | 2014     argenxse       3.24       .211       15.3          0          .        6.8        0       16.1          . |
 19. | 2015     argenxse       2.75       .298       22.4          0          .       5.03        0       18.7          . |
 20. | 2016     argenxse        4.9       .887       33.3          0          .       3.06        0       17.6          . |
 21. | 2017     argenxse       .836       .414       62.1          0          .       14.8        0       6.01          . |
 22. | 2018     argenxse       2.13       .712       95.7          0          .       14.2        0       10.8          . |
 23. | 2019     argenxse       1.94        1.8      220.8          0          .       8.53        0       11.1        .62 |
 24. | 2020     argenxse       1.72       1.07      370.9          0          .        6.1        0       15.4       .577 |
 25. | 2021     argenxse       .686       3.62      580.5          0          .       7.88        0       8.77       .452 |
 26. | 2022     argenxse          .          .          .          .          .          .        .          .          . |
     |--------------------------------------------------------------------------------------------------------------------|
 27. | 2010    astellasp          .          .          .       .267          .          .        .          .          . |
 28. | 2011    astellasp       3.53      405.8     3571.7       .302      19228       1.83   2622.7       5.52       1.59 |
 29. | 2012    astellasp       4.92      578.6     3866.4       .303    24679.4       1.86   2303.6       6.01        .12 |
 30. | 2013    astellasp       3.12      332.6       3441       .276    28105.4       1.95   1931.7       6.76       .108 |
 31. | 2014    astellasp       2.57      284.2     3211.5       .262          .       2.24   1859.7       7.39       .095 |
 32. | 2015    astellasp       1.94      201.3     2776.9        .25          .       1.89   1721.8       8.23       .082 |
 33. | 2016    astellasp       2.44      298.3     2986.8       .285          .       1.74   2008.4       9.38       .224 |
 34. | 2017    astellasp       2.21      260.2     2874.5       .305          .       1.69   1866.6       9.45       .163 |
 35. | 2018    astellasp       1.93      236.1     2770.6       .339          .        1.6   2078.8       9.24       .383 |
 36. | 2019    astellasp       1.93      227.3     2635.6       .343          .       1.36   1883.2        9.4        .22 |
 37. | 2020    astellasp       3.17      383.5     2571.9       .372          .       .874   2083.8       7.93       32.3 |
 38. | 2021    astellasp       2.51      283.8     2224.8        .38          .       1.16   2029.8       6.83       20.1 |
 39. | 2022    astellasp       2.37      253.1     2083.5       .412          .       1.08   2025.9       5.92       14.6 |
     |--------------------------------------------------------------------------------------------------------------------|
 40. | 2010   astrazenec          .          .          .       2.55          .          .        .          .          . |
 41. | 2011   astrazenec        2.5        839       6103        2.8    57307.8        1.3     4506       14.8       39.8 |
 42. | 2012   astrazenec        2.4        672       5257        2.8    57008.7       1.09     4266       11.3       43.1 |
 43. | 2013   astrazenec       2.88        742       5135        2.8      83848          1     4281       7.82       44.6 |
 44. | 2014   astrazenec       3.81       1012       5735        2.8          .       .724     5001       4.59       55.3 |
 45. | 2015   astrazenec       5.38       1328       4488        2.8          .       .905     5660       4.29       81.4 |
 46. | 2016   astrazenec       6.29       1446       3996        2.8          .         .7     5679       3.98        113 |
 47. | 2017   astrazenec        5.9       1326       4137        2.8          .        .55     5455       3.66      118.1 |
 48. | 2018   astrazenec       4.72       1043       4504        2.8          .       .646     5299       1.75      149.4 |
 49. | 2019   astrazenec       4.02        979       4848        2.8          .       .629     5349       3.14      139.9 |
 50. | 2020   astrazenec       3.61        961       5246        2.8          .       .674     5901       4.26      145.2 |
 51. | 2021   astrazenec       2.92       1091       9799       2.87          .       .672     8021       3.88       84.9 |
 52. | 2022   astrazenec       2.46       1091       8619        2.9          .       .615     9529       5.55         84 |
     |--------------------------------------------------------------------------------------------------------------------|
 53. | 2010    bayerakti          .          .          .       2.01          .          .        .          .          . |
 54. | 2011    bayerakti       4.42     2098.1    23351.7       2.14    59776.9       .837     3809       5.48       57.7 |
 55. | 2012    bayerakti       4.85     2543.3    25143.4       2.51    83012.7       .864   3972.6       6.19       51.4 |
 56. | 2013    bayerakti       5.37     2970.5    26761.7       2.89   109772.9       .788   4691.9       6.32       43.4 |
 57. | 2014    bayerakti       5.74     2869.9    24001.7       2.72          .       .836   4278.9       5.62      108.1 |
 58. | 2015    bayerakti       5.46     2733.6    22373.1       2.72          .       .839   4569.1       5.87       78.3 |
 59. | 2016    bayerakti       7.38     2721.4    11975.1       2.85          .       1.02   4561.4       5.25       61.4 |
 60. | 2017    bayerakti       6.76       2841    13471.4       3.36          .       1.42   5129.7       5.46       39.1 |
 61. | 2018    bayerakti       7.06     2968.9    14963.4       3.21          .       .828   5382.4       2.64       89.7 |
 62. | 2019    bayerakti       6.09     2973.9      18430       3.14          .       .872   5927.5       3.45       82.4 |
 63. | 2020    bayerakti       5.84     2957.8    19237.9       2.45          .       .654   5974.3       3.64      136.2 |
 64. | 2021    bayerakti       5.92     2969.4    19124.3       2.27          .       .705   6154.9        3.6      123.2 |
 65. | 2022    bayerakti       5.81     3151.7    21236.5       2.56          .       .673   7023.6       3.49        107 |
     |--------------------------------------------------------------------------------------------------------------------|
 66. | 2010    celltrion          .          .          .       .056          .          .        .          .          . |
 67. | 2011    celltrion         39       93.7         45       .072     3867.7       .569     16.5       8.78       46.3 |
 68. | 2012    celltrion       4.29       14.1       88.3       .021          .       1.13     29.2       7.78         57 |
 69. | 2013    celltrion       3.25       6.97       65.1          0     4070.5       .738       24       3.35       68.9 |
 70. | 2014    celltrion       6.68       28.8        119          0          .       1.05     63.8       6.01       62.7 |
 71. | 2015    celltrion       8.38         43      199.3          0          .       1.23     31.7       6.38         44 |
 72. | 2016    celltrion       2.11       11.8      232.5          0          .       1.69       73       4.91       32.9 |
 73. | 2017    celltrion       2.21       19.7      235.2          0          .       2.25     74.6       10.1       26.6 |
 74. | 2018    celltrion       8.09       71.3      387.3          0          .       2.16     97.1       5.94       19.9 |
 75. | 2019    celltrion       8.36       81.7      428.7          0          .       2.21     98.4       6.48       17.2 |
 76. | 2020    celltrion       4.71         80      754.8          0          .       1.91    157.5       10.1       22.6 |
 77. | 2021    celltrion       3.32       53.2      676.5       .594          .       1.94    105.6       8.85       18.4 |
 78. | 2022    celltrion          .          .          .          .          .          .        .          .          . |
     +--------------------------------------------------------------------------------------------------------------------+

.

        Comment

        Previous Next
        Working...
        X