Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Elementary question

From   "Wallace, John" <[email protected]>
To   "'[email protected]'" <[email protected]>
Subject   st: Elementary question
Date   Thu, 5 Dec 2002 12:06:48 -0800

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

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 (
Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/2002
*   For searches and help try:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index