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: arranging columns in estout

From   Laura Gibson <>
Subject   Re: st: arranging columns in estout
Date   Wed, 9 Oct 2013 07:58:52 -0700 (PDT)

I have been using appendmodels in conjunction with the estout package to make
the coefficient estimates from a series of univariate logistic regressions
with the same dependent variable appear in one stacked column rather than on
a diagonal in Excel. We ran into a bit of trouble with it when we needed to
use non-standard estimates (e.g., smaller CIs than 95%). 

One solution (for working in Excel) does not require appendmodels. It simply
changes the delimiter from tab to a character that we do not expect to show
up in the results or the variable names (e.g., @). 

*For example, for storing the 83.4% confidence intervals: 
eststo: logistic dv iv, le(83.4)
estadd r(table)
*For printing those intervals with the @ delimiter
estout using filename.csv, eform cells("b table[5] table[6]") replace

When we open the results in Excel, we can then change data from text to
columns, with the delimiter specified as "@" and checking the box for
"consecutive delimiters treated as one". 

This seemed like a useful work-around for us, and I thought it might be
useful to others as well.

-Laura Gibson
University of Pennsylvania

Ben Jann wrote
> For the result you want the model's have to be stacked, which is not
> directly supported by -estout-. However, see:
> Example:
> capt prog drop appendmodels
> *! version 1.0.0  14aug2007  Ben Jann

View this message in context:
Sent from the Statalist mailing list archive at
*   For searches and help try:

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