Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: how to get the "tabdis" result in datasheet?


From   Roy Wada <roywada@hotmail.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: how to get the "tabdis" result in datasheet?
Date   Wed, 20 May 2009 12:30:15 -0700

 
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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index