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

st: 'Transposing' data


From   Shyam Kumar <mvshyamkumar@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: 'Transposing' data
Date   Tue, 30 Nov 2004 09:01:38 -0800 (PST)

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index