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

Re: st: 'Transposing' data


From   Nick Winter <nw53@cornell.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: 'Transposing' data
Date   Tue, 30 Nov 2004 12:05:33 -0500

The -reshape- command does this.

--Nick Winter

At 09:01 AM 11/30/2004 -0800, you wrote:
Hi everyone,

I have a data set of the following form:

Company name    Company Identifier   Sales by Region
X                111                 125
X                111                 135
X                111                 145
Y                222                 65
Y                222                 75
Y                222                 85

I would like to transform this into:

Company name  Identifier   Sales by region 1,2,3

X             111          125     135    145
Y             222          65      75     85

Is there any way I can do this? The transpose command
doesn't quite achieve this. Any help would be
appreciated.

Thank you.

Shyam Kumar






__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
*   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/
--------------------------------------------------------
Nicholas Winter 607.255.8819 t
Assistant Professor 607.255.4530 f
Department of Government nw53@cornell.edu e
308 White Hall falcon.arts.cornell.edu/nw53 w
Cornell University
Ithaca, NY 14853-4601

*
* 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/




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