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