Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: converting column date variables into additional observations


From   Phil Clayton <philclayton@internode.on.net>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: converting column date variables into additional observations
Date   Sat, 21 May 2011 16:49:28 +1000

You need to -reshape long-

Phil

On 21/05/2011, at 4:44 PM, Douglas Williams wrote:

> I am currently working with BLS statistics, and i'm wanting to convert a dataset into a quasi-panel. its form is currently:
> 
> State                 County         Year      IndustryCode     January Employment      February Employment     March Employment    etc. 
> Texas                 Tyler            1999           10                                     420                                    450                                       490
> 
> 
> 
> I want it in the form of:
> 
> State        County       Year      Month       IndustryCode        Employment
> Texas         Tyler       1999     January            10                            420
> Texas          Tyler      1999     February           10                            450
> Texas          Tyler      1999      March               10                            490
> 
> 
> any ideas? thanks! 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index