. help reshape
tells you how. It's a -reshape long-.
Nick
On Thu, Dec 13, 2012 at 9:32 AM, Prakash Singh <prakashbhu@gmail.com> wrote:
> I have state level data for two years in two separate files and would
> like to reshape these files so that I can merge it with third file.
>
>
> the structure of the first two file is
>
> var state1 state2 state3....state30
> x x1 x2 x3 x30
> y y1 y2 y3 y30
> z z1 z2 z3 z30
>
>
> the third data file is panel data structure.
>
> I would like to reshape first two file so that I can merge it with third one.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/