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   Roy Wada <roywada@hotmail.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: Format and Export(Excel) of 3-way table results
Date   Wed, 29 Jul 2009 17:48:20 -0700

 
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
 
 
> 1. using tab3way seems to give me what I wish for (see partial output
> below), but since I have to cover a space of 40 years over all the
> states, the output wraps around the result window and is very
> unsightly.
> => Is there a way for me to ask stata to export the results, so I can
> recreate a table that's more reader-friendly say in Excel?
> 
> 
> 2. Is there a way to have stata output frequencies for months that are
> above average and months that are below average for the same state on
> 2 rows in an alternating fashion (such as in the "wanted" result)?
> Wanted:
> 
_________________________________________________________________
Bing™ brings you maps, menus, and reviews organized in one place. Try it now.
http://www.bing.com/search?q=restaurants&form=MLOGEN&publ=WLHMTAG&crea=TXT_MLOGEN_Local_Local_Restaurants_1x1
*
*   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