How to outreg2 results from many regressions in a single table?

[Guest]

Hi,

I am running a normal OLS regression along with quantile regression (0.25, 0.50 and 0.75) and I wanted to know how to could I outreg2 their results in a single excel table.

I have tried outreg2 using but I am only able to get a single regression table. The explanatory and outcome variables are the same.

[Andrew Musau]

outreg2 is from SSC (FAQ Advice #12). Have you looked through the documentation of the command?

help outreg2

See Example # 3

Example 3. Stored estimates


You can automatically recall the stored estimates by specifying them from within outreg2. To distinguish them from the varlist, place the estlist within a pair of [square brackets].

sysuse auto,clear
regress mpg foreign weight headroom trunk length turn displacement

est store Full
regress mpg foreign weight headroom

est store Restricted1
regress mpg foreign weight

est store Restricted2
outreg2 [Full Restricted1 Restricted2] using myfile, replace see

outreg2 will take the stored estimates as wildcards (*). Try this:

outreg2[*] using myfile, see replace
outreg2 [R*] using myfile, see replace

The varlist may be combined with the estlist. The varlist will take the wildcards as well, provided they exist in the estlist.

outreg2 foreign weight[*] using myfile, see replace

If you are specifying the varlist, you must make certain the desired varlist exists in all the stored estiamtes. Since not all equations may contain the specified varlist, it is usually a poor idea
to combine the one column option with the varlist.