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/