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/