Given this, it is not clear that you need -reshape wide-
at all. Using -egen- with -by()- gives much more scope
for summarizing variability within regions.
Nick
[email protected]
Shyam Kumar
> Thanks for the replies.Actually I had stylized my
> problem in my post. My data set is as follows:
>
> X USA 25
> X Canada 45
> Y USA 122
> Y France 144
> Y Germany 133
>
> Basically the regions are not the same for each firm,
> and there are a vast number of regions. In addition
> I'm not interested in sales falling in each region,
> but merely the dispersion in sales across various
> regions, whatever they might be. Hence Michael's
> suggestion of using by sort works. I can merely assign
> 1, 2 for X and 1,2,3 for Y. Thanks David for your
> suggestion. I look forward to Stata 11.
>
*
* 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/