Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: estout: dodgy output in Excel


From   "Ben Jann" <ben.jann@soz.gess.ethz.ch>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: estout: dodgy output in Excel
Date   Mon, 21 Aug 2006 15:27:44 +0200

Ramani wrote:
> Freidrich - outputting as tab limited text file and converting text to
> table in Word: Stata wouldn't accept tab as an option in the syntax as
> follows:
> estout * using wage.txt, cells (b(star fmt(%9.4f)) se(par fmt(%9.4f)))
> stats(r2 N, fmt(%9.2f %9.0g) labels(R-squared)) legend varlabels(_cons
> Constant) starlevels(* 0.05 ** 0.01) prefoot("") postfoot("")
> varwidth(16) modelwidth(12) delimiter("") r tab

The tab-option would have to be specified as -style(tab)- not 
just -tab-. Anyway, -style(tab)- is the default in -estout-. There 
would be no point in adding -style(tab)- to the command above. 
Instead, delete -delimiter("")- (furthermore, I also suggest 
deleting -varwidth(16)- and  -modelwidth(12)- if the table be 
processed by excel). That is, to produce a clean, tab-delimited 
regression table, type:

 estout * using wage.txt, cells(b(star fmt(%9.4f)) se(par))
  stats(r2 N, fmt(%9.2f %9.0g) labels(R-squared)) legend 
  varlabels(_cons Constant) starlevels(* 0.05 ** 0.01) 
  prefoot("") postfoot("") replace

(Note that I also deleted -fmt(%9.4f)- within -se()- since it 
is not needed.)

> When I tried to copy, paste in Word and convert to table the ordinary
> txt file (without the 'tab' at the end), Word confused rows and
> columns so that instead of getting the variable names down one column,
> they went horizontally along with their coefficients and standard
> errors. I didn't know how to fix that.

If the estout table is tab-delimited, then Word should not have 
any problems producing a table from it (at least on my system).

> Philipp: estout would not accept brackets instead of parenthesis and
> the syntax in the help file didn't provide that option.

Type:

 estout * using wage.txt, cells(b(star fmt(%9.4f)) se(par([ ])))
  stats(r2 N, fmt(%9.2f %9.0g) labels(R-squared)) legend 
  varlabels(_cons Constant) starlevels(* 0.05 ** 0.01) 
  prefoot("") postfoot("") replace

ben

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index