Automatically generating Topline Reports

[James Martherus]

I am trying to write a .do file that will generate monthly reports based on a dataset that will be updated regularly.

I figure there must be some way to generate a word document with professional looking tables of summary statistics, but I cannot figure out how to do it. I have played around with tabout, but the tables don't look very good in word. Are there some options I am not utilizing well, is there a better command to use, etc.?

Here is the code I am using:

tabout var using "document_name", append cells(freq col)

[William Lisowski]

As a start, try search microsoft and look at the results. Note especially the (apparently complex) Mata _docx functions and several techniques described in Stata Journal articles.

[Roberto Ferrer]

If an option for you, there are commands that output LaTeX tables. I prefer including those in .tex files to finally get a .ps or .pdf file.

[James Martherus]

If an option for you, there are commands that output LaTeX tables. I prefer including those in .tex files to finally get a .ps or .pdf file.

I use LaTeX quite a bit, are there any specific commands that you use for this purpose?

[Roberto Ferrer]

I have used -estout- and -tabout- before (both from SSC), and find they are enough for my past/current needs. Both have many options that allow fine customization of tables that can be exported to .tex files.

Try also -findit sjlatex- and -search latex-. The latter should point to more resources.