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

st: Re: 'Transposing' data


From   "Michael Blasnik" <michael.blasnik@verizon.net>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Re: 'Transposing' data
Date   Tue, 30 Nov 2004 12:11:49 -0500

you will need a region identifier of some type, but then it is easy using reshape:

reshape wide sales, i(name identifier) j(region)

Michael Blasnik
michael.blasnik@verizon.net

----- Original Message ----- From: "Shyam Kumar" <mvshyamkumar@yahoo.com>
To: <statalist@hsphsun2.harvard.edu>
Sent: Tuesday, November 30, 2004 12:01 PM
Subject: st: 'Transposing' data



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