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