John. You can copy and the paste special, transpose into another
spreadsheet within excel. Is the size of the datasheet the problem? Steve
> -----Original Message-----
> From: Wallace, John [SMTP:[email protected]]
> Sent: Friday, December 06, 2002 9:07 AM
> To: '[email protected]'
> Subject: st: Elementary question
>
> This sounds like a FAQ to me, but a quick look around didn't show me
> anything, so please redirect me if its covered somewhere...
>
> I have a 22,000 row x 50 column flat datasheet (Excel format) that I'd
> like
> to "transpose" so that rows become columns and vice versa. Excel clearly
> can't do it, and I'm certain that it would be simple to do it in stata -
> but
> I can't find an appropriate command. I thought -reshape- would be the
> one,
> but the syntax for it seems more complex than would be necessary. Note-I
> already saved it as a tab-delimited text file and imported it using
> -insheet-.
>
> Also, when I bring the dataset into stata, the column headers are changed
> from the category names to v2, v3, v4, etc. I tried to use -insheet using
> filename.txt, names-. This resulted in one category (with a string name)
> getting the correct header, but all the other categories (which had
> numeric
> titles) were still called v2, v3 and so on.
>
> Any advice?
>
> John Wallace
> Research Associate
> Affymetrix, Inc
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/2002
>
> *
> * 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/
The information contained in this document is intended only for the
addressee and is not necessarily the views nor the official
communication of the Department of Labour. All final/official papers
which are sent from the Department will be sent by non-electronic
means, on appropriate letterhead, signed by authorised personnel.
*
* 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/
