st: Re: 'Transposing' data

["Michael Blasnik" <michael.blasnik@verizon.net>]

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/