[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
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:John_Wallace@affymetrix.com]
> Sent: Friday, December 06, 2002 9:07 AM
> To: 'firstname.lastname@example.org'
> 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
> 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 -
> I can't find an appropriate command. I thought -reshape- would be the
> 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
> 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
> 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: