asdoc : Sends Stata output to MS Word

Nicole Martin

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.

Joanna Dipnall

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:

Oscar Briones

Many thanks indeed for the “asdoc” asdoc command stata
it has helped me alot.

Richell Onnel

Thanks very nice blog

Matthew Millard

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.

Parek Agustino

Found this absolutely helpful. Any chance of a MacBook version(Numbers)?

Attaullah Shah

Parek Augustino: asdoc can be installed on any platform where Stata is installed.

HN Panta

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?

HN Panta

Thank you so much! I’ll send you my query soon.

Ruth-Alma Turkson-Ocran

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:

foreach v of varlist married edu_cat poor2 emp_stat notcov usupl stay_us{ 
asdoc svy, subpop(if black_african==1): tab `v' sex_r, count col format(%12.0g), append
}

Gemechis Mersha

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

asdoc reg x y, replace dec(3))

…..the command dec(3) works here
but didn’t work in

asdoc margins, dydx(*), replace dec(3)

is there any asdoc special command for transferring Marginal Effect result to Word?

Dr.Öğr.Üyesi Erkan Alsu

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.

Joyce Lee

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

*** are added for p<0.05, 
** for p<0.01%, and 
* for p<0.001 level of significance

. It would be of great help. Thank you!

Rully

Hi Professor, thank you for the great program. Quick question. When I try the following command (to include year dummy):

asdoc xi: xtabond var var

, the program says no variable named xtabond. Doesn’t the program support ‘xi:’ command yet? Thank you.

Attaullah Shah

Rully: Thanks for reporting this bug. I shall try to find a workaround in the next update.

Rully

Thank you Professor. It’s a great program.

Jo

Hi Professor,
Is it possible for asdoc command to be in the foreach loop?

Embaye

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

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?

Abdul Hameed Leghari

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

SANNI OLAWALE

How can I remove the compounded exported output by asdoc from STATA? Thanks

SANNI OLAWALE

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

Liz

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

Roland

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);

Anderson

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:

Daniel

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 am using 2.3.3.3. How could I update it ?

Daniel

I used ssc install asdoc, replace, but still getting 2.3.3.3

Daniel

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.

Kostas

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

Dear Professor Shah,

Thanks for your prompt reply.
I am not the person who does the installation but the data providers do this (as I cannot access the internet from their server, but I only access the data remotely through their working space).

I can only see 2 files in the folder from which asdoc is called: 1. “asdoc.ado (ADO file)” and 2. “asdoc (Stata SMCL document)”.

Nothing is currently installed in my Stata. Every time I start Stata, I have to install Asdoc (by calling it from the folder mentioned above using the ‘findit’ command).

I was wondering whether perhaps not all necessary asdoc files are stored in that offline folder, so that is why the errors appear? For example, again when I run the “asdoc tabulate” command I receive the following error: “: 3499 asdoc_tab_onevar() not found”.

Could you please name the files that I need to have in place in order to have a complete installation of asdoc? I will then inform the data providers accordingly to download these files.

Thanks again,
Kostas

Finja

Dear Professor Shah,

for me, it is only possible to use Stata offline. Is it still possible to somehow install the asdoc command?

Thank you

Jo

Hi, I love asdoc but am getting the following problem when trying to write estat class after logistic to a word file:
————————————————–
subinstr(): 3200 conformability error
asdocrest_custom(): – function returned error
: – function returned error
r(3200);

Also, is it possible to write the confidence intervals instead of se for my nested table?
Thank you.

Jas

Dear Professor Shah,
Is it possible to use asdoc using 3sls regression?

Looking forward to your reply.

Regards
Jaskaran

Esteban Arellano

Dear professor Shah,

I am using svy with asdoc, but I am creating weighted tables with

asdoc svy: tabulate cedad csexo, count format(%14.3gc)

and I get this answer “option count not allowed”, help with this issue please.

Attaullah Shah

Esteban Arellano
Adding weighted statistics to svy command would need some good amount of coding and hence I have postponed them until I find enough time for it. Thanks for reminding.

Mike

I am trying to obtain a weighted frequency for my variable. I issued the following command:

asdoc tab var1 [aw=weights]

the command returns error, that aweight is not allowed.

Joseph N

Dear Prof Attaullah,

I would like to express my thanks for your valuable asdoc state command that I currently use for my data analysis. Very helpful and It’s saving valuable time !!

Thanks !!!

Dr. Eric Melse

Dear Dr. Shah, Attaullah,

With great interest, I am exploring your Stata package asdoc.
It offers many great options to (quickly) create result reports and tables, which is a very nice additional tool to have available with Stata.

I have a minor bug report.
Once the option save(somename) is used, the default is set to the last save name used. E.g.
sysuse auto
asdoc sum , save(sum.doc) replace
does save to sum.doc, but after that:
asdoc sum
will again (try to) save to sum.doc and not switch back to the package default Myfile.doc
I assume that you are using a global instead of a local to set the save() option (something that is discouraged).

I have some minor but practical suggestions for additional controls of asdoc.
Just the first most simple format of the summary table, create with:
sysuse auto
asdoc sum , save(sum.doc) replace
producs a table with an ’empty’ last row (see attached file sum.docx).
I am not sure why this is the case. Maybe to create some visual distance between the last row of data and the line drawn at the bottom of the table.
If that is the case, well, you could introduce options to control the formatting of the table in MSWord, using code to set Table Properties, but maybe that is ar odd’s with the simplicity & effectiveness of asdoc.
Nevertheless, to be able to set some Table Properties could be practical, like Specific Row Height and Vertical Alignment (Top/Center/Bottom).

I suppose, if the additional bottom row is intential, it would be helpful to be able to have an option to used it or not, like (no bottom row, see attached file Myfile_Without_Empty_Row.docx):
asdoc sum , nbrow

It is very nice to have the option tzok, like (see attached MydocTzok.docx):
* asdoc – current set up (all statistics have trailing zeros except N)
asdoc sum , dec(2) tzok replace

But, it would be nice to be to controlt which statistics have the get trailing zeros (given the fact that you already do this with N, like (see attached Myfile_Tzok_Selected_Statistics.docx):
* asdoc – suggested code to only tzok selected statistics
asdoc sum , dec(2) tzok(mean sd) replace

It would be helpful to be able to have an option to include a row ‘below’ the table to include a note, like (see attached Myfile_Without_Last_Empty_Row_but_With_Footnote_Row.docx):
* asdoc – suggested code to add a note row to the result table
asdoc sum , dec(2) tzok note(“{added row for note}”), replace

Maybe this is helpful (certainly for me it would).

Best regards,
Dr. Eric Melse
Amsterdam University of Applied Sciences

Yasir

Please narrate to install VAR in STATA

Lex

Dear,

Does asdoc work in Stata 16? It worked on Stata 15, but after upgrading tot Stata 16 I am receiving the following error:

ssc install asdoc

checking asdoc consistency and verifying not already installed…

the following files already exist and are different:
/Users/…../Stata/ado/plus/a/asdoc.ado
/Users/…./Stata/ado/plus/a/asdoc.sthlp
/Users/…./Stata/ado/plus/l/lasdoc.mlib

no files installed or copied
(no action taken)
r(602);

Lex

It worked, thanks! But only after I deleted manually all three files and re-run the ssc install asdoc command. For some strange reason, running the install command with ” , replace” didn’t solve the problem…

Ameer Muhammad

Salam Attaullah Sir,

Hope you are doing well. Recently i just came across asdoc package which is helpful to create amazing, meaningful tables. I have Done MSc in Epidemiology & Biostatistics from Agha khan university. Currently working as Research Specialist. In my field such commands really help to obtain a data in specific way. Well coming to the point, i would like to ask how to use Asdoc command with loops . Such as there is one loop which actually run tabulation of whole sheet. Now question is that how to use asdoc with loop to send all tables together in one go?

And another question. Please if you can guide, link or refer any best stata notes or books. Please if you have any prepared material such as do file please possible kindly share.

I will remain thankful to you

Regards

Fos

Dear Dr. Shah

I’m trying to use asdoc with svy and tabulate, ci but I can’t find the way to show confidence interval.
using:

 asdoc svy :tabulate var, ci

Where I’m doing something wrong?
Thank you

Attaullah Shah

Fos
The ci option is not yet available with svy tabulate command.

Félix Quiñones

Hello Dr. Shah,

I love to use asdoc, but I’m having problems seeing chi-square and notes in two-way tabulation (cross-tabs). I try to use something like:

 asdoc tabulate var1 var2, chi2 replace ///
       title(This is my Tittle)  ///
       notes(\i \b My first ever note is in bold and italics)

or

asdoc tab var1 var2, missing ///
      notes(Pearson chi2 =  10.3936   Pr = 0.006) ///
      save(today_2019.doc) title(This is my Tittle col chi2  

I realized that chi-square and notes does not work with the tabulate command and asdoc.

Any workaround?

Thanks,
Felix.

Elena S.

Hello! This is a great package, super useful for quick output for tab. It would be great if there was functionality to display Stata dates properly when their tabs are outputted, rather than showing the raw numerical value. Alternatively we also cannot use the string version of the date either.

Sheila Marilyn

Hi
I am new to as doc command. It is not working for me. I am using STATA 15 and Windows V 10
I type this:

as doc sum,append

and get this error:

something required
r(100);

Kindly advise

Yunzhi

Hi,

Thanks for developing such an excellent command for table-exporting.

However, would there be any chance that -asdoc- support other regression commands, such as -ivreg2-, -reghdfe-? Or more generally, -esttab- ?

Thank you
Yunzhi

Edoardo

beautiful package, extremely helpful.. thanks a lot Dr. Shah

GSingh

Request: Notes with nested regression table please. Or can you suggest an alternative?

GSingh

Thanks. This worked. But now the two sample t-test command is resulting in a one-sample t-test output in the word document (logfile results are correct). With the SSC version of asdoc I was getting the two-sample results. Please help.

Félix Quiñones

Hello Dr. Shah,

I’m using Notes for the two way tabulation. Can you make it available for one-way tabulations?

Thanks,

Félix.

Attaullah Shah

Félix Quiñones
I shall do that. Please tell me how you came to know about notes option?

Félix Quiñones

Hello Dr. Shah,

I spent a lot of time looking for a way to add notes to tables automatically on Stata without using Latex. Currently, I work for a research center and sometimes we just need to run some codes to see how the data looks like. When I found ASDOC I read every single comment on your page and every one of your responses. Then, I came around an answer that you give to Dr. Eric in July 17, 2019. After that, I just started playing with the notes. I use notes to include the Chi-Square information of the Cross-Tabs in the table, because that is not a current option of ASDOC. Will be great if you can add notes to all the different tabulations, and add the chi2 option to tab that show in the table.

I know that I’m asking a lot.

Dr. Christine Dauth

Dear Mr. Shah,

I am a researcher at the German Institute for Employment Research (IAB). I recently discovered your new Stata ado-file asdoc, which seems very helpful. I have been trying to use it, but I always get error messages.

E.g., I get the error “: 3499 asdocsum() not found” when running the following code:

clear

set obs 100

gen x = uniform()

asdoc sum, detail replace dec(3)

Co-workers of mine get the same errors. Do you have any idea what the problem might be?

MS

hi, I am trying to use asdoc to output cross tabs with column percentages. asdoc tab2 y x, col nofreq works fine except when I want to add weights. tab2 does not allow weights and asdoc tabulate y x [aw=w], col nofreq gives an error. Is it possible to export tables with asdoc with column percentages AND using weights? Thanks!!

MS

Thank you! Looking forward to it!

Felix Quinones

Hello Dr. Shah,

I just discover that column options in tabulations are not allow anymore. Anything that we can do for that?

Felix.

Rodrigo Badilla

Dear professor,

I would like report a bug that continually I get in a three way table using asdoc:

sysuse auto, clear

set seed 123
gen rbi=rbinomial(1,.5)
asdoc table rep78 foreign rbi, c(count mpg) sc col row 

Total (row) not agree with stata results.

Thanks

Rodrigo Badilla

Dear Attaullah Shah

Thanks for you reply and fix this issue! I will cite Asdoc of course!

Regards
Rodrigo.

Deonette

Dear Attaullah Shah:

Excellent program!

I am trying to save my correlation table using my own name instead of MyFile, but the save option is invalid. Can you assist?

Thank you!

Siri

Hi,

Asdoc was working perfect for me, but then suddenly i am getting this message:

asdoc_tab_twovars(): 3200 conformability error
: – function returned error
r(3200);

My STATA code is:

asdoc tab boligproblemer lavinntekt, nokey row nofreq replace

(the names of the variable are in norwegian: boligproblemer = housing issues, lavinntekt = low income)

Do you know what the problem can be?

Regards
Siri

Bishal Bharadwaj

Dear Professor Shah,
First time I am using asdoc. When I tried to export multiple tables I found the exported doc contained scripts instead of the tables. And when I updated it using the link you provided, the same command gave an error message.

func_nested_reg():  3001  expected 25 arguments but received 29
                 :     -  function returned error

I might have made some mistakes.
Thank you
Regards
Bishal

Liv

Hi!

Thank you so much for creating such an awesome program. I have greatly benefited from using asdoc (and plan to cite it in my upcoming paper).

I have a problem I have not been able to solve, however. In one my datasets/analyses, it doesn’t matter how many times I uninstall and reinstall asdoc or delete the generated .doc file – my computer repeatedly tells me that the Word document is corrupted (no matter how many times I make a new one). If I use any other dataset/do file, asdoc works fine. I’ve tried setting the working directory to something else and that doesn’t help. This all started when I accidentally tried to use asdoc before closing the open file. I assume it got corrupted somehow, but now I cannot figure out how to fix it. Any help you can offer would be most appreciated. I’m using a Mac and the latest version of asdoc.

IM

Dear Professor Shah,
I have been following some of your videos. I found command asdoc quite useful. But I am facing a problem regarding drop. I have two dummy variables: year which contains six year numbers 2014 to 2019 and industry containing names of industries (30 in total). Industry is coded as: tab industry, gen(ind) . I included year (i.year) and industry ( i.ind) in my estimation. But I don’t want coefficients in the table. When I tried drop(i.year i.ind), it does not work. Could you please help! I shall highly appreciate. Thanks, IM

George

I find this function incredibly powerful and useful. Thank you Dr. Shah. Is it possible to change it to export to MS Excel or XML instead of Word. Most of the researchers prefer their tables formatted in Excel.

Louis Boakye-Yiadom

Prof. Shah, thanks for your highly useful programme. I’m using Stata 15, and I’m trying to use the asdoc command to produce a nested table of marginal effects after executing the -probit- command. Can you please guide me to do this? Thanks.

DP

Prof, first of all, let me say thanks for this outstanding package. The ability to compile all results into a neat and single word file has greatly improved my workflow.
There is some functionality that I am missing relative to other options and I was wondering if anyone could help with this.

1 – The output struggles with labels when using interaction terms, for example if I run:
#delim ;
asdoc areg YVAR c.XVAR1##c.XVAR2 DYEAR* DLT* DPP*, a(INDUS) cl(PERMNO), add(Industry FE, Included, Firm FE, No, Package FE, No) rep(t) cnames(YVAR) fs(10) font(Times New Roman) fhr(\i) nest reset drop(DYEAR* DLT* DPP* _cons) label;

The output shows a set of empty labels for the coefficients of c.XVAR1, c.XVAR2, c.XVAR1#c.XVAR2 …

With other options such as esttab, code like this would report a neat set of interaction terms and their labels and allows to select what symbol we want for the interaction:
areg YVAR c.XVAR1##c.XVAR2 i.YEAR i.LT i.PP, a(indus) cl(FIRMID); est sto A; estadd local FP “Included”; estadd local FT “Included”; estadd local FY “Included” ; estadd local FI “Included”;
esttab A using “.\outreg_output\Table1.rtf”, replace b(3) t(2) ar2(2) noeqlines nonum nogaps nonotes compress label interaction(” \times “)
keep(XVAR1 XVAR2 “c.XVAR1#c.XVAR2”) star(* 0.10 ** 0.05 *** 0.01) scalars(“FP Purpose and Type FE” “FY Time FE” “FI Industry FE” “FF Firm FE” “FL Deal FE”);

Is there anything like this for asdoc?

2 – Is there any way to lift the restriction in the number of ‘dummies’ that we can add at the bottom of the table. As we can see from the esttab code above I’d actually want to add 5.

3 – Is there any way to lift the restriction in the number of characters in the label, when there are triple interaction terms, more space would be helpful.

Either way thanks for this amazing package.