Re: st: arranging columns in estout

[Laura Gibson <lgibson@asc.upenn.edu>]

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
delimiter(@)

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.

Best,
-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:
> http://repec.org/bocode/e/estout/advanced.html#advanced901
> 
> Example:
> 
> capt prog drop appendmodels
> *! version 1.0.0  14aug2007  Ben Jann





--
View this message in context: http://statalist.1588530.n2.nabble.com/st-arranging-columns-in-estout-tp4057278p7580436.html
Sent from the Statalist mailing list archive at Nabble.com.
*
*   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/