st: Re: panel data management: columns to rows

["Michael Blasnik" <michael.blasnik@verizon.net>]

see -help reshape-.  Something like:

reshape wide var1 var2 var3, i(date) j(id)

should be a good start.  You can then save the wide dataset and then keep 
just the sets of variables you want and outsheet them.

Michael Blasnik
michael.blasnik@verizon.net

----- Original Message ----- 
From: "Krishna Naidoo" <krishna.naidoo@yahoo.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, June 13, 2006 1:09 PM
Subject: st: panel data management: columns to rows



> I have a simple question about rearranging my
> (balanced) panel dataset. It is currently in the form:
>
> date         id       var1    var2    var3
> 1996q1       1         56      37      83
> 1996q1       2         67      44      77
> 1996q1       3         55      67      90
> 1996q2       1         36      45      88
> 1996q2       2         68      41      92
> ...
> 2005q4       3         73      85      67
>
> I would like to obtain separate blocks of data, one
> for each variable, with either the date in columns and
> id in rows or the other way around. Ultimately I need
> to export this from Stata into excel into separate
> spreadsheets, one each for var1 var2 etc, that look
> like (of course with the relevan values in):
>
>             id1    id2    id3
> 1996q1
> 1996q2
> 1996q3
> ...
> 2005q4
>
> Or with dates and ids the otheer way around would be
> fine too. I've been trying to do this with tabstat
> manually and copy and past out but it is extremely
> time consuming as I have a large dataset. Any
> suggestions as to how to do this efficiently would be
> appreciated.
>
> Yours,
> Krishna
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/