Export Coefficients to Excel

[asoler]

Hi everyone,

I need to do 300 simple regressions (y=a+bx+e) in Stata 13. So far no problem. Now the relevant result that is relevant for my paper is just one Coefficient (b). I could just copy them by hand into my excel sheet. Is there an easier way?

Thannks asoler

[Mitch Abdon]

if you are using Stata 13, you may use -putexcel- to grab the coefficient of varname which is stored in _b[varname] and paste it directly to excel. see -help putexcel- and -help system variables-. you may also checkout this post.

[Sergiy Radyakin]

There are alternatives. Whether they are easier, it's up to you. If your result is one number - just write it to a text file. It is not worth the trouble of formatting it. Excel will be happy to open a tab-delimited file.
Best, Sergiy Radyakin

[asoler]

Thanks a lot!