About asdoc
asdoc is a Stata program that makes it super-easy to send output from Stata to MS Word. asdoc creates high quality, publication-ready tables from various Stata commands such as summarize, correlate, tabstat, tabulate (cross-tabs), regress (regressions), ttest, table, and many more.
Installation
The program can be installed by typing the following from the Stata command window:
ssc install asdoc, update
Table of contents
1. Introduction
1.1 asdoc: short introduction and examples
1.2 Commands for controlling asdoc
2. Summary Statistics
2. Summary statistics
2.1 Basic summary statistics
2.2 Customized summary statistics
3. Correlations
3.1 Correlations [Blog Post]
3.2 Correlations [YouTube Video]
3.3 Correlations with significance stars
4. Regressions
4.1 Full regression tables [YouTube Video]
4.1.1 Customizing the detailed table: Stars and CIS
4.2 Compact / nested tables (publication quality)
4.3 Regression over a grouping variable (YouTube Video)
4.4 Changing order of variables in the nested regression table
5. Frequency tables
5.1 One-way tabulation (tabulate1) Watch YouTube Video
5.2 Two-way tabulation (tabulate2) Watch YouTube Video
5.3 One- and two-way tables of summary statistics (tabsum)
5.4 Multiple-way tables (tab1)
5.5 All-possible two-way tables (tab2)
6. Compact tables (tabstat)
6.1 Without groups
6.2 With groups
7. Flexible table of statistics (table)
7.1 One-way table
7.2 Two-way table
7.3 Three-way table
7.4 Four-way table
8. T-tests
8.1 one-sample t-test
8.2 two-sample using groups
8.3 two-sample using variables
8.4 paired t-test
9. Table of means, std., and frequencies (tabsum)
10. Means
10.1 Arithmetic / harmonic / geometric means
10.2 Proportions
10.3 Ratio
10.4 Total
11. Exporting the Stata Data with the sub-command list
12. Writing matrix to a Word / RTF file
13. The survey prefix command
14. Customized tables with option row
15. Customizing Table Titles – Tips and Tricks
asdocx : Export Stata tables to Excel, LaTeX, or HTML
asdocx is an enhanced version of asdoc that provides an extensive list of improvements. It can also export to four different formats: docx, xlsx, tex, and html. To learn more about the differences between asdocx and asdoc asdocx, you may like to visit this page.
Firstly, thank you for making your Stata package available – it’s really speeding up my workflow compared to the other options available. I’m writing to make a suggestion that you consider adding an option that value labels can be reported in regression tables as well as variable labels.
I was very excited to find your wonderful asdoc Stata command. However, I am having some issues when wanting to create some tables. The Stata value labels not being copied in tab2.
For example the value labels with foreign are not copied into my Word file:
In version 2 of asdoc, I have included value lables with all tabulation commands, i.e. tabulate, tabulated2, tab1, tab2, etc. Thanks for your suggestion.
Dear Joanna
In version 2.0 of asdoc, option label has been added for the following Stata commands when using asdoc.
1. tabulate
2. tabulate2
3. tab1
4. tab2
5. regress and all other variants of regressions in Stata
You can update asdoc from SSC by:
ssc install asdoc, replace
Many thanks indeed for the “asdoc” asdoc command stata
it has helped me alot.
Thanks very nice blog
I have been telling everyone about the asdoc package who uses Stata. Several people told me how much they absolutely love it. One’s exact words were that it is “game changing” for convenience.
Found this absolutely helpful. Any chance of a MacBook version(Numbers)?
Parek Augustino: asdoc can be installed on any platform where Stata is installed.
Hello Dr. Shah,
Thank you so much for making stata help available publicly. I am trying to create a mean and median difference between two groups with test statistics (including starts). Could you help me with this?
Dear Panta
Please send your query at attaullah.shah@imsciences.edu.pk
Thank you so much! I’ll send you my query soon.
I was wondering if your asdoc program can handle survey data. I do not see the info on your blog regarding using it with the survey command (there is no hyperlink for it here: http://fintechprofessor.com) In addition,
Only one output gets put into the table when I try the following command:
Ruth-Alma: Yes asdoc can work with svy commands. Please update asdoc and it will likely solve the problem you are referring to.
I would like to say thank you for your asdoc work. I found it very helpful. But I get difficulty in applying asdoc to transfer Marginal Effect result to MS Word. All the command for regression is not applicable for Marginal Effect.
For example
…..the command
dec(3)
works herebut didn’t work in
is there any asdoc special command for transferring Marginal Effect result to Word?
Hi Mr. Shah I congratulate you for your asdoc program. Very nice program. I am grateful to you for bringing such a program to the world of science. Where can I find the text file on Youtube video? Where can I find the asdoc Stata codes? Thank you. Yours truly.
Thanks for your kind words. asdoc can be installed from within Stata when you are connected to the internet. Type the following in the Stata command window
After installation, you can find all the help and examples in the help file. To access the help file, type
Hi Dr. Shah,
I absolutely love your program, and I cannot thank you enough! I just only would like to ask how I might be able to adjust the number of stars for significance level. I would like to add asterisks with regression coefficients such that
. It would be of great help. Thank you!
Joyce Lee: I am working on a dozen of options to add to asdoc in its next update. I have noted your suggestion and would consider it in the next update.
Hi Professor, thank you for the great program. Quick question. When I try the following command (to include year dummy):
, the program says no variable named xtabond. Doesn’t the program support ‘xi:’ command yet? Thank you.
Rully: Thanks for reporting this bug. I shall try to find a workaround in the next update.
Thank you Professor. It’s a great program.
Hi Professor,
Is it possible for asdoc command to be in the foreach loop?
Jo
Yes, asdoc can be used in foreach loop. Please elaborate what do you want to get at the end of the loop?
Hi Attaullah,
Thank you very much for your help. What is the stata code when we want summary statistics by year (for a panel data) using asdoc command? How can also export the asdoc document to any directory we wanted?
Hi Attaullah,
Thank you very much for your help. What is the stata code when we want summary statistics by year (for a panel data) using asdoc command? How can also export the asdoc document to any directory we wanted?
Embaye
If you want to repeat the summary statistics by year, you can use the bysort prefix. see the following example,
For your second query, you can use the
save()
option of asdoc. So assume that you have a directory inC:/results
and you want to save the output to this directory. You would use the save option as shown below.I hope you are doing great and feeling healthy. I’m writing this to congratulate to you on your STATA Program (asdoc). I have been utilizing STATA for a long time. This is such a major achievement in STATA history. It appears to be extremely valuable for me and it has tackled a significant number of my issues. I have been working in the development sector throughout the previous five years. I have performed several nationwide survey analysis, for example, Pakistan Panel Rural Household Survey, Pakistan Agriculture Survey, Pakistan Household Skills Measurement Survey and Operational Review of the Waseela-e-Taleem Programme, and so on. As of now, I have used it with many STATA commands and it effectively sends STATA yield to MS Word in extraordinary looking tables. I again acknowledge and compliment you for this work and pray for your successful and effective future.
—
Regards
Abdul Hameed Leghari
Senior Economic Analyst
How can I remove the compounded exported output by asdoc from STATA? Thanks
SANNI
Can you please elaborate your query?
Good day sir, I exported output from Stata using asdoc and subsequently I attempted to export new output from different data, but even all those ones I initially exported were included in with new output.
I only want the exportation to be solely on a particular Data at a time, not a combination of previous data output in the ms word
OK, there are two way in which you can separate outputs from differet Stata commands:
(1) Use replace option, that will replace the existing file. However, you should have copied or renamed the file otherwise the contents of the existing file will be replaced.
(2) A better option would be to use the save(file_name) option. This way you can save each output in a sseparate file.
See this example
The above code would generate two files one with the name summary.doc and the second with the name cor.doc
Please cite asdoc in your research.
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.
Hello
I’m trying to use asdoc to save a collection of tables made with bysort and sum but it says to many variables are specified. Is it possible to use asdoc on something like
bysort 1 2: summarize 3 4 5 6 7 8
thanks
Liz
If you want to use more than one variable in the bysort prefix, then you can first group those variables into one using the
group
function ofegen
command. Then use the new variable in the bysort prefix. In the following example, I have grouped the variables rep78 and foreign and find summary statistics for all numeric variables using the new variable grouped as grouping variable.If you find asdoc useful, please cite it in your research.
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.
Dear Professor,
I am trying to use “asdoc” with tabulate command. I obtain the following error:
. asdoc tabulate implementing_jurisdiction, replace
option matrow() not allowed
r(198);
Can you please a sample of your data at attallah.shah@imsciences.edu.pk
Please also send the following info:
the version of asdoc, which can be found by typing
2. Which operating system do you use? i.e. windows, MacOs or other
3. Which Stata version
Thanks for providing the dataset. It seems the variable
implementing_jurisdiction
is a string variable. If a variable does not have value labels, the mentioned error is returned by asdoc. In order for asdoc to work, we first need to conver the variable to a numeric format with value labels. The good news is that we can do that in one line of code. In the following code, I convert the mentioned variable to numeric format and generate a new variable, callednum_ij
, then use asdoc with the new variableAnd there you go.
Please cite asdoc in your research:
Dear Attaullah Shat
I am getting the same error as Roland citing “Roland
March 21, 2019at 7:56 pm
Dear Professor,
I am trying to use “asdoc” with tabulate command. I obtain the following error:
. asdoc tabulate implementing_jurisdiction, replace
option matrow() not allowed
r(198);”
I am also getting this error: https://www.statalist.org/forums/forum/general-stata-discussion/general/1467744-using-asdoc-with-loop
astable(): 3301 subscript invalid
: – function returned error
I am using Windows 10, Stata MP 64 bit, asdoc version is -> 2.3.3.3:
Anderson
I hope the solution I presented above will also work for you. In the future updates, I shall try to add support for string variables inside asdoc, but for time being, the workaround of
encode
should effectively solve the problem.Anderson
I have fixed the error. The new version of asdoc can be installed from my site. Copy and past the following line in Stata and press enter.
net install asdoc, from(http://fintechprofessor.com) replace
Please note that the above line has to be copied in full. After installation of the new version, then restart Stata.
Please do remember to cite asdoc. To cite:
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.
Hi Sir,
Does the label option works for logit? I tried to use the label option with logit, but it doesn’t work…
Daniel:
I have checked and option
label
works fine with logit. I am using version 2.3.3.4 of asdoc. You can check your version of asdoc byAn example of option
label
with logit is given below.I am using 2.3.3.3. How could I update it ?
I used ssc install asdoc, replace, but still getting 2.3.3.3
I think the question was wrong. I get the label for continuous variables but not for categorical variables (I mean about the independent variables). Also I tried the code you provided, but I got the label values for the continuous variables, but not for the race.
Daniel
Can you please send your data and Stata code at attaullah.shah@imsciences.edu.pk
Also, please indicate in your email what is not working for you and is going against your expectations.
Dear Professor Shah,
I installed the latest version of the ‘asdoc’ ADO file. I am using Stata offline due to data confidentiality. So, the asdoc file is called from a folder in C drive.
The problem is that when I try to run different Stata commands, I keep receiving the following error:
” astable(): 3001 expected 5 arguments but received 12
: – function returned error”
In particular, the commands (e.g. “asdoc table” or “asdoc tabulate”) are executed normally by Stata and tables are created in the Stata window. However, instead of showing the “Click to Open File: Myfile.doc” line, the abovementioned error appears, so I cannot extract the tables in Word. Could you please explain why this happens and provide possible remedies? With the previous version of asdoc (November 2018), I did not face such issues.
Thank you and best wishes,
Kostas
Kostas
Since you installed asdoc manually, now it seems there are two versions of asdoc on your system, one old and new. The function library gets confused among these versions. You should first uninstall asdoc completely using the following code, then reinstall asdoc and then restart your Stata.