> I would like to know if -outreg2- can produce multiple formatted

> tables in a single file. I do not mean to produce multiple regression

> results in a single table as the following code shown below:

>

> I would like to have all my robustness test in a single file. Ideally, I

> would like to have two tables from the above two regressions in a

> single file.

It depends on what you want. If you want the whole thing stacked on

top of each other, then the following codes will do it for you. You

will need -dataout- from ssc. I am posting it here because you are the

second person asking for this.

If you want it cleaned up into the so-called panel format, then it can

be done by tweaking it several ways. You could make changes somewhere

after -insheet- but before -outsheet-. You now have the latest

vaporware that will do exactly what you want.

Roy

prog drop _all

prog define panelout

qui {

syntax, use(str asis) save(str asis) *

preserve

tokenize `use'

local num 0

while "``num''"~="" {

local num=`num'+1

tempfile temp`num'

insheet using myfile1.txt, noname clear

save `temp`num''

}

use `temp1',clear

forval n=2/`num' {

append using `temp`n''

}

tempfile out

outsheet using `out', noname

}

dataout using `out', save(`save') `options'

end

sysuse auto, clear

regress price mpg trunk weight length

outreg2 using myfile1, tex bdec(3) tdec(2) sdec(2) replace

regress price mpg trunk

outreg2 using myfile2, tex bdec(3) tdec(2) sdec(2) replace

panelout, save(panelstuff.txt) use(myfile1.txt myfile2.txt) excel replace

erase myfile1.txt

erase myfile2.txt

*

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