Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

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

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

From   Fred Wolfe <>
Subject   Re: st: "Best" command to output regression results
Date   Wed, 3 Nov 2010 11:35:54 -0500

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.


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


On Wed, Nov 3, 2010 at 11:07 AM, Weichle, Thomas <> 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
> *
> *   For searches and help try:
> *
> *
> *

Fred Wolfe
National Data Bank for Rheumatic Diseases
Wichita, Kansas
NDB Office  +1 316 263 2125 Ext 0
Research Office +1 316 686 9195

*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index