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/
