Rearrange dataset - reshape or transpose

[Francois Durant]

I would like to reshape or transpose the following dataset in a panel data with "Code" as firm identifier and "t" the date in month. Currently the columns "t1, t2, ..., tn" correspond to the date in months. I would like "DATATYPE" to become the variables (columns). Please let me know how I can handle this in Stata. Thanks!

 
 * Example generated by -dataex-. To install: ssc install dataex clear input str6 Code str8 DATATYPE double(t1 t2 t3 t4 t5 t6 t7 t8 t9 t10) "891399" "RI"       99560.06 96191.44 102572.9 94357.75 91955.69    90723 88642.19 90704.13 95324.94 96695.94 "891399" "MV"       970590.8   937750 999961.4 916153.9 892831.6 880862.8 858678.2 878652.3 923413.4 932293.5 "891399" "PTBV"        15.65    15.12    16.12    14.83    14.45    14.26    13.93    14.25    14.98     15.2 "891399" "MTBV"        15.64    15.11    16.11    14.76    14.39    14.19    13.84    14.16    14.88    15.02 "891399" "IBNOSH"     497.81   497.81  495.797  495.797  495.797  494.656  494.656  494.656  492.332  492.332 "891399" "WC02201"         .        .        . 96334000 96334000 96334000 96334000 96334000 96334000 96334000 "891399" "WC02005"         .        .        . 55297000 55297000 55297000 55297000 55297000 55297000 55297000 "891399" "WC03101"         .        .        . 87812000 87812000 87812000 87812000 87812000 87812000 87812000 "891399" "WC04821"         .        .        .        .        .        .        .        .        .        . "891399" "WC04049"         .        .        . 21789000 21789000 21789000 21789000 21789000 21789000 21789000 "891399" "WC18226"         .        .        .        .        .        .        .        .        .        . "891399" "WC08326"         .        .        .     6.91     6.91     6.91     6.91     6.91     6.91     6.91 "891399" "WC08621"         .        .        .    38.49    38.49    38.49    38.49    38.49    38.49    38.49 "891399" "DY"              0        0        0        0        0        0        0        0        0        0 "891399" "WC09802"      1.12     1.12     1.12     1.12     1.12     1.12     1.12     1.12     1.12     1.12 "891399" "BETA"            .        .        .        .        .        .        .        .        .        . "891399" "897E"       1.2019    1.524   1.5759    1.493   1.5193   1.5523   1.5326   1.5563   1.5442   1.5588 "891399" "VOL"             .        .        .        .        .        .        .        .        .        . "891399" "WC08806"         .        .        .    24.75    24.75    24.75    24.75    24.75    24.75    24.75 "891399" "400E"        .2745    .2753    .2729    .2757    .2806    .2825    .2849    .2861    .2849    .2857 "891399" "VO"       163844.9    92556  84839.3    68522  52060.5  72166.3  62003.8  79989.5  73190.9  74746.6 "891399" "WC05301"         .        .        .   498000   498000   498000   498000   498000   498000   498000 "891399" "WC03051A"        .        .        . 11191000        .        . 10749000        .        . 10520000 "891399" "WC03051"         .        .        . 11191000 11191000 11191000 11191000 11191000 11191000 11191000 "891399" "WC05508"         .        .        .  556.591  556.591  556.591  556.591  556.591  556.591  556.591 "916328" "RI"       94255.31 92009.69 104085.8 103317.5 101640.4 99451.75 99124.75 101079.6 103188.3 99255.69 "916328" "MV"       139152.4 135837.2 153665.5 153608.1 151114.6 147860.6 147966.8 150794.4 153940.4 148367.6 "916328" "PTBV"         4.47     4.37     4.94     4.92     4.84     4.74     4.74     4.84     4.94     4.77 "916328" "MTBV"         4.48     4.37     4.94     4.94     4.86     4.76     4.76     4.85     4.95     4.77 "916328" "IBNOSH"   1763.433 1768.456 1768.456 1768.456 1768.456 1767.398 1767.398 1767.398 1764.181 1764.181 "916328" "WC02201"         .        .        . 15667000 15667000 15667000 15667000 15667000 15667000 15667000 "916328" "WC02005"         .        .        .  4288000  4288000  4288000  4288000  4288000  4288000  4288000 "916328" "WC03101"         .        .        . 10863000 10863000 10863000 10863000 10863000 10863000 10863000 "916328" "WC04821"         .        .        .        .        .        .        .        .        .        . "916328" "WC04049"         .        .        .  1078000  1078000  1078000  1078000  1078000  1078000  1078000 "916328" "WC18226"         .        .        .        .        .        .        .        .        .        . "916328" "WC08326"         .        .        .     6.43     6.43     6.43     6.43     6.43     6.43     6.43 "916328" "WC08621"         .        .        .      .74      .74      .74      .74      .74      .74      .74 "916328" "DY"           1.82     1.87     1.65     1.66      1.5     1.53     1.53      1.5     1.47     1.52 "916328" "WC09802"       .62      .62      .62      .62      .62      .62      .62      .62      .62      .62 "916328" "BETA"            .        .        .        .        .        .        .        .        .        . "916328" "897E"        .8977   1.1552   1.1185   1.1038   1.1069   1.1116   1.1209    1.128    1.108   1.0936 "916328" "VOL"             .        .        .        .        .        .        .        .        .        . "916328" "WC08806"         .        .        .    14.37    14.37    14.37    14.37    14.37    14.37    14.37 "916328" "400E"         .201    .2013    .1935    .1936    .1936    .1936    .1941     .194    .1935    .1934 "916328" "VO"       311375.6 102114.3   119091  84476.8  97937.7 113094.8  80342.5 103764.3 103743.9   115150 "916328" "WC05301"         .        .        .  1762503  1762503  1762503  1762503  1762503  1762503  1762503 "916328" "WC03051A"        .        .        .  1478000        .        .  1458000        .        .   212000 "916328" "WC03051"         .        .        .  1478000  1478000  1478000  1478000  1478000  1478000  1478000 "916328" "WC05508"         .        .        .   17.914   17.914   17.914   17.914   17.914   17.914   17.914 "545101" "RI"          554.1   681.62   809.15   805.06   765.01   689.76   655.79   615.25   673.85   667.22 "545101" "MV"        9040.84 11109.33  13186.1 13212.65 12554.21 11319.37 10847.29 10176.81 11146.03 11124.06 "545101" "PTBV"         3.01     3.71      4.4     4.41     4.19     3.78     3.62      3.4     3.72     3.71 "545101" "MTBV"         3.02     3.71      4.4     4.41     4.19     3.78     3.62      3.4     3.72     3.71 "545101" "IBNOSH"    664.768  663.893  663.893  663.893  663.893   663.85   663.85   663.85  663.727  663.727 "545101" "WC02201"         .        .        .  5231000  5231000  5231000  5231000  5231000  5231000  5231000 "545101" "WC02005"         .        .        .  1837000  1837000  1837000  1837000  1837000  1837000  1837000 "545101" "WC03101"         .        .        .  5096000  5096000  5096000  5096000  5096000  5096000  5096000 "545101" "WC04821"         .        .        .   291000   291000   291000   291000   291000   291000   291000 "545101" "WC04049"         .        .        .   977000   977000   977000   977000   977000   977000   977000 "545101" "WC18226"         .        .        .        .        .        .        .        .        .        . "545101" "WC08326"         .        .        .     3.44     3.44     3.44     3.44     3.44     3.44     3.44 "545101" "WC08621"         .        .        .     3.29     3.29     3.29     3.29     3.29     3.29     3.29 "545101" "DY"           4.06      3.3     2.78     2.78     2.89      3.2     3.34     3.56     3.25     3.26 "545101" "WC09802"      1.11     1.11     1.11     1.11     1.11     1.11     1.11     1.11     1.11     1.11 "545101" "BETA"            .        .        .        .        .        .        .        .        .        . "545101" "897E"       1.1952   1.1102   1.0121   1.0603   1.0536   1.0174   1.0062   1.0133    .9924   1.0061 "545101" "VOL"             .        .        .        .        .        .        .        .        .        . "545101" "WC08806"         .        .        .    18.96    18.96    18.96    18.96    18.96    18.96    18.96 "545101" "400E"        .2487    .2304    .2176    .2248    .2239    .2196     .219    .2194    .2161     .218 "545101" "VO"       176352.3  79978.6  76585.1 112336.9   131234 102151.9  93045.8 116666.5 101141.6 104630.9 "545101" "WC05301"         .        .        .   663953   663953   663953   663953   663953   663953   663953 "545101" "WC03051A"        .        .        .  1868000        .        .  1882000        .        .  1087000 "545101" "WC03051"         .        .        .  1868000  1868000  1868000  1868000  1868000  1868000  1868000 "545101" "WC05508"         .        .        .   15.276   15.276   15.276   15.276   15.276   15.276   15.276 "777953" "RI"        2639.27     2732  3387.09  3101.64  3566.91  3774.18  3234.36  3510.36  5064.73  4736.18 "777953" "MV"        6541.29  6771.11  8394.72  7695.79  8858.52  9373.29  8072.06  8760.88 12640.14 11795.82 "777953" "PTBV"         6.99     7.24     8.97     8.22     9.45       10     8.57      9.3    13.42    12.55 "777953" "MTBV"         6.98     7.23     8.96     8.21     9.46       10     8.62     9.35    13.49    12.59 "777953" "IBNOSH"     45.063   45.063   45.155   45.155   45.155   45.377   45.377   45.377   45.283   45.125 "777953" "WC02201"         .        .        .        .        .        .        .        .        .        . "777953" "WC02005"         .        .        .        .        .        .        .        .        .        . "777953" "WC03101"         .        .        .        .        .        .        .        .        .        . "777953" "WC04821"         .        .        .        .        .        .        .        .        .        . "777953" "WC04049"         .        .        .        .        .        .        .        .        .        . "777953" "WC18226"         .        .        .        .        .        .        .        .        .        . "777953" "WC08326"         .        .        .        .        .        .        .        .        .        . "777953" "WC08621"         .        .        .        .        .        .        .        .        .        . "777953" "DY"              0        0        0        0        0        0        0        0        0        0 "777953" "WC09802"       .96      .96      .96      .96      .96      .96      .96      .96      .96      .96 "777953" "BETA"            .        .        .        .        .        .        .        .        .        . "777953" "897E"        .6244    .6464    .4873    .3282    .3723    .4196    .4523    .4924    .3397    .3418 "777953" "VOL"             .        .        .        .        .        .        .        .        .        . "777953" "WC08806"         .        .        .    37.87    37.87    37.87    37.87    37.87    37.87    37.87 "777953" "400E"        .4192     .424    .4159    .4339    .4278    .4267    .4373    .4357    .3968    .3967 "777953" "VO"        18452.1  16997.1  21766.8  14442.2  17404.6  16993.5  10755.7  17956.5     8617  11208.9 "777953" "WC05301"         .        .        .        .        .        .        .        .        .        . "777953" "WC03051A"        0        .        .        0        .        .        .        .        .        . "777953" "WC03051"         .        .        .        .        .        .        .        .        .        . "777953" "WC05508"         .        .        .        .        .        .        .        .        .        . end

[Clyde Schechter]

Well, it is not possible to get exactly what you ask for because many of the values of DATATYPE are not legal Stata variable names. But you can come close to that:

reshape long t, i(Code DATATYPE) j(day_of_month)
replace DATATYPE = strtoname(DATATYPE)
reshape wide t, i(Code day_of_month) j(DATATYPE) string
rename t* *

Added: While there is a transpose command in Stata (-xpose-), it seldom is what is wanted in this kind of situation. Most of the situations where you are thinking it looks like a transpose, it is usually what is shown here: a -reshape long- followed by a -reshape wide-, sometimes with some dancing with -rename- along the way.