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 <[email protected]> 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 <[email protected]> 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/
