Many thanks to all of you who responded yesterday. The
reshape wide command seems the most applicable. I do
have an additional question though. My data set does
not contain a separate variable that I can specify
under j. Further, the number of observations (under
the j variable, if there was one) also vary. In other
words my data set is as follows:
Company identifier Sales by region
X 25
X 40
Y 125
Y 100
Y 65
I do not have a variable, region that is coded with
values 1,2,3. Also in the above example X's sales in
region 3 are 0, but there is no separate row for X for
region 3 with a value 0. Any insights on how I can
overcome these problems would be much appreciated.
Thank you once again.
Shyam
__________________________________________________
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/
