Data in panel format

[Dario Maimone Ansaldo Patti]

Dear All,

I have some data in the following format:

* Example generated by -dataex-. For more info, type help dataex
clear
input str15 company str11 variables double(y2009 y2010 y2011 y2012 y2013 y2014 y2015 y2016 y2017 y2018 y2019 y2020 y2021)
"ACCELINK TECH "  "ta"          1295741 1446467 1618748 2506041 2633857 3572862 4195052 4793051  5137383  6042909  7171926  8481982  9401104
"ACCELINK TECH "  " eesg"             .       .       .       .       .       .       .       .        .        .    32.93    56.64    59.11
"ACCELINK TECH "  " gesg"             .       .       .       .       .       .       .       .        .        .     40.5    57.05    51.28
"ACCELINK TECH "  " sesg"             .       .       .       .       .       .       .       .        .        .    25.32    48.08    46.86
"ACCELINK TECH "  " esg"              .       .       .       .       .       .       .       .        .        .    32.73    54.02    52.87
"ACCELINK TECH "  "ni"           104194  126825  111680  160230  163515  144128  243262  285021   334290   332715   357697   487379   567267
"ACCELINK TECH "  "dp"            15407   15566   24879   62757   76622   87799   98673  108834   139046   157048   178186   221082   286428
"ACCELINK TECH "  "debt_equity"   15.39   19.52   22.33   30.79   23.46   19.84   18.63   29.52    21.51    34.16    20.75    25.35    30.58
"ACCELINK TECH "  "debt"          12.95   16.29   18.25   23.54      19   16.55   15.71   22.31    17.35    24.59     16.6    19.47    22.83
"ACCELINK TECH "  "roe"           17.27   12.81    10.4   12.33   10.36    7.12    9.67   10.39    11.28    10.26     9.05    10.23    10.74
"ADAMA LTD "      "ta"          2047897 2034921 2311633 2390263 2695651 2921101 2966247 2945365 38722910 42079892 44462244 46027361 49512233
"ADAMA LTD "      " eesg"             .       .       .       .       .       .       .       .        .        .        .    38.23        .
"ADAMA LTD "      " gesg"             .       .       .       .       .       .       .       .        .        .        .    13.25        .
"ADAMA LTD "      " sesg"             .       .       .       .       .       .       .       .        .        .        .    42.17        .
"ADAMA LTD "      " esg"              .       .       .       .       .       .       .       .        .        .        .    34.13        .
"ADAMA LTD "      "ni"            19311   23808   52864  103769  320812  491772  141840  -74490  1545879  2402462   277041   352753   157397
"ADAMA LTD "      "dp"            94739  101025  103780  144966  165305  178775  214591  238167  1667875  1945458  2335164  2256908  1942072
"ADAMA LTD "      "debt_equity"   67.01   63.17   77.69   66.77   49.52   26.01   28.97   18.43    60.35    41.31    56.76    64.12    71.84
"ADAMA LTD "      "debt"          39.85   38.42   43.29   39.55   32.84   20.64   22.46   15.56    37.64    29.24    36.21    38.98    41.81
"ADAMA LTD "      "roe"            1.77    2.17    4.62     8.6    22.9   27.68    6.91   -3.63     8.66     11.7     1.23     1.61      .74
"ADDSINO CO LTD " "ta"          1694516 1870934 2173789 2579079 2827061 3469668 6771358 6931878  7604538  9303400 10829019 12397440 13904476
"ADDSINO CO LTD " " eesg"             .       .       .       .       .       .       .       .        .        .        0      .71     9.38
"ADDSINO CO LTD " " gesg"             .       .       .       .       .       .       .       .        .        .    56.74    48.09    54.71
"ADDSINO CO LTD " " sesg"             .       .       .       .       .       .       .       .        .        .      7.7    13.72    13.98
"ADDSINO CO LTD " " esg"              .       .       .       .       .       .       .       .        .        .    21.75    21.76    26.07
"ADDSINO CO LTD " "ni"            69038   24567  107137  120371  138439  206876  207484  244020   276126   448257   675265   807848   644201
"ADDSINO CO LTD " "dp"            15877   12639   10208   10480   12550   28664   53640   54580    73584    96793   108990   122677   165398
"ADDSINO CO LTD " "debt_equity"   37.24   22.26   13.61   24.67   30.68   22.26    9.49   11.23    13.84    11.18     15.4    13.44    16.91
"ADDSINO CO LTD " "debt"          25.52   16.99   11.18   17.77   21.14   16.71     8.4    9.77    11.62     9.61    12.81    10.81    13.21
"ADDSINO CO LTD " "roe"            7.06    2.11    7.75    7.65     8.5   10.58    5.46    4.63     5.21     7.27     9.19     9.94     7.38
end

I am trying to figure out how I can convert them in a panel format. Do you have any suggestion?

Thanks in advance

Dario

[Justin Niakamal]

reshape long y, i(company variables) j(year)
replace variables = ustrtrim(variables)
reshape wide y, i(company year) j(variables)string

encode company, gen(id)
xtset id year, yearly

[Dario Maimone Ansaldo Patti]

Justin Niakamal thanks a lot for your prompt reply!