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: converting column date variables into additional observations
From
Phil Clayton <[email protected]>
To
[email protected]
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/