Re: st: "Best" command to output regression results

[Fred Wolfe <fwolfe@arthritis-research.org>]

What's best depends on what you want to do over and over again.

In general, I am usually satisfied with the regression output from
Stata. From a log file or even from a screen copy, I move all of the
results to a text editor. With a few key strokes I extract just the
regression results (this usually requires a little programming or
manipulation in the text editor). Then I paste the output into Excel,
use "Text to Columns" and an Excel formula to move the CIs together
and to properly format the number of Decimal places. This is then
pasted into MS word.

It takes a little while to figure out how to do this. But once set up
is very fast.  It's suitable for multiple tables. I also use the
method for tables of descriptive statistics. It's possible to process
many tables at once, so it is very fast. Like others, I would like
Stata to be able to make better tables and output, but until that
happens this method works best for me. I am sure other methods work
best for others.

Fred

PS. Here are my notes:

Get Coefficients (HR, OR, etc.), 95% CI, and p value for Word tables
from regression output
    Paste 7 column regression output into Excel
    Use text to column in data menu. Remove se and t, leaving 5 columns
    Do not format cells
    Insert 2 columns before P>z
    Insert P>z into Column D
    Place cursor in C2, and paste in one of the below functions,
depending on decimal points
    =CONCATENATE(FIXED(B1,1)," (",FIXED(F1,1),", ",FIXED(G1,1),")")
    =CONCATENATE(FIXED(B1,2)," (",FIXED(F1,2),", ",FIXED(G1,2),")")
    =CONCATENATE(FIXED(B1,3)," (",FIXED(F1,3),", ",FIXED(G1,3),")")
    =CONCATENATE(FIXED(B2,1)," (",FIXED(F2,1),", ",FIXED(G1,1),")")
    =CONCATENATE(FIXED(B2,2)," (",FIXED(F2,2),", ",FIXED(G1,2),")")
    =CONCATENATE(FIXED(B2,13)," (",FIXED(F2,3),", ",FIXED(G1,3),")")
    Expand function by dragging
    Copy first 4 columns to Word, and delete column 2


Fred

On Wed, Nov 3, 2010 at 11:07 AM, Weichle, Thomas <Thomas.Weichle@va.gov> wrote:
>
> Hi Statalisters,
> Is there a best command to output regression results (coefficients,
> confidence intervals)?  The -estimates table- command doesn't allow you
> to output confidence intervals; it only allows you to output stars for
> significance levels.  I came across the -estout- command and am trying
> to understand its usage.  If I have saved the logistic regression
> results using -estimates store model1-, can someone provide me an
> example to output the ORs and confidence intervals (both rounded to 2
> decimal places) in the log file?
>
> Eventually, I'd like to take the estimates and put them in a Word
> document.  Does anyone have a suggestion to do so without having to copy
> and paste each estimate into the Word document?
>
> Tom Weichle
> Math Statistician
> Center for Management of Complex Chronic Care (CMC3)
> Hines VA Hospital, Bldg 1, C202
> 708-202-8387 ext. 24261
> Thomas.Weichle@va.gov
>
> *
> *   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/



--
Fred Wolfe
National Data Bank for Rheumatic Diseases
Wichita, Kansas
NDB Office  +1 316 263 2125 Ext 0
Research Office +1 316 686 9195
fwolfe@arthritis-research.org

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