Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | David Ashcraft <ashcraftd@rocketmail.com> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | st: Reshape - Monthly data |
| Date | Tue, 23 Jul 2013 23:43:15 -0700 (PDT) |
Hi, My data is stored in wide format for 15 years as below. id gdpjan2000 gdpfeb2000 ......gdpdec2012 gnpjan2000 gnp feb2000 ........gnpdec2012 Months are three letter and years are four digits. Now I want to convert this data into wide on month by month basis. I can do it by assuming month and year as string. Is there anyway, I can do it as numeric/date variable as I can do for year by using the following: reshape long gdp gnp, i(id) j(year) Any help will be greatly appreciated, David Ashcraft PhD Candidate Bangor University UK * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/