Hi Steve:
Excel can only handle 256 columns of data (and 65536 rows). The dataset I'm
working with has 22,000 rows, so transposing it to columns is out of the
question within excel. Finally, I'll need to perform anovas and oither
statistical tests on that data, which Stata is obviously better at than
Excel.
-JW
-----Original Message-----
From: Steven Stillman (LMPG) [mailto:[email protected]]
Sent: Thursday, December 05, 2002 8:38 PM
To: '[email protected]'
Subject: st: RE: Elementary question
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/
---
Incoming 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
---
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/
