Output table

[Fanetti Mazakura]

Hello everyone!

I am having difficulties trying to export my summary statistics into Word. The main issue is that I have a Pilot and a Control group. I want to show the two groups separately in a single table and also include t-tests for differences in the means for all my variables. Here is an extracted table from a paper by Wang et al. 2016: Table.pdf (Either Panel A or Panel B). I am not sure if Outreg2 would work in this case.

Any help would be greatly appreciated!

Cheers

[David Radwin]

tabout (Ian Watson, SSC) will do some of this for you but not all of it. You could write Excel formulas for the rest.

outreg2 (Roy Wada, SSC) is more suited for regression models and probably won't help here, but maybe someone else has a better idea.

[Fanetti Mazakura]

Thanks, David!

I had a look at some tutorials and guides for tabout, but the syntax seems too complex for my limited Stata programming skills. If anyone could offer some help with the code I would be very grateful.

Best regards

[Attaullah Shah]

Fanetti Mazakura Making a table of summary statistics and exporting it MS Word is very simple with asdoc. Let us use the auto dataset and generate your required statistics i.e. mean, median, std. and t-statistics for selected variables i.e price, mpg, trunk, weight, and turn.

ssc install asdoc
sysuse auto
asdoc sum price mpg trunk weight turn, stat(mean median sd tstat) replace

Following is the table generated by asdoc

[Mike Smet]

Dear Attaullah,

I just discovered your asdoc program: it's really great, flexible and works with a lot of different kind of tables!

Thank you!
Kind regards,
Mike

[Attaullah Shah]

Dear Mike Smet Thanks for your kind words. If you use asdoc in your research please cite this program.

In-text citation
Tables were created using asdoc, a Stata program written by Shah (2018).

Bibliography
Shah, A. (2018). ASDOC: Stata module to create high-quality tables in MS Word from Stata output. Statistical Software Components S458466, Boston College Department of Economics.

[Jonathan Muringani]

Thank you Professor Shah, I just found your programme to be very helpful.