Proper titles for outreg2 output table

[Michael Foreman]

Dear Stata users,

I am trying to export summary statistics using outreg2 function with the following code:

outreg2 using Summary_statistics, replace sum(log) keep($controls) label excel title(Descriptive Statistics)

It creates a summary statistics table and exports it in Excel. I would like to ask how I can change the column headers from "mean, sd, min, max" to "Mean SD Min Max" and remove the row with the column numbers (1) (2) (3) (4) (5) (please see the header I have attached). I've tried "ctitle()" but that option adds more titles to the table overall and does not change column titles. Thank you for any help.

[Attaullah Shah]

I am not sure how to do it outreg2. I can refer you to asdoc that can create descriptive statistics and output tables from other Stata commands. Here is one simple example

ssc install asdoc
sysuse auto
asdoc sum, replace

If you want the table in Excel, you can copy and paste if from the Word into Excel or wait for the premium version of asdoc ( updates are here )
You can also watch this Youtube video https://www.youtube.com/watch?v=zdI65G6AhdU
For those who are not yet familiar with asdoc, asdoc can be downloaded from SSC and can be used with almost all Stata commands. Here is a short blog post that shows how asdoc can be used with any Stata command http://fintechprofessor.com/2018/02/...basic-example/. You can also watch several YouTube videos that show the use of asdoc https://www.youtube.com/watch?v=zdI6...LwodAk2oqLYhr-

* For installation of the stable version
ssc install asdoc

* For installation of the new beta version
net install asdoc, from(http://fintechprofessor.com) replace
help asdoc

[Michael Foreman]

Thank you for your reply, Attaullah. I am looking for an automated way to extract descriptive statistics into an excel file. If i were to use asdoc, is there an automatic way to do this? Also, is possible to change column titles and use variable labels in asdoc?

Thank you for your help.

[Attaullah Shah]

The current version of asdoc does not export to excel, but its next version asdocx will. And yes for labels.

sysuse auto
asdoc sum, replace label

[Michael Foreman]

Thank you, Attaullah, I'll give a try. Is it possible to change column titles manually, e.g. change "Std. Dev." to "SD" etc.?

[Fien van Solinge]

Hi Michael Forman,

Did you ever find a solution to your problem? I am having the same problem when exporting regression output to LaTEX.

Thanks,

Fien

[Attaullah Shah]

Regression output to LaTeX is supported in asdocx.

[Serge Francisco]

Hello Dr Attaullah Shah....I am interested to purchase a one-year licence of asdocx to convert my outputs in Stata to Word?Excel...how do i proceed?

[Nick Cox]

Serge Francisco #7 gives you a link to order right now.