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]

st: converting column date variables into additional observations


From   Douglas Williams <dfcwilliams@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: converting column date variables into additional observations
Date   Fri, 20 May 2011 23:44:50 -0700

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/


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