Using outreg2 to report transposed results

[Yuko Nakano]

Hi. I am using "outreg2" to report my estimation results to excel (or csv).
I estimate different models and would like to report only the results of the main independent variable of interest.

For example, I estimate the multiple models (OLS and Probit) with single main variable of interest (x1)
and multiple dependent variable of interest (y1, y2)

Model 1 : reg y1 x1 x2 x3
Model 2 :probit y1 x1 x2 x3

Model 3:reg y2 x1 x2 x3
Model 4: probit y2 x1 x2 x3

The table that I want looks like

	OLS	Probit
y1	coefficient of x1	coefficient of x1
	s.e. of x1	s.e. of x1
y2	coefficient of x1	coefficient of x1
	s.e. of x1	s.e. of x1

Is there any way to do this?
I am happy to know how to do this by using "estout" but I prefer to use outreg2.
Thank you very much for your kind assistance.

[Yuko Nakano]

Related to this, I just tried to copy the command in the Approach two of
"Flip models and coefficients (place models in rows instead of in columns)" in the following website.
http://repec.org/bocode/e/estout/adv...ml#advanced908

However, I got an error message in STATA, saying
"foreach command may not result from a macro expansion interactively or in do files".

I would be also happy if you can tell me how I can solve this problem.

[Phil Bromiley]

I'm not sure this specific layout is readily available in outreg2 (although someone else may know how to do it). You can always write the results you want into variables and then list them.

[Yuko Nakano]

Thank you very much !
I am now using "matrix list" and the output becomes somewhat near to what I want.
I will further investigate how I can improve it.

[Elisabeth Mueller]

Hi Yuko Nakano, I am looking for the exact same thing, did you find a better way to do it in the meantime? I am still wondering how this can be achieved neatly (for me, the matrix approach kind of work but it's not exactly the way I would want it ...)