Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Reshape - Monthly data
From
David Ashcraft <[email protected]>
To
"[email protected]" <[email protected]>
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/