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

Re: st: 'Transposing' data


From   Daniel Egan <dp.egan@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: 'Transposing' data
Date   Tue, 30 Nov 2004 12:10:09 -0500

Hi Shyam, 

check out -reshape-
specifically, this looks like a -reshape wide- problem. 

Cheers, 

Dan


On Tue, 30 Nov 2004 09:01:38 -0800 (PST), Shyam Kumar
<mvshyamkumar@yahoo.com> 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.
>
*
*   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