Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| 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/