I need guidance to convert a string date to a numerical date. I tried using functions date() and monthly () but i wasn't able to solve it. I need this because I need to plot a twoway line graph.
Follows my data:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str7 date float(ore elect) "2013m1" 150.49 203.96 "2013m2" 154.63 108.69 "2013m3" 139.87 171.12 "2013m4" 137.39 97.98 "2013m5" 124.01 169.08 "2013m6" 114.81 95.5 "2013m7" 127.19 53.89 "2013m8" 137.05 69.64 "2013m9" 134.18 117.42 "2013m10" 132.57 119.12 "2013m11" 136.32 143.99 "2013m12" 135.79 123.85 "2014m1" 128.11 158.82 "2014m2" 121.37 345.59 "2014m3" 111.83 353.6 "2014m4" 114.58 368.77 "2014m5" 100.56 363.3 "2014m6" 92.85 184.66 "2014m7" 96.26 266.44 "2014m8" 94.14 313.04 "2014m9" 84.52 312.06 "2014m10" 81.3 317.06 "2014m11" 74.42 315.38 "2014m12" 68.67 227.08 "2015m1" 69.06 147.42 "2015m2" 63.8 137.78 "2015m3" 58.18 123.52 "2015m4" 52.11 127.65 "2015m5" 60.42 126.64 "2015m6" 61.84 119.87 "2015m7" 52.17 74.46 "2015m8" 57.33 41.3 "2015m9" 56.97 58.2 "2015m10" 53.66 54.79 "2015m11" 47.19 53.68 "2015m12" 40.88 29.94 "2016m1" 42.2 8.81 "2016m2" 46.48 7.67 "2016m3" 56.53 10.22 "2016m4" 60.96 13.91 "2016m5" 55.88 21.45 "2016m6" 52.34 17.94 "2016m7" 57.31 25.44 "2016m8" 60.87 36.02 "2016m9" 57.66 45.81 "2016m10" 58.95 62.83 "2016m11" 74.13 49.7 "2016m12" 79.43 36.49 "2017m1" 80.82 37.98 "2017m2" 88.96 41.39 "2017m3" 87.19 69.16 "2017m4" 70.4 118.36 "2017m5" 61.63 128.28 "2017m6" 57.86 37.84 "2017m7" 66.74 87.74 "2017m8" 74.58 160.47 "2017m9" 69.24 166.5 "2017m10" 61.05 167.13 "2017m11" 63.49 130.38 "2017m12" 71.74 71.28 "2018m1" 75.79 56.05 "2018m2" 77.65 58.1 "2018m3" 71.32 66.85 "2018m4" 66.33 32.18 "2018m5" 66.63 89.52 "2018m6" 66.86 124.96 "2018m7" 67.05 132.1 "2018m8" 68.02 128.51 "2018m9" 68.8 115.07 "2018m10" 72.02 71.22 "2018m11" 72.3 32.71 "2018m12" 68.9 20.31 "2019m1" 75.2 51.35 "2019m2" 87.59 119.15 "2019m3" 87.07 61.06 "2019m4" 94.5 46.29 "2019m5" 101.76 33.83 "2019m6" 109.55 20.35 "2019m7" 119.58 49.06 "2019m8" 93.5 58.9 "2019m9" 92.26 53.26 "2019m10" 88.58 67.02 "2019m11" 82.9 76.25 "2019m12" 90.98 55.38 end
Max
0 Response to Converting string date to date - monthly function
Post a Comment