Statalist The Stata Listserver


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

Re: st: estout: dodgy output in Excel


From   "Ramani Gunatilaka" <ramani.gunatilaka@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: estout: dodgy output in Excel
Date   Mon, 21 Aug 2006 19:06:30 +0600

Many thanks to Friedrich, Philipp, Michael and Rodrigo for their suggestions.
I tried them all, but unfortunately none worked.
Here's what happened:
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

Stata said
option tab not allowed

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.
Philipp: estout would not accept brackets instead of parenthesis and
the syntax in the help file didn't provide that option.
Michael and Rodrigo: reformatting cells in Excel to negative numbers
or to text - tried both, neither worked.
Thanks so much for writing in. If anybody has further ideas I would be grateful.
Best,
Ramani

On 21/08/06, Friedrich Huebler <huebler@rocketmail.com> wrote:
Ramani,

You are mistaken when you write "this is not possible in Word
itself". -estout- can save output as tab-delimited text files. These
files can be converted to nicely looking tables in MS Word by copying
the text to Word, selecting the table, going to the Table menu, and
selecting Convert - Text to Table.

Friedrich

--- Ramani Gunatilaka <ramani.gunatilaka@gmail.com> wrote:
> I have used estout to tabulate my regression results. I need to get
> them into proper tabular form in Times New Roman in Word. Since
> this is not possible in Word itself, I opened up the output txt
> file in Excel.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
*
*   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/

*
*   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