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/
