Bookmark and Share

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]

Re: st: Reshape - Monthly data


From   "James Beard" <[email protected]>
To   [email protected]
Subject   Re: st: Reshape - Monthly data
Date   Wed, 24 Jul 2013 08:02:33 -0000

David - 

You can change your -reshape- command to:

    reshape long gdp gnp, i(id) j(monyear) string

and then convert monyear into a date variable:

    gen int monyear2 = date("01"+monyear,"DMY")
    format monyear2 %td

(You could even make a Stata "month" variable, if you wanted to).

James.
On 23 Jul 2013 at 23:43, David Ashcraft wrote:

Date sent:      	Tue, 23 Jul 2013 23:43:15 -0700 (PDT)
From:           	David Ashcraft <[email protected]>
Subject:        	st: Reshape - Monthly data
To:             	"[email protected]" 
<[email protected]>
Send reply to:  	[email protected]

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/

*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index