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
<[email protected]> 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/
