Re: st: 'Transposing' data

[Nick Winter <nw53@cornell.edu>]

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/