

Hi Statalisters,
Is there a best command to output regression results (coefficients,
confidence intervals)? The estimates table command doesn't allow you
to output confidence intervals; it only allows you to output stars for
significance levels. I came across the estout command and am trying
to understand its usage. If I have saved the logistic regression
results using estimates store model1, can someone provide me an
example to output the ORs and confidence intervals (both rounded to 2
decimal places) in the log file?
Eventually, I'd like to take the estimates and put them in a Word
document. Does anyone have a suggestion to do so without having to copy
and paste each estimate into the Word document?
Tom Weichle
Math Statistician
Center for Management of Complex Chronic Care (CMC3)
Hines VA Hospital, Bldg 1, C202
7082028387 ext. 24261
[hidden email]
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/

Administrator

On Wed, Nov 3, 2010 at 4:07 PM, Weichle, Thomas < [hidden email]> wrote:
> Hi Statalisters,
> Is there a best command to output regression results (coefficients,
> confidence intervals)? The estimates table command doesn't allow you
> to output confidence intervals; it only allows you to output stars for
> significance levels. I came across the estout command and am trying
> to understand its usage. If I have saved the logistic regression
> results using estimates store model1, can someone provide me an
> example to output the ORs and confidence intervals (both rounded to 2
> decimal places) in the log file?
>
> Eventually, I'd like to take the estimates and put them in a Word
> document. Does anyone have a suggestion to do so without having to copy
> and paste each estimate into the Word document?
My "best" way is to do this with estout (although I never use M$Word).
There is plenty of discussion on this very topic in the Statalist
archives (see URL in the bottom of Statalist mails for links to
searchable archives).
There was even a thread yesterday which touched on it and included some code.
Neil

"Our civilization would be pitifully immature without the intellectual
revolution led by Darwin"  Motoo Kimura, The Neutral Theory of
Molecular Evolution
Email  [hidden email]
Website  http://kimuranoip.org/Photos  http://www.flickr.com/photos/slackline/*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


What's best depends on what you want to do over and over again.
In general, I am usually satisfied with the regression output from
Stata. From a log file or even from a screen copy, I move all of the
results to a text editor. With a few key strokes I extract just the
regression results (this usually requires a little programming or
manipulation in the text editor). Then I paste the output into Excel,
use "Text to Columns" and an Excel formula to move the CIs together
and to properly format the number of Decimal places. This is then
pasted into MS word.
It takes a little while to figure out how to do this. But once set up
is very fast. It's suitable for multiple tables. I also use the
method for tables of descriptive statistics. It's possible to process
many tables at once, so it is very fast. Like others, I would like
Stata to be able to make better tables and output, but until that
happens this method works best for me. I am sure other methods work
best for others.
Fred
PS. Here are my notes:
Get Coefficients (HR, OR, etc.), 95% CI, and p value for Word tables
from regression output
Paste 7 column regression output into Excel
Use text to column in data menu. Remove se and t, leaving 5 columns
Do not format cells
Insert 2 columns before P>z
Insert P>z into Column D
Place cursor in C2, and paste in one of the below functions,
depending on decimal points
=CONCATENATE(FIXED(B1,1)," (",FIXED(F1,1),", ",FIXED(G1,1),")")
=CONCATENATE(FIXED(B1,2)," (",FIXED(F1,2),", ",FIXED(G1,2),")")
=CONCATENATE(FIXED(B1,3)," (",FIXED(F1,3),", ",FIXED(G1,3),")")
=CONCATENATE(FIXED(B2,1)," (",FIXED(F2,1),", ",FIXED(G1,1),")")
=CONCATENATE(FIXED(B2,2)," (",FIXED(F2,2),", ",FIXED(G1,2),")")
=CONCATENATE(FIXED(B2,13)," (",FIXED(F2,3),", ",FIXED(G1,3),")")
Expand function by dragging
Copy first 4 columns to Word, and delete column 2
Fred
On Wed, Nov 3, 2010 at 11:07 AM, Weichle, Thomas < [hidden email]> wrote:
>
> Hi Statalisters,
> Is there a best command to output regression results (coefficients,
> confidence intervals)? The estimates table command doesn't allow you
> to output confidence intervals; it only allows you to output stars for
> significance levels. I came across the estout command and am trying
> to understand its usage. If I have saved the logistic regression
> results using estimates store model1, can someone provide me an
> example to output the ORs and confidence intervals (both rounded to 2
> decimal places) in the log file?
>
> Eventually, I'd like to take the estimates and put them in a Word
> document. Does anyone have a suggestion to do so without having to copy
> and paste each estimate into the Word document?
>
> Tom Weichle
> Math Statistician
> Center for Management of Complex Chronic Care (CMC3)
> Hines VA Hospital, Bldg 1, C202
> 7082028387 ext. 24261
> [hidden email]
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search> * http://www.stata.com/support/statalist/faq> * http://www.ats.ucla.edu/stat/stata/
Fred Wolfe
National Data Bank for Rheumatic Diseases
Wichita, Kansas
NDB Office +1 316 263 2125 Ext 0
Research Office +1 316 686 9195
[hidden email]
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


Thomas < [hidden email]>:
A lot of the work happens in Word, if that is your platform. esttab
(part of estout on SSC) writes out RTF files with the rtf option
that can be easily included in a Word file using the Insert...File...
dialog in Word. See also png2rtf on SSC for a program to write
graphs to RTF, and see its help file for alternative methodsif you
are writing out a thousand graphs you may prefer Michael Blasnik's
method using a mail merge. It takes some work to set up though, so if
you only have a few tables and a few graphs it will probably not be
worthwhile to set up a mail merge. In TeX or LaTeX, you can directly
\include all kinds of things, but I don't know of a similar trick for
Word, aside from the mail merge.
On Wed, Nov 3, 2010 at 12:07 PM, Weichle, Thomas < [hidden email]> wrote:
> Hi Statalisters,
> Is there a best command to output regression results (coefficients,
> confidence intervals)? The estimates table command doesn't allow you
> to output confidence intervals; it only allows you to output stars for
> significance levels. I came across the estout command and am trying
> to understand its usage. If I have saved the logistic regression
> results using estimates store model1, can someone provide me an
> example to output the ORs and confidence intervals (both rounded to 2
> decimal places) in the log file?
>
> Eventually, I'd like to take the estimates and put them in a Word
> document. Does anyone have a suggestion to do so without having to copy
> and paste each estimate into the Word document?
>
> Tom Weichle
> Math Statistician
> Center for Management of Complex Chronic Care (CMC3)
> Hines VA Hospital, Bldg 1, C202
> 7082028387 ext. 24261
> [hidden email]
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


<>
Fred 
You can do this from estout (from SSC) without the copy/pasting, concatenating, etc.
Here's an example that will produce & open tables in Word and Excel (in Word, you'll still need to use the 'text to columns' function, unless you set up some kind of mail merge as Austin has mentioned). Also, you probably will want to play with the CI formatting in the cells() option  I'm not familiar with the Excel formulas that you describe.
If you're creating many tables, there shouldn't be any need to do this much clicking, formatting, and pasting as much of it should be able to be automated by one of the various Stata user packages designed for this purpose. outreg2 can probably do most, if not all, of what you describe as well.
*****************!
clear
sysuse auto, clear
estimates clear
**
foreach ext in xls doc {
foreach iv in mpg price headroom {
logit for rep78 length turn `iv', or
est store Model_`iv'
}
estout * using "test.`ext'", replace ///
cells("b(star fmt(3)) ci(par([ ][ ]) fmt(2)) p(fmt(2))" ) ///
stats(r2_p chi2 bic N) collabels("OR" "CI" "P>z")
/* Note: remove the quotes in the cells()
option above to stack the stats vertically
*/
//open tables in Windows or Mac OSX//
if "`c(os)'" == "MacOSX" local i open
if "`c(os)'" == "Windows" local i start
!`i' "test.`ext'"
}
*****************!
 Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
[hidden email]
Office: +979.845.6754
Fax: +979.845.0249
http://ppri.tamu.eduOn Nov 3, 2010, at 11:35 AM, Fred Wolfe wrote:
> What's best depends on what you want to do over and over again.
>
> In general, I am usually satisfied with the regression output from
> Stata. From a log file or even from a screen copy, I move all of the
> results to a text editor. With a few key strokes I extract just the
> regression results (this usually requires a little programming or
> manipulation in the text editor). Then I paste the output into Excel,
> use "Text to Columns" and an Excel formula to move the CIs together
> and to properly format the number of Decimal places. This is then
> pasted into MS word.
>
> It takes a little while to figure out how to do this. But once set up
> is very fast. It's suitable for multiple tables. I also use the
> method for tables of descriptive statistics. It's possible to process
> many tables at once, so it is very fast. Like others, I would like
> Stata to be able to make better tables and output, but until that
> happens this method works best for me. I am sure other methods work
> best for others.
>
> Fred
>
> PS. Here are my notes:
>
> Get Coefficients (HR, OR, etc.), 95% CI, and p value for Word tables
> from regression output
> Paste 7 column regression output into Excel
> Use text to column in data menu. Remove se and t, leaving 5 columns
> Do not format cells
> Insert 2 columns before P>z
> Insert P>z into Column D
> Place cursor in C2, and paste in one of the below functions,
> depending on decimal points
> =CONCATENATE(FIXED(B1,1)," (",FIXED(F1,1),", ",FIXED(G1,1),")")
> =CONCATENATE(FIXED(B1,2)," (",FIXED(F1,2),", ",FIXED(G1,2),")")
> =CONCATENATE(FIXED(B1,3)," (",FIXED(F1,3),", ",FIXED(G1,3),")")
> =CONCATENATE(FIXED(B2,1)," (",FIXED(F2,1),", ",FIXED(G1,1),")")
> =CONCATENATE(FIXED(B2,2)," (",FIXED(F2,2),", ",FIXED(G1,2),")")
> =CONCATENATE(FIXED(B2,13)," (",FIXED(F2,3),", ",FIXED(G1,3),")")
> Expand function by dragging
> Copy first 4 columns to Word, and delete column 2
>
>
> Fred
>
> On Wed, Nov 3, 2010 at 11:07 AM, Weichle, Thomas < [hidden email]> wrote:
>>
>> Hi Statalisters,
>> Is there a best command to output regression results (coefficients,
>> confidence intervals)? The estimates table command doesn't allow you
>> to output confidence intervals; it only allows you to output stars for
>> significance levels. I came across the estout command and am trying
>> to understand its usage. If I have saved the logistic regression
>> results using estimates store model1, can someone provide me an
>> example to output the ORs and confidence intervals (both rounded to 2
>> decimal places) in the log file?
>>
>> Eventually, I'd like to take the estimates and put them in a Word
>> document. Does anyone have a suggestion to do so without having to copy
>> and paste each estimate into the Word document?
>>
>> Tom Weichle
>> Math Statistician
>> Center for Management of Complex Chronic Care (CMC3)
>> Hines VA Hospital, Bldg 1, C202
>> 7082028387 ext. 24261
>> [hidden email]
>>
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search>> * http://www.stata.com/support/statalist/faq>> * http://www.ats.ucla.edu/stat/stata/>
>
>
> 
> Fred Wolfe
> National Data Bank for Rheumatic Diseases
> Wichita, Kansas
> NDB Office +1 316 263 2125 Ext 0
> Research Office +1 316 686 9195
> [hidden email]
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search> * http://www.stata.com/support/statalist/faq> * http://www.ats.ucla.edu/stat/stata/*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


<>
[correction] I left out the "eform" option in the estout command in my example to display the ORs instead of coefficients in the Excel/Word tables.
 Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
[hidden email]
On Nov 3, 2010, at 1:56 PM, Eric Booth wrote:
> <>
>
> Fred 
>
> You can do this from estout (from SSC) without the copy/pasting, concatenating, etc.
>
> Here's an example that will produce & open tables in Word and Excel (in Word, you'll still need to use the 'text to columns' function, unless you set up some kind of mail merge as Austin has mentioned). Also, you probably will want to play with the CI formatting in the cells() option  I'm not familiar with the Excel formulas that you describe.
> If you're creating many tables, there shouldn't be any need to do this much clicking, formatting, and pasting as much of it should be able to be automated by one of the various Stata user packages designed for this purpose. outreg2 can probably do most, if not all, of what you describe as well.
>
>
> *****************!
> clear
> sysuse auto, clear
> estimates clear
> **
>
> foreach ext in xls doc {
> foreach iv in mpg price headroom {
>
> logit for rep78 length turn `iv', or
> est store Model_`iv'
> }
>
> estout * using "test.`ext'", replace ///
> cells("b(star fmt(3)) ci(par([ ][ ]) fmt(2)) p(fmt(2))" ) ///
> stats(r2_p chi2 bic N) collabels("OR" "CI" "P>z")
>
> /* Note: remove the quotes in the cells()
> option above to stack the stats vertically
> */
>
>
> //open tables in Windows or Mac OSX//
> if "`c(os)'" == "MacOSX" local i open
> if "`c(os)'" == "Windows" local i start
> !`i' "test.`ext'"
> }
> *****************!
>
>  Eric
>
> __
> Eric A. Booth
> Public Policy Research Institute
> Texas A&M University
> [hidden email]
> Office: +979.845.6754
> Fax: +979.845.0249
> http://ppri.tamu.edu>
>
> On Nov 3, 2010, at 11:35 AM, Fred Wolfe wrote:
>
>> What's best depends on what you want to do over and over again.
>>
>> In general, I am usually satisfied with the regression output from
>> Stata. From a log file or even from a screen copy, I move all of the
>> results to a text editor. With a few key strokes I extract just the
>> regression results (this usually requires a little programming or
>> manipulation in the text editor). Then I paste the output into Excel,
>> use "Text to Columns" and an Excel formula to move the CIs together
>> and to properly format the number of Decimal places. This is then
>> pasted into MS word.
>>
>> It takes a little while to figure out how to do this. But once set up
>> is very fast. It's suitable for multiple tables. I also use the
>> method for tables of descriptive statistics. It's possible to process
>> many tables at once, so it is very fast. Like others, I would like
>> Stata to be able to make better tables and output, but until that
>> happens this method works best for me. I am sure other methods work
>> best for others.
>>
>> Fred
>>
>> PS. Here are my notes:
>>
>> Get Coefficients (HR, OR, etc.), 95% CI, and p value for Word tables
>> from regression output
>> Paste 7 column regression output into Excel
>> Use text to column in data menu. Remove se and t, leaving 5 columns
>> Do not format cells
>> Insert 2 columns before P>z
>> Insert P>z into Column D
>> Place cursor in C2, and paste in one of the below functions,
>> depending on decimal points
>> =CONCATENATE(FIXED(B1,1)," (",FIXED(F1,1),", ",FIXED(G1,1),")")
>> =CONCATENATE(FIXED(B1,2)," (",FIXED(F1,2),", ",FIXED(G1,2),")")
>> =CONCATENATE(FIXED(B1,3)," (",FIXED(F1,3),", ",FIXED(G1,3),")")
>> =CONCATENATE(FIXED(B2,1)," (",FIXED(F2,1),", ",FIXED(G1,1),")")
>> =CONCATENATE(FIXED(B2,2)," (",FIXED(F2,2),", ",FIXED(G1,2),")")
>> =CONCATENATE(FIXED(B2,13)," (",FIXED(F2,3),", ",FIXED(G1,3),")")
>> Expand function by dragging
>> Copy first 4 columns to Word, and delete column 2
>>
>>
>> Fred
>>
>> On Wed, Nov 3, 2010 at 11:07 AM, Weichle, Thomas < [hidden email]> wrote:
>>>
>>> Hi Statalisters,
>>> Is there a best command to output regression results (coefficients,
>>> confidence intervals)? The estimates table command doesn't allow you
>>> to output confidence intervals; it only allows you to output stars for
>>> significance levels. I came across the estout command and am trying
>>> to understand its usage. If I have saved the logistic regression
>>> results using estimates store model1, can someone provide me an
>>> example to output the ORs and confidence intervals (both rounded to 2
>>> decimal places) in the log file?
>>>
>>> Eventually, I'd like to take the estimates and put them in a Word
>>> document. Does anyone have a suggestion to do so without having to copy
>>> and paste each estimate into the Word document?
>>>
>>> Tom Weichle
>>> Math Statistician
>>> Center for Management of Complex Chronic Care (CMC3)
>>> Hines VA Hospital, Bldg 1, C202
>>> 7082028387 ext. 24261
>>> [hidden email]
>>>
>>> *
>>> * For searches and help try:
>>> * http://www.stata.com/help.cgi?search>>> * http://www.stata.com/support/statalist/faq>>> * http://www.ats.ucla.edu/stat/stata/>>
>>
>>
>> 
>> Fred Wolfe
>> National Data Bank for Rheumatic Diseases
>> Wichita, Kansas
>> NDB Office +1 316 263 2125 Ext 0
>> Research Office +1 316 686 9195
>> [hidden email]
>>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


Exactly! This is a standard tradeoff and it bites experienced users almost as much as new users, and no one has an easy answer.
Fred worked out how to do what he wanted and now can "routinize" it (a word that is ugly but accurate here): meaning, he can repeat his procedure with much less stress than when he first worked it out, and indeed vary it a bit as needed.
There are undoubtedly other ways to do it, but sometimes with a complicated command it can take you as long to understand the complicated command's way of thinking about your problem as doing it from scratch using basic tools.
It's not easy for programmers either. You can think you've designed a Swiss Army knife, with lots of useful extra bits, but to users it might look just like a Heath Robinson design.
U.S. readers: substitute "Rube Goldberg".
Other readers: sorry, I don't know other equivalents.
Nick
[hidden email]
Eric Booth
You can do this from estout (from SSC) without the copy/pasting, concatenating, etc.
Here's an example that will produce & open tables in Word and Excel (in Word, you'll still need to use the 'text to columns' function, unless you set up some kind of mail merge as Austin has mentioned). Also, you probably will want to play with the CI formatting in the cells() option  I'm not familiar with the Excel formulas that you describe.
If you're creating many tables, there shouldn't be any need to do this much clicking, formatting, and pasting as much of it should be able to be automated by one of the various Stata user packages designed for this purpose. outreg2 can probably do most, if not all, of what you describe as well.
*****************!
clear
sysuse auto, clear
estimates clear
**
foreach ext in xls doc {
foreach iv in mpg price headroom {
logit for rep78 length turn `iv', or
est store Model_`iv'
}
estout * using "test.`ext'", replace ///
cells("b(star fmt(3)) ci(par([ ][ ]) fmt(2)) p(fmt(2))" ) ///
stats(r2_p chi2 bic N) collabels("OR" "CI" "P>z")
/* Note: remove the quotes in the cells()
option above to stack the stats vertically
*/
//open tables in Windows or Mac OSX//
if "`c(os)'" == "MacOSX" local i open
if "`c(os)'" == "Windows" local i start
!`i' "test.`ext'"
}
*****************!
On Nov 3, 2010, at 11:35 AM, Fred Wolfe wrote:
> What's best depends on what you want to do over and over again.
>
> In general, I am usually satisfied with the regression output from
> Stata. From a log file or even from a screen copy, I move all of the
> results to a text editor. With a few key strokes I extract just the
> regression results (this usually requires a little programming or
> manipulation in the text editor). Then I paste the output into Excel,
> use "Text to Columns" and an Excel formula to move the CIs together
> and to properly format the number of Decimal places. This is then
> pasted into MS word.
>
> It takes a little while to figure out how to do this. But once set up
> is very fast. It's suitable for multiple tables. I also use the
> method for tables of descriptive statistics. It's possible to process
> many tables at once, so it is very fast. Like others, I would like
> Stata to be able to make better tables and output, but until that
> happens this method works best for me. I am sure other methods work
> best for others.
>
> Fred
>
> PS. Here are my notes:
>
> Get Coefficients (HR, OR, etc.), 95% CI, and p value for Word tables
> from regression output
> Paste 7 column regression output into Excel
> Use text to column in data menu. Remove se and t, leaving 5 columns
> Do not format cells
> Insert 2 columns before P>z
> Insert P>z into Column D
> Place cursor in C2, and paste in one of the below functions,
> depending on decimal points
> =CONCATENATE(FIXED(B1,1)," (",FIXED(F1,1),", ",FIXED(G1,1),")")
> =CONCATENATE(FIXED(B1,2)," (",FIXED(F1,2),", ",FIXED(G1,2),")")
> =CONCATENATE(FIXED(B1,3)," (",FIXED(F1,3),", ",FIXED(G1,3),")")
> =CONCATENATE(FIXED(B2,1)," (",FIXED(F2,1),", ",FIXED(G1,1),")")
> =CONCATENATE(FIXED(B2,2)," (",FIXED(F2,2),", ",FIXED(G1,2),")")
> =CONCATENATE(FIXED(B2,13)," (",FIXED(F2,3),", ",FIXED(G1,3),")")
> Expand function by dragging
> Copy first 4 columns to Word, and delete column 2
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


But...
esttab is the userfriendly version of the program the poster
mentions, installed along with estout from SSC, and therefore is the
obvious "easy answer" for that question. It even has its own webpage
( http://repec.org/bocode/e/estout/) with worked examples. Here are
some useful options demonstrated; the last line is specific to those
who want a MSWindows/MSWord example:
clear all
sysuse auto
qui reg foreign weight
est sto LPM
qui logistic foreign weight
est sto Logit
est sto OR
loc opt "la rtf onecell nogaps mti replace eqlabels(none)"
esttab * using r.doc, eform(0 0 1) `opt'
!start r.doc
On Wed, Nov 3, 2010 at 3:14 PM, Nick Cox < [hidden email]> wrote:
> Exactly! This is a standard tradeoff and it bites experienced users almost as much as new users, and no one has an easy answer.
> Eric Booth
> You can do this from estout (from SSC) without the copy/pasting, concatenating, etc.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


Hi Eric,
I'm using the code you provided and it seems to work fine. However, do
you know how to create a 2007 Microsoft Word document (.docx)? I simply
tried to replace the extension .doc with .docx and it doesn't work.
Also, is there a way to have the document created in landscape format
instead of portrait format? This code puts the 2 model results right
next to each other. Is there a way to put one after the other? Do you
see anything else for improvement with this code?
foreach mod in colon_post lung_post {
estimates restore `mod'
estout * using "LOGISTIC_MODELS_test3.doc", cells("b(fmt(2)) ci(par(( 
)) fmt(2)) p(fmt(3))") stats(N) legend style(fixed) eform replace label
collabels("Odds Ratio" "95% C.I." "P>z") varwidth(25) modelwidth(10)
prefoot("") postfoot("")
}
* Open tables in Windows
if "`c(os)'" == "Windows" local i start !`i' "LOGISTIC_MODELS_test3.doc"
Tom Weichle
Math Statistician
Center for Management of Complex Chronic Care (CMC3)
Hines VA Hospital, Bldg 1, C202
7082028387 ext. 24261
[hidden email]
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/


<>
My replies are included inline below:
On Nov 4, 2010, at 10:28 AM, Weichle, Thomas wrote:
> Hi Eric,
> I'm using the code you provided and it seems to work fine. However, do
> you know how to create a 2007 Microsoft Word document (.docx)? I simply
> tried to replace the extension .doc with .docx and it doesn't work.
If I change the extensions to .xlsx or .docx, Stata/estout will still output the file, but the issue seems to be that it's not in a format MS Office can understand (or possibly, some versions of MS Office can understand). Unexpectedly, I found that my setup will produce & open a .docx using your estout example, however the .xlsx file won't open  it gives me an error that the document "seems corrupt". ( & I'm not sure of the mechanics behind what estout or similar packages can or already do to make the document compatible with the new(ish) .docx/.xlsx formats ) I am using Stata MP on a MacOSX 10.6 with MS Office 2011 Business Edition.
> Also, is there a way to have the document created in landscape format
> instead of portrait format?
It doesn't appear that this is part of estout , and I've never tried getting something into landscape from Stata before, but you could probably get this capability from other packages if you wanted to avoid changing these properties manually in Word.
One suggestion is to look at some of the RTF solutions (example: Newson's rtfutil (from SSC) will let you define the papersize()).
Also, you could send the tables to smcl and then convert it to ps or pdf (Mac only) and specify some options about the page margins, font, and orientation, but that still gets you back to the issue of automation (you'd have to import/paste that into the Word document unless, again, you go to a ExceltoWord mail merge or linked document solution or use something like latex to \include the pdf/ps). Be sure to change the 'style()' in the estout to 'style(smcl)' if you pursue this option. Take a look at "translator query smcl2ps" to see the options you can change (esp. pagesize() or margins()).
Finally, latex is always a good solution when you need to automate any application of page formatting.
> This code puts the 2 model results right
> next to each other. Is there a way to put one after the other?
Yes, just run the estout commands for each model separately and use the "append" option for estout after the first one. So instead of :
estout * <using>, replace ....
separate it out into:
estout Model1 using "test.doc", replace ....
...
estout Model2 using "test.doc", append ....
...
estout Model3 using "test.doc", append ....
...
or better yet, put this in a loop:
******
cap erase "test.doc"
forval n = 1/10 {
estout Model`n' using "test.doc", append ...
}
******
 Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
[hidden email]
Office: +979.845.6754
*
* For searches and help try:
* http://www.stata.com/help.cgi?search* http://www.stata.com/support/statalist/faq* http://www.ats.ucla.edu/stat/stata/

