Dear users,
I have the following data:
tract,sector,counts
1,     9,      15
2,     3,      20
3,     2,     5
3,     3,     10
3,     5,      35
I have 300 tracts, 9 sectors (1-9) and counts shows 
how many of each sector in each tract. 
I want to make them into the followign format:
tract,  sector1, 2, sector3, sec4, sec5,  ,,,, sec9
1                                               15(counts)
2                      20
3         5            10            35 
I used 
>tabdis tract sector, cell(counts)
It gives the table like the above one, then I copy the table into excel 
Any shortcut way to produce the tablelike the above one into the datasheet?
Thanks a lot!
Zoe
      
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/