Using asdoc is pretty easy. You need to add just asdoc as a prefix to Stata commands. For example, we use the sum command to find summary statistics of all numeric variables in the dataset. We shall add just asdoc as a prefix to sum. Let us load the auto.dta set for practice and find summary stats of all numeric variables and send the output to MS Word with asdoc
sysuse auto asdoc sum
And voila, a beautiful table of the descriptive statistic is ready [click here to see it].
And for creating a table of correlations among all numerical variables, we shall just type asdoc cor. If we were to append the results to the same file, we shall add append after the comma or leave it (append is the default, we can use replace to replace the existing file)
asdoc cor OR asdoc cor, append
More on asdoc
See also the following resources related to asdoc.
YouTube Video: Descriptive / Summary Statistics from Stata in Word with asdoc
YouTube Video: Create a publication quality table of correlation in Stata with asdoc
YouTube Video: Writing all statistics to a single Word file from Stata with asdoc
YouTube Video: Create publication quality regression tables in Stata with asdoc
This is such a useful program, it saved a lot of my time. A great breakthrough for all Stata users.
Thank you very much. I must tell you this asdoc program has made getting output from STATA very easy. You are a an academic Saint ❤ ?
I have used asdoc sum, with very good tables in Word. I have thus learnt from this forum.
Thank you very much Attaullah Shah. asdoc command can create summarize table, corr table and regression tables easily in words doc. This command safe my time a lot.
Thank you. This is completely genius and I was able to create descriptive tables in a few clicks. Saved so much time.
Can asdoc be used with imputed logistical regression as well?
Dear HCB, Thanks for your comments. Can you please provide an example data set and the format in which results are required. I will look into the possibility of doing it with the current version of asdoc. If not available in the current version, I will consider it for the next version
Firstly, I would like to thank you for the wonderful ASDOC package for Stata! It has been a tremendous help in my studies and it made me think about contributing to the Stata community when I have better understanding of the field.
Recently I have updated the package and the commands “asdoc, cells” no longer work. This is why I wondered if there were any big changes to the code and whether I could retrieve an earlier version of the asdoc.ado file. Thank you in advance!
Dear Poe
Thanks for the kind words. Version 2 of asdoc is not yet out for public testing. Perhaps you updated it from my website where I upload only trial versions for testing. Recently, I replaced option cell with the option row. Try option row instead of cells and tell me whether it solves the issu. Please do cite asdoc in your research.
Dear Attaullah,
The asdoc command is indeed very useful. But, I get two different results with and without asdoc commnad.
e.g
and
Would you please guide me what have I been doing wrong?
Dear Suman Kanougiya
Thanks for pointing this out. Yes, there was an omission of adding if condition in the asdoc code for pwcor command. I have corrected it and shall send version 2.1 soon to SSC.
In the meanwhile, you can do the following to get correct results
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.
I came across your website through the youtube videos on ASDOC programme, which I think is very helpful and exponentially better than the OUTREG programme. If you could include p-values instead of stars, it would make the program even more useful since some of the top management journals now don’t want the asterisks in the tables.
Dear Sumeet Malik
That is on my agenda for the next update. Thanks for your suggestion.
Such a brilliant and extremely useful and most impressive Stata program!
This is wonderful. Thank you!
Excellent command, asdoc!. Almost ten years ago (approximate) I asked Prof Baum of esttab estout etc author if he can do the same for descriptive stat. results be exported to word. Now time has come! I just started using STATA again (more frequently) with lots of change (in STATA 15).
Looking more options after regress command with asdoc. Example, Age as “Age in years” as we used to do in estout command after regress. Estout has several other options. Where are those with asdoc after regress? Sorry if I missed your posts.
Million Tadesse: Thanks for your comments. I would need some details on what are you proposing. Do you mean to append additional statistics to the regression table? The default option in asdoc for outputting regression tables is the detailed regression type, and there asdoc produces some additional statistics such as the mean of the dependent variables, the standard deviation of the dependent variable etc. In the nested tables, these statistics are not reported. I would appreciate if you give a link to any table that you have in mind for asdoc or email me some examples at attaullah.shah@imsciences.edu.pk
I have installed your new asdoc code. Thanks – it looks very promising.I am having a challenge using it with tabstat. Here is the code:
This is what I get:
I am getting the mean, not the other stats. Here is what it should look like:
I have tried a lot of different ways of writing the code, but keep getting the same thing.
Dear Nicola Deghaye
There are two issues with your code. First, there is a space between stat and (N mean median sem). This space should not exist. Second, the allowed statistics is semean, not sem. So the correct code would be
Please do tell me whether the problem you are referring to is solved?
Thank you so much! I am new at this and these little things trip me up so often. Thanks for taking the time to respond and for the great new code
Dear Dr Shah,
This is a follow up of my question on your website pasted below.
I was wondering for “varlabel” option to get my dummy variables (e.g. 2.Farmtyp, etc as shown above) shown in full:
Fruit crops instead of 2.farmtyp as shown above.
As you know esttab command has the capacity to write this variable in full.
Example:
legend varlabels(_cons Constant CR “Access to credit”, etc etc. basically all variables in short form can be written in full here.
So I am missing lots of useful options with asdoc for a regress command. Can we store estimates as in the above example (m1 m2) and run/display them as in esttab command?
Thanks for the excellent work on asdoc.
benfpaid
Coef.
St.Err
t-value
p-value
Sig.
AccruaAllowRevn
-0.149
0.016
-9.60
0.000
***
AccruaAllowExpn
0.151
0.019
7.97
0.000
***
RML
0.066
0.009
7.18
0.000
***
1b.Farmtyp
0.000
.
.
.
2.Farmtyp
-11600.000
3456.754
-3.36
0.001
***
3.Farmtyp
94.207
8363.845
0.01
0.991
4.Farmtyp
-52600.000
14660.636
-3.59
0.000
***
5.Farmtyp
-3761.678
13938.630
-0.27
0.787
7.Farmtyp
-33400.000
8160.412
-4.10
0.000
***
8.Farmtyp
-44600.000
16514.566
-2.70
0.007
***
9.Farmtyp
74530.888
8088.643
9.21
0.000
***
10.Farmtyp
5177.118
20400.808
0.25
0.800
11.Farmtyp
-18500.000
13459.766
-1.37
0.170
12.Farmtyp
-17700.000
7798.791
-2.27
0.024
**
_cons
17447.843
2836.525
6.15
0.000
***
Mean dependent var
21275.009
SD dependent var
61990.793
R-squared
0.381
Number of obs
1142.000
F-test
53.366
Prob > F
0.000
Akaike crit. (AIC)
27923.777
Bayesian crit. (BIC)
27994.344
*** p<0.01, ** p<0.05, * p<0.1
Note that I did not read everything on asdoc yet. Sorry if you already answered this.
Million Tadesse: Thanks for the detailed reply. If I have correctly understood your point, you want to show variable labels instead of variable names. In the recent release of asdoc, I have added the option label, that will show variable labels instead of variable names. For example, see the two regressions
Reporting variable names
Reporting variable labels
For the factor variables, you are right the option label does not work yet, and I have noted your suggestion. Since you said you have not read the asdoc help file yet, I would recommend exploring three important options that can be used with asdoc.
Detailed regression (default)
Nested regressions
Wide regressions
These are discussed with examples in post 38 on this thread on Statalist https://www.statalist.org/forums/forum/general-stata-discussion/general/1435798-asdoc-an-easy-way-of-creating-publication-quality-tables-from-stata-commands/page3
Dear Professor
Thank you so much for a great program for Stata. We are currently having big problems with Nordic characters such äöå when using label outputs. Is it something you are planning to remediate?
Scandinaven: I replied to a similar query on Statalist here – posts 45-46, where Chen Samulsion asked about the possibility of passing Chines characters from Stata to a Word file using asdoc. My reply was that getting Chinese characters in an RTF file is a pain in the neck. Usually, getting Chinese characters programmatically into an RTF file does not seem straightforward, one has to first convert the letters to Unicode and then render it properly in the RTF file.
I think similar is the case with Nordic characters. Right now, I am struggling with finding a way out.
Dear Attaullah Shah,
Thank you for stata command. May Allah bless you here and hereafter.
Dear Attaullah Shah,
Im having issues with displaying several significance level in my pwcorr table with asdoc command. Is there any way to display more than 5% sig level, e.g. sig under 1%, 10% etc.?
Secondly, even under 5%, asdoc command is giving me wrong results such as 0.3036* (this p-value is not under 5% yet asdoc in the output table shows me the star with 0.3036) .. ? the current command im using is as follow:
Where am I going wrong ? Would appreciate your input on this matter. Many thanks!
Daniel
asdoc just reproduces the output from the Stata official
pwcorr
command. Hence, it does not offer additional options. Sincepwcorr
command supports one level of significance, asdoc has the same capability.Concerning the error you are referring to, I would be interested in seeing the actual data. Can you email me that? It is unlikely, though, that asdoc will report incorrect results as it reports the results of pwcorr command directly to MS Word. Any error thereof would belong to pwcorr, not asdoc.
From your text, it seems you are referring to the correlation coefficient of .306 as the p-value? If I am right, then you are not correctly interpreting the results of pwcorr. The numeric part of the text is actually the correlation coefficient, not the p-value. The p-values are denoted by the asterisk.
I have to agree this is a great program. However, I run into issues when I run the asdoc command several times. This means that I would like to look a the table before I run the following command. I close the word doc in between. However, after a few times, I receive an error message and I am unable to use the asdoc command again.
e.g:
Up until the second last command, I am able to open the file mydocument. I close this document and run the final command.
And I receive the following error message:
If you or anyone else have any suggestions for how to solve this issue, I would be very greatful!!
Linn Gjersing
Thanks for your kind words. I have just uploaded an updated version to SSC. Please download it and try it. I hope it will solve the problem you are referring to. To download,
If the new version still does not solve the problem, then I would appreciate if you can email the following info:
1. Please type the following code in Stata and email me the output generated by it: Email: attaullah.shah@imsciences.edu.pk
2. Which Operating system are you using?
3. Can you please send me actual or example data set that generated the error.
Thanks for your cooperation.
Fantastic program, I have been looking for a way to read results into a file for a while now and this is by far the best!
However, I am trying to use the GLM command to get Risk Ratio’s and noticed that the eform option in the command doesn’t seem to work when asdoc is being used? I was wondering if this is a bug or if I am just trying to do something that cant be done?
Thanks in advance :)
Cydney
Thanks for your kind words and reporting this bug. I shall explore the issue and let you know.
Dear Professor
What about using the code: unicode convertfile oldfile.doc newfile.doc, dstencoding(Windows-1252) replace
in order to solve the unicode problem?
Scandinaven
Have you tried your suggested solution and did it work? If yes, we would be much interest in a full example having some data, asdoc code, and your final solution.
Dear Dr. Attaullah Shah,
Hope this email finds you well.
First, I would want to thank you for the great efforts in coming up with asdoc command. This is one of the powerful tools in Stata and responds to a greater need in analysis today.
I am wondering if there’s an option for modifying the title of the table. In other words, rather than the default title “Tabulation of rep78” one can either have the variable label or a customized text.
Thanks so much in advance!
Stephen Okiya
Thanks for your email and kind words. You can change the title of any table. To give a detailed reply to your question, I have just posted a blog entry on my website. You can access that here https://fintechprofessor.com/2019/05/17/asdoc-custom-table-title-ms-word-stata/
I would appreciate if you 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
.
I got some error when using asdoc, it said–> Myfile.doc could not be opened, i’m using stata 14. thanks
Wira Coy
You have not provided enough details to know the source of the problem. Can you please share:
1. The Stata code that you used with asdoc
2. An Example dataset that is causing the error.
3. Which operating system are you using? I mean Windows or macOS?
You can share the above with email attaullah.shah@imsciences.edu.pk
How can I get the one way table without cumulative percentage with asdoc?
Ram Ashish
On your request, I have added the
nocf
option to asdoc. Now with this option, asdoc will not report the cumulative frequencies column. Here is an example:The new version of asdoc can be installed from my site. Copy and paste the following line in Stata and press enter.
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.
Hello Professor,
Do you have a list of all the programs written for generating descriptive and inferential statistics in one document? Thanks for the help.
hello Dr. Shah
I have panel data, I want summary statistic by year and industry but the Stata gives an error when I enter the following command. it only runs when i choose one of them either year or industry:
number of variables in varlist must equal number of variables in generate(newvarlist)
r(198);
Currently, asdoc allows bysort prefix with only one variable. If you need to use two variables with bysort, then there is a workaround. Convert both the variables to a single variable using the
group
function of egen, and then use the new variable with asdoc. See this examplePlease 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.