[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Elementary question
searching on "transpose" finds the -xpose- command
"Wallace, John" wrote:
> 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
* For searches and help try: