Statalist


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

Re: st: Format and Export(Excel) of 3-way table results


From   Green Alexandra <alexandra.b.green@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Format and Export(Excel) of 3-way table results
Date   Fri, 31 Jul 2009 00:29:51 +0800

Thanks Roy for your comments. Shrinking the fonts is the first thing I
tried, which looked reasonable for my present needs. I shall try out
your first suggestion.

Regards,
Alexandra

2009/7/30 Roy Wada <roywada@hotmail.com>:
> Or you can set your fonts so small that you can't even read it
> on the screen. But it will show up correctly. You can then copy
> and paste the output from -tab3way- as you did earlier.
>
> Roy
>
>>
>> Try using -logout-. It will attempt to unwrap and export the
>> document into Excel-friendly format.
>>
>> cap log close
>> logout, save(myfile) excel replace fix(1) : tab3way state status year
>>
>> I have a feeling it'll be too complicated to unwrap accurately.
>> An alternative is to use the undocumented -tab- option in outreg2. It
>> will dump the contents into Excel format. It's explained here.
>>
>> http://www.stata.com/statalist/archive/2009-04/msg00893.html
>>
>> This option probably needs to be spun off into another program.
>>
>> I am not sure about your second question. You can try combining
>> -logout- with -table- (I think it will do n-way tabulations). See
>> the respective help files for more.
>>
>> Roy
>>
> _________________________________________________________________
> Windows Live™ Hotmail®: Search, add, and share the web’s latest sports videos. Check it out.
> http://www.windowslive.com/Online/Hotmail/Campaign/QuickAdd?ocid=TXT_TAGLM_WL_QA_HM_sports_videos_072009&cat=sports
> *
> *   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/
>

*
*   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