I am here stuck unable to reshape a panel monthly data from US states.
I extracted state codes and industry employment Id's (seriesid), renamed the monthly date as yrmon with the aim of using the rshape command using the line :
HTML Code:
reshape long yrmon, i(state_code seriesid) j(yrmon?)
A snap of my data looks like:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str20 SeriesID str3 SMS byte state_code long seriesid double(yrmonJan1990 yrmonFeb1990 yrmonMar1990 yrmonApr1990 yrmonMay1990 yrmonJun1990 yrmonJul1990 yrmonAug1990 yrmonSep1990 yrmonOct1990 yrmonNov1990 yrmonDec1990) "SMS01000000000000001" "SMS" 1 0 1635.9 1633.8 1632.1 1643.8 1648.7 1649.8 1651.7 1649.3 1651.2 1647.4 1648.6 1648.3 "SMS01000001000000001" "SMS" 1 10000000 18.2 18.3 18.5 18.6 19 19 19.3 19.1 19 19.5 19.2 19 "SMS01000002000000001" "SMS" 1 20000000 88.9 88.5 87.7 87 87.2 87.1 85.5 84.7 83.2 82.4 82.1 82.1 "SMS01000003000000001" "SMS" 1 30000000 365.5 362.5 360.6 366.6 366.2 367.5 364.6 364.7 364.9 363.4 361.2 359.9 "SMS01000004000000001" "SMS" 1 40000000 317 316.7 316.3 316.2 316 318 318 318.5 318.6 316.4 317.5 317.4 "SMS01000004100000001" "SMS" 1 41000000 67.2 67.4 67.2 67.6 67.6 68 67.7 67.8 67.7 67.4 67.6 67.5 "SMS01000004200000001" "SMS" 1 42000000 191.2 190.9 190.7 190.3 190 191.3 192 192.7 193 191.1 192.2 192.3 "SMS01000005000000001" "SMS" 1 50000000 29.8 29.9 29.9 30 30.2 30.1 30.1 30.1 30 29.8 29.8 29.6 "SMS01000005500000001" "SMS" 1 55000000 80.7 80.6 80 80.7 80.5 80.2 80.2 80.1 80.1 79.8 79.5 79.4 "SMS01000005552000001" "SMS" 1 55520000 61.7 61.7 61.6 61.8 61.7 61.7 61.4 61.3 61.3 60.9 60.7 60.7 "SMS01000005553000001" "SMS" 1 55530000 19 18.9 18.4 18.9 18.8 18.5 18.8 18.8 18.8 18.9 18.8 18.7 "SMS01000006000000001" "SMS" 1 60000000 113.1 113.6 114.3 115.9 117 118.9 117.8 118.2 118.4 119.9 120.5 121.5 "SMS01000006054000001" "SMS" 1 60540000 53 53.1 53 54.1 54.6 55.3 54.9 55.2 55.4 55.6 55.8 56.2 "SMS01000006055000001" "SMS" 1 60550000 9.2 9.3 9.4 9.5 9.6 9.7 9.7 9.8 9.8 9.8 9.8 9.9 "SMS01000006056000001" "SMS" 1 60560000 50.9 51.2 51.9 52.3 52.8 53.9 53.2 53.2 53.2 54.5 54.9 55.4 "SMS01000006561000001" "SMS" 1 65610000 23.6 23.5 23.4 23.3 23 23 22.7 22.5 22.3 21.9 21.3 21.3 "SMS01000006562000001" "SMS" 1 65620000 108.9 109.3 109.5 109.8 110.1 111 111.4 112.1 112.6 114.2 115.9 116.2 "SMS01000007000000001" "SMS" 1 70000000 104.2 104.7 104.7 106.2 106.5 106.4 106.8 107.4 107.2 107.3 107.6 107.9 "SMS01000007071000001" "SMS" 1 70710000 16.1 16.2 16.2 15.1 14.8 14.3 14.7 14.7 14.8 14.8 14.9 15 "SMS01000007072000001" "SMS" 1 70720000 88.1 88.5 88.5 91.1 91.7 92.1 92.1 92.7 92.4 92.5 92.7 92.9 "SMS01000008000000001" "SMS" 1 80000000 60.6 60.6 60.7 60.9 61.1 61.7 61.5 61.7 62 61.9 62.2 62.1 "SMS01000009000000001" "SMS" 1 90000000 325.4 325.6 326.5 328.6 331.9 326.9 333.8 330.2 332.9 330.9 331.8 331.9 "SMS01000009091000001" "SMS" 1 90910000 66 65.7 66.4 66.3 68.7 67.3 67.3 64.7 64.2 63.8 63.7 63.7 "SMS01000009092000001" "SMS" 1 90920000 90.1 90.2 90.2 91.6 92.1 92.4 92.5 93.2 94.7 93.9 94.6 95.1 "SMS01000009093000001" "SMS" 1 90930000 169.3 169.7 169.9 170.7 171.1 167.2 174 172.3 174 173.2 173.5 173.1 "SMS02000000000000001" "SMS" 2 0 230.8 233.1 235.3 237 237.5 240.2 239.7 238.9 238.6 240 242.3 243.1 "SMS02000001000000001" "SMS" 2 10000000 13.1 13.1 13.3 13.7 14.1 14.8 14.8 14.8 14.3 14.4 14.2 14 "SMS02000002000000001" "SMS" 2 20000000 9.9 9.9 10.2 10.2 10 10.1 9.9 9.5 9.6 9.4 10 10 "SMS02000003000000001" "SMS" 2 30000000 12.4 12.4 12.9 13.7 14.5 14.5 14.3 14.4 14 14 16.3 16.8 "SMS02000004000000001" "SMS" 2 40000000 45.9 46.3 46.6 47 47.1 47.6 47.5 47.8 47.8 48.1 48.1 48.2 "SMS02000004100000001" "SMS" 2 41000000 5.4 5.5 5.5 5.5 5.6 5.6 5.6 5.5 5.4 5.5 5.5 5.5 "SMS02000004200000001" "SMS" 2 42000000 25.3 25.6 25.7 26.2 26.1 26.2 26.1 26.3 26.3 26.3 26.3 26.4 "SMS02000005000000001" "SMS" 2 50000000 5.3 5.4 5.4 5.4 5.5 5.5 5.4 5.4 5.5 5.6 5.6 5.6 "SMS02000005500000001" "SMS" 2 55000000 8 8.2 8.2 8.1 8.4 8.3 8.3 8.2 8.3 8.7 8.7 8.6 "SMS02000005552000001" "SMS" 2 55520000 4.6 4.6 4.6 4.5 4.8 4.7 4.7 4.6 4.6 4.7 4.7 4.6 "SMS02000005553000001" "SMS" 2 55530000 3.4 3.6 3.6 3.6 3.6 3.6 3.6 3.6 3.7 4 4 4 "SMS02000006000000001" "SMS" 2 60000000 19 19.1 19.5 19.8 20 20.2 19.4 19.5 19.8 20.1 20.1 20.3 "SMS02000006054000001" "SMS" 2 60540000 7.6 7.8 7.9 8 8.1 8.2 7.8 7.9 7.9 8.2 8.3 8.2 "SMS02000006055000001" "SMS" 2 60550000 . . . . . . . . . . . . "SMS02000006056000001" "SMS" 2 60560000 8.9 8.9 9 9.3 9.5 9.4 9 9.2 9.3 9.3 9.2 9.4 "SMS02000006561000001" "SMS" 2 65610000 2.1 2.1 2.2 2.1 2.2 2.2 2 2.2 2.1 2.1 2.1 2.1 "SMS02000007000000001" "SMS" 2 70000000 21.1 21 21 20.9 20.5 20.5 20.6 20.6 20.7 21.6 21.4 21.1 "SMS02000007071000001" "SMS" 2 70710000 2.6 2.6 2.6 2.2 2.1 2.2 2.2 2.2 2.3 2.3 2.4 2.4 "SMS02000007072000001" "SMS" 2 70720000 18.5 18.4 18.4 18.7 18.4 18.3 18.4 18.4 18.4 19.3 19 18.7 "SMS02000008000000001" "SMS" 2 80000000 10.1 10.1 10.1 9.8 9.2 9 9.2 9.2 9.3 9.2 9.4 9.3 "SMS02000009000000001" "SMS" 2 90000000 68.8 70.3 70.7 70.8 70.4 71.9 72.5 71.7 71.4 70.8 70.3 71.1 "SMS02000009091000001" "SMS" 2 90910000 18.7 18.9 19.1 19.1 18.9 18.8 19 18.5 18.4 18.4 18.4 18.7 "SMS02000009092000001" "SMS" 2 90920000 19.9 21.1 21.2 21.1 20.8 22.5 22.7 22.2 21.7 21.4 21.4 21.6 "SMS02000009093000001" "SMS" 2 90930000 30.2 30.3 30.4 30.6 30.7 30.6 30.8 31 31.3 31 30.5 30.8 "SMS04000000000000001" "SMS" 4 0 1473.4 1475.8 1478.5 1484.8 1488.6 1483.1 1483.6 1482.3 1485.4 1486.5 1489.5 1485.1 "SMS04000001000000001" "SMS" 4 10000000 12.4 12.4 12.5 12.4 12.4 12.5 12.6 12.6 12.8 12.7 12.8 12.9 "SMS04000002000000001" "SMS" 4 20000000 85.4 85.4 85.3 84.8 84 83.7 83.6 83.6 84.5 84.5 83.4 82 "SMS04000003000000001" "SMS" 4 30000000 177.3 177.6 177.1 176.5 176.7 176.8 177.2 176.8 176.1 175.8 175.6 174.9 "SMS04000004000000001" "SMS" 4 40000000 310.2 311.1 312.2 311.4 311.7 312.6 308.4 308.9 310.2 309.5 310.1 307.9 "SMS04000004100000001" "SMS" 4 41000000 62.9 63 62.8 62.7 62.9 62.9 62.3 62.5 62.1 61.7 61.2 60.8 "SMS04000004200000001" "SMS" 4 42000000 195.6 196.5 197.3 198 198.2 199.2 195.5 195.9 196.6 196.1 196.9 195.2 "SMS04000005000000001" "SMS" 4 50000000 32.6 32.5 32.2 33.6 33.3 33.3 33 32.9 32.7 32.5 32.5 32.1 "SMS04000005500000001" "SMS" 4 55000000 98.3 98.2 98.6 99.3 99.3 99.1 98.8 99.1 98.8 98.1 97.9 96.9 "SMS04000005552000001" "SMS" 4 55520000 65.2 65.2 65.8 66 66.1 66 66.2 66.4 66.5 65.7 65.6 65 "SMS04000005553000001" "SMS" 4 55530000 33.1 33 32.8 33.3 33.2 33.1 32.6 32.7 32.3 32.4 32.3 31.9 "SMS04000006000000001" "SMS" 4 60000000 143.4 142.3 143.5 142.8 141.8 142.6 145.7 143.8 143.6 142.8 142.6 142.1 "SMS04000006054000001" "SMS" 4 60540000 59.8 59.3 59.5 59.5 59.4 59 59.2 59.4 58.9 58.3 58.3 57.7 "SMS04000006055000001" "SMS" 4 60550000 8.8 8.9 10 9.8 9.4 9.9 9.7 8.7 8.7 8.8 8.8 9.1 "SMS04000006056000001" "SMS" 4 60560000 74.8 74.1 74 73.5 73 73.7 76.8 75.7 76 75.7 75.5 75.3 "SMS04000006561000001" "SMS" 4 65610000 12.3 12.3 12.5 12.1 12.2 12.4 12.7 12.9 12.7 12.6 12.5 12.5 "SMS04000006562000001" "SMS" 4 65620000 121.4 121.6 121.9 123 123.1 123.2 122.4 122.5 122.9 123.8 124.4 124.4 "SMS04000007000000001" "SMS" 4 70000000 158.9 159.5 159.1 159.6 159.6 159.3 158.4 158.6 159 158.8 160.3 160.2 "SMS04000007071000001" "SMS" 4 70710000 23.2 23.6 23.8 23.7 24 23.6 23 23 22.9 23.1 23.3 23.2 "SMS04000007072000001" "SMS" 4 70720000 135.7 135.9 135.3 135.9 135.6 135.7 135.4 135.6 136.1 135.7 137 137 "SMS04000008000000001" "SMS" 4 80000000 55.1 55.3 55.3 58.1 58 57.8 57.4 58 58.2 59.7 59.8 59.9 "SMS04000009000000001" "SMS" 4 90000000 266.1 267.6 268.3 271.2 276.5 269.8 273.4 272.6 273.9 275.7 277.6 279.3 "SMS04000009091000001" "SMS" 4 90910000 45.4 45.2 46.2 47.3 49.5 47.6 47.7 45.8 44.7 44.3 44.1 44.3 "SMS04000009092000001" "SMS" 4 90920000 . . . . . . . . . . . . "SMS04000009093000001" "SMS" 4 90930000 . . . . . . . . . . . . "SMS05000000000000001" "SMS" 5 0 912.5 912.3 915.7 918.2 921.4 924.2 926.8 927.7 931 927.5 928.6 928.5 "SMS05000001000000001" "SMS" 5 10000000 7.6 7.4 7.4 7.2 7.1 7.2 7.4 7.4 7.5 7.4 7.4 7.5 "SMS05000002000000001" "SMS" 5 20000000 38 37.1 36.5 37.5 37.8 39.5 38.8 38.6 39.3 38.7 39 38.3 "SMS05000003000000001" "SMS" 5 30000000 218.4 218.9 217.8 219 219.2 219.9 219.8 220.2 221.1 220 219.3 218.9 "SMS05000004000000001" "SMS" 5 40000000 194 194.4 194.1 193.6 193 193.7 194 194.5 194.1 194.1 194.8 194.7 "SMS05000004100000001" "SMS" 5 41000000 38.2 38.2 38.2 38 37.8 38 38.2 38.3 38.3 37.9 38.1 38.1 "SMS05000004200000001" "SMS" 5 42000000 104.3 104.6 104 103.8 103.4 103.7 103.8 104.2 104 104 104.4 104.4 "SMS05000005000000001" "SMS" 5 50000000 18 18.3 18.4 18.3 18.2 18.3 18.4 18.4 18.6 18.6 18.6 18.8 "SMS05000005500000001" "SMS" 5 55000000 40 40.1 40 40.2 40.1 40.3 40.2 40.3 39.9 40.1 40.1 40 "SMS05000005552000001" "SMS" 5 55520000 29.9 30 29.9 30 30 30 29.9 29.9 29.9 29.9 30 30 "SMS05000005553000001" "SMS" 5 55530000 10.1 10.1 10.1 10.2 10.1 10.3 10.3 10.4 10 10.2 10.1 10 "SMS05000006000000001" "SMS" 5 60000000 55.7 55.7 56 56.9 56.9 57.1 57.6 58.1 58 57.6 57.6 58.1 "SMS05000006054000001" "SMS" 5 60540000 17.2 17.1 17.5 17.8 17.9 18 18.1 18.1 18.2 18.1 18.2 18.2 "SMS05000006055000001" "SMS" 5 60550000 10.2 10.4 10.5 10.6 10.7 10.8 10.7 10.9 11 11.1 11.2 11.3 "SMS05000006056000001" "SMS" 5 60560000 28.3 28.2 28 28.5 28.3 28.3 28.8 29.1 28.8 28.4 28.2 28.6 "SMS05000006561000001" "SMS" 5 65610000 8 6 8.4 8.4 8.5 8.6 8.5 8.3 8.4 8.2 8.4 8.3 "SMS05000006562000001" "SMS" 5 65620000 80.9 81.3 81.5 81.9 82.3 82.7 83.5 84.1 84.4 84.8 85.1 85.4 "SMS05000007000000001" "SMS" 5 70000000 64 64.4 64.8 65.1 65.2 65.1 65.2 65.3 65.5 65.2 65 65.3 "SMS05000007071000001" "SMS" 5 70710000 6.4 6.7 6.9 7 7 7 7.1 7.2 7.1 7.2 7 7.2 "SMS05000007072000001" "SMS" 5 70720000 57.6 57.7 57.9 58.1 58.2 58.1 58.1 58.1 58.4 58 58 58.1 "SMS05000008000000001" "SMS" 5 80000000 32.9 32.9 32.9 32.9 33 33.2 33.1 33.5 33.7 34 34.2 34.3 "SMS05000009000000001" "SMS" 5 90000000 155 155.8 157.9 157.2 160.1 158.6 160.3 159 160.5 158.8 159.1 158.9 "SMS05000009091000001" "SMS" 5 90910000 22.2 22.2 23.5 22.9 24.9 23.2 23.6 22.2 22.3 22 22 22 "SMS05000009092000001" "SMS" 5 90920000 46.9 47.7 48.3 48.3 48.8 49.2 49.4 49 49.1 49 49 49 "SMS05000009093000001" "SMS" 5 90930000 85.9 85.9 86.1 86 86.4 86.2 87.3 87.8 89.1 87.8 88.1 87.9 "SMS06000000000000001" "SMS" 6 0 12491.6 12502 12502 12535.1 12552.7 12553.6 12574.1 12549.7 12543.8 12575.9 12553.9 12548 end
0 Response to reshape monthly data
Post a Comment