Bookmark and Share

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


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

Re: st: arranging columns in estout


From   Laura Gibson <lgibson@asc.upenn.edu>
To   statalist@hsphsun2.harvard.edu
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
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/


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