You should be able to work from this example.
sysuse auto, clear
cap log close
logout, save(myfile) fix excel replace: tabdisp trunk foreign , cell(rep78) stubwidth(25)
You would need to get it from ssc.
-logout- probably could use drop( ) option that will automatically
lop off the top.
Roy
>
> 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
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009
*
* 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/
