(Edit: outreg2 not regout2)
Hello!
I have been trying to determine if there is an easy way to output the outreg2 results from multiple univariate regression models to a single excel sheet. Previously I was using putexcel to send the outputs of interest into a "rough" table and then combining the output results with formatting (brackets, symbols, etc) using CONCATENATE into a "good" table. This work and allowed we to run everything in one go, but was very tedious.
I found out I can get the same regression output with desired formatting using the outreg2 command, but from what I've been able to tell every outreg2 has to be a separate Excel Workbook, let alone sheet.
Is there a way to make it so each outreg2 result is exported to a new line on the same sheet, or at the very least a new worksheet in the same workbook, rather than a different workbook each time?
Thank you!
Hello!
I have been trying to determine if there is an easy way to output the outreg2 results from multiple univariate regression models to a single excel sheet. Previously I was using putexcel to send the outputs of interest into a "rough" table and then combining the output results with formatting (brackets, symbols, etc) using CONCATENATE into a "good" table. This work and allowed we to run everything in one go, but was very tedious.
I found out I can get the same regression output with desired formatting using the outreg2 command, but from what I've been able to tell every outreg2 has to be a separate Excel Workbook, let alone sheet.
Is there a way to make it so each outreg2 result is exported to a new line on the same sheet, or at the very least a new worksheet in the same workbook, rather than a different workbook each time?
Thank you!
