Re: st: Multi-column Excel tables with 1 line after my regressions: esttab, outreg2, or another?

[Nick Winter <njgwinter@gmail.com>]

on the replace / append question, I just include the following line at 
the beginning of my do file:

capture erase -logfilename-

then -append- all results

- Nick Winter

On 10/18/2013 8:43 AM, Jen Zhen wrote:
> Dear listers,
>
> I'm looking for way to produce a readily-formatted Excel table (or at
> least one in which the results of each regression are displayed in a
> separate column, without requiring further adjustments in Excel) with
> a single one-line command to be run after my set of regressions. I've
> tried this both with Ben's -esttab- and with Roy's  -outreg2-m but
> could not get either to do exactly what I wanted:
>
> On -esttab ... file.csv-:
> When open the CSV file in Excel, either by clicking on the
> hyperlink with its name right in the Stata results window or by
> opening the saved file in Windows Explorer, I see all data in a single
> column and first need to tell Excel that at each comma the data are to
> be split into separate columns. It would be convenient if I could
> -esttab- into a format which Excel does then directly display in
> separate columns, but I have not been able to find such an output
> format for esttab. I am still running Stata 11 and currently have no
> financial resources to upgrade to a later version.
>
> On -outreg2-:
> I have thus been considering to switch from -esttab- to Roy's
> -outreg2-. However, here I find it disadvantageous that I cannot just
> compile the table with one line after all the regressions but must
> instead use a separate -outreg2 ..., append- after each regression. I
> can build that into a loop.
> But it seems that to prevent -outreg2- from adding all earlier
> regression results run in that Stata session, I need to separately
> -outreg2- my first regression with the replace option and then all
> others with the append option. But that looks very inelegant in my
> dofile. Do people know any more elegant way of doing this?
>
> Thank you so much and kind regards,
> JZ
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/