Create publication quality regression tables in Stata with asdoc

[@hiroshiono5382]

Dear Professor, thank you SO much for providing this amazing package and tutorial. You have saved me hours of tedious formatting on MS Word.

[@jaimesuarez3645]

Thanks for creating the package. On Mac it adds the tables on the same file which makes it really easy to see changes when exploring the data. I've already recommended asdoc to my peers.

[@zhangjike5469]

I used asdoc for different types of regression tables. I like the flexibility in reporting regression results. It can produce detailed, nested and wide tables and each table has a nice format and lots of options to control the output. Simply the best. I can imagine how the author might have spent hundreds of hours developing it.

[@StataProfessor]

Dr. Yasir Bin Tariq asked about adding additional statistics to the output. The additional statistics can be added using the option stat. This is documented in the help file, if you type : help asdoc##4Regressions These details are listed in Section 3.10 of the help file. 3.10 stat(stats from e()) (used only with option nest) stat() can be used to report additional regression statistics that are stored in macro e(). For example: stat (rmse, rss) Please note that each statistic should be separated by the character comma. Some of the most commonly used e() statistics of regression models are as follows: ----------------------- Statistics ------------------------ N Number of observations. Reported by asdoc as default r2 R-squared. Reported by asdoc as default r2_a Adjusted r-squared F F-statistics rmse RMSE rss Residual sum of squares ll Log-likelihood chi2 Chi-square value --------------------------------------------------------

[@YasirBinTariq]

Sir well done. This is excellent method and way more better than outreg2 or esttab. Exporting results from STATA was one messy job, and you made it quite easy.

[@lynguyen709]

Thank you so much! Your tutorial is extremely helpful!

[@richardondimu585]

Fantastic! May God give you more wisdom and knowledge.

[@SamuelJalalian]

Thank you so much! You just saved me hours of formatting tables :)

[@parispham8771]

A life-saving solution! Thank you very much!

[@AttaullahShah]

Please tell your colleagues about asdoc and subscribe to this channel for future updates

[@manisubramani8786]

Wow, asdoc is terrific. Thanks for the detailed tutorial.

[@Dr_Shiny]

Fantastic and professional. The voice looks like famous Attaullah Shah, am I right? If yes, Love and respect from Beijing China. Your fan...

[@zubiahmmad4452]

Really a high impact addition to the stata software

[@terencemark5410]

Genius my friend ...pure genius!

[@peppicola1043]

This is truly amazing and helping me so much!! Thank you!!!

[@SagangaKapaya]

This is a sharp edge to Stata additions, wow!! thanks so much prof.

[@guzmangiliglesias1318]

You are a genius, god bless you sir

[@lobokath]

Woll, this is just what I needed! Thank you for the video

[@StataProfessor]

Please subscribe and tell your friends about asdoc

[@chungkk3125]

Thanks so much! It saves me a lot time from using esttab

[@catch2209]

This is amazing. Highly recommend for easy output.

[@hiepthuc]

this is awesome! Make my life much easier. Thanks so much

[@borhansayedy3799]

You are a life saver!! Thank you!

[@ataliethompson6725]

this is awesome especially the updated package on your website

[@saburuddin7245]

Wow, creating regression table from Stata output was never that easy. Thanks

[@sumeetmalik9973]

This is so much better than outreg2. Thank you for this work! Is there a way to not report the significant stars and report the p values instead along with standard errors? Top journals are now discouraging stargazing (asterisks)...

[@StataProfessor]

Dear Sumeet Malik, thanks for the suggestion. I shall add an option in the next update to skip asterisks.

[@StataProfessor]

Dear Sumeet Malik, thanks for the suggestion. I shall add an option in the next update to skip asterisks.

[@sehrishzia4532]

can you help me plz..

[@TanveerAhmad87]

great work.....a most need addition to the stata library

[@StataProfessor]

For excluding i.year and i.location dummies, you can use the option drop(i.year i.location) option. For more details, see this detailed blog post fintechprofessor.com/2018/08/15/dropping-i-dummies-from-regression-asdoc-word-stata/

[@anwarmohd184]

Thanks, Really Helpful Sir

[@robinakouser6131]

thanks for distributing knowledge

[@BeccaKhan22]

thanks for the tutorial. If I want to report confidence intervals alongside coefficients, what would the command look like?

[@StataProfessor]

You can do this in asdocx, see this link asdocx.com/examples/regressions/nested/#sideways

[@tapangrelindis9050]

Dear professor, thanks for the very explicit explanation. I have a little challenge. I am doing multinimial regression and the asdoc command works just fine. however, when I export it to word, the values become totally different. is there some other method for MNL? thanks

[@academyofresearch735]

Appreciated. Looking forward for more videos

[@preeti9347]

great video, very helpful

[@josephjohns4626]

Can I use this set of commands with a panel regression in Stata?

[@megabinboroboro9789]

Thank you so much professor. this is absolutely life-saving. May I ask is it possible to replace standard error in the parenthesis of the nested table with p value?

[@StataProfessor]

In response to your request, I have updated asdoc to include p-values in the nested tables. Please see this post for more details fintechprofessor.com/forums/topic/how-to-report-p-values-in-asdoc-nested-table/

[@sophieayling6126]

thank you this is very helpful. I am wondering how I can specify value labels in a nested table output? It is currently outputting with the number of the value label but not the value name itself. e.g. 1 bn.gender 2. gender instead of 1.bn male 2. female. Grateful for your clarification

[@StataProfessor]

Have you tried the label option. If it does not work, then you may try asdocx which has all these missing features fintechprofessor.com/asdocx/

[@viveksarati]

Hi prof. Is it okay if your control variables to be omitted due to collinearity in multiple regression whilst using asdoc?

[@ahmetozkardas7301]

Thank you, this video helped a lot

[@Mauriciodesc]

Hi! Can we use "asdoc" with "teffects" and "eteffects" ? I have already tested but the exported table loses its nicely formatation and the option "nest" seems not to work though. Thank you!

[@omersarigul92]

Dear Professor thanks a lot, could you also explain the text addition please

[@zubiahmmad4452]

Is there asdoc for sem models? Thanks

[@shahrzadtarrahi2041]

Thank you so much!

[@syedtauseefali1869]

Thank you sir, you have made a very messy task very comfortable. If I compare it with outreg, outreg2 and estout package then your work is far better. But one question, I think we can not use it for other tests like “xttest3”, “xttxt0”, “xtserial” ,“vif”, “pesaran” , and stationarity tests. How to use sir “asdoc” in those tests? Thanks once again

[@StataProfessor]

Dear Syed Tauseef Ali Thanks for your kinds words. The mention tests generate one line or two lines of results. Therefore, they can be easily appended to the Word document created by asdoc by using the option text(), see the help file for more details. Please note that three is a built-in mechanism for the results of VIF command in asdoc, so this one does not need any further coding.

[@goaljason1813]

Thank you so much for this, saved lots of time for me. One quick question, how to show label name of categorical variables (e.g. INDUSTRY) in your example by using i.INDUSTRY n the regression instead of creating dummies explicitly for each value of INDUSTRY, like what is used in your example. Any suggestion will be deeply appreciated.

[@AttaullahShah]

Thanks for the suggestion. I shall work on it. Please cite asdoc in your work. 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.

[@fidanabdullaeva5128]

Thank you very much it helped a lot! I have one problem. I am estimating the fixed-effects and got Pseudo R^2 equal to .z instead of the normal one. Do you know the reason? How can I fix it?

[@econometricsokonometrisch2518]

because there is not Pseudo R square for this model. Check original results.

[@Asadkhan-xt8gs]

Can we use "asdoc" with "ivreg2"??

[@agnesonyango4188]

I tried using asdoc , nest command in Hierarchial regression.l get the output in word, but my models are not in one table.Does asdoc work hireg command in stata ?

[@AttaullahShah]

Agnes : Support for hireg is not yet added to asdoc.

[@mark12345680]

Hi Professor, I have a question about running a regression model for multiple year, how do you get a table that will show the coefficients for each year? For instance, my sample data runs from 1966 to 2019, how do I get a table that will output the coefficient by year?

[@AttaullahShah]

This is a case of regressions over groups. Here the grouping variable is the year. In this video kzbin.info/www/bejne/qJy4hmqLnt6aeLc, I show group-wise regressions for companies, however, you can replace companies with years. Specifically, try the wide option, that is shown towards the end of the video.

[@mark12345680]

@@AttaullahShah Thank you for your reply Attaullah, I tried to run a regression grouped by year. I checked my variables with the tutorial, my variables are float variables, same as the tutorial's data. I could make a nice table with the tutorial data. However, when I ran with my own sample, the myfile.doc shows a bunch of nonsense.. Any idea what may cause this? Sorry to bother again.

[@mark12345680]

When I open the Myfile.doc, I am looking at these error messages \cellx2300 \fs20\pard\intbl\ql {Mean dependent var}\cell \cellx4050 \fs20\pard\intbl\qr {0.501}\cell \cellx6350 \fs20\pard\intbl\ql {SD dependent var }\cell \cellx8100 \fs20\pard\intbl\qr {0.576}\cell ow}

[@soobinchoi9083]

Thank you for this great package. I just tried to use it with "mi estimate" and it did not work. Is there any way to use this package with mi?

[@annayu2438]

I am wondering how to report t stat in the parenthesis rather than the standard error which seems default in asdoc.

[@StataProfessor]

I think you are asking about nested tables. In the options, add rep(t). For example, sysuse auto asdoc reg price mpg, rep(t) replace nest asdoc reg price mpg length , rep(t) nest

[@박현준-m1j]

Thank you professor. may i ask a question? I want use reg's command that is (i.time) (i.location). Then i need to drop time and location dummy in word by using asdoc. but if i type the command, it will occur the error. how do i do it?

[@StataProfessor]

For excluding i.year and i.location dummies, you can use the option drop(i.year i.location) option. For more details, see this detailed blog post fintechprofessor.com/2018/08/15/dropping-i-dummies-from-regression-asdoc-word-stata/

[@MrCandemir]

Can you share the codes that appear in the notepad file you are preparing a video?

[@YasirBinTariq]

How to add information/result like adjusted R square, F-Statistics or Chi-2 Statistics, their p-values etc. in the regression tables. By default it is giving number of observations and R-squared(not giving it in fixed-effects) only.

[@StataProfessor]

Dear Dr. Yasir Bin Tariq, thanks for your comments. The additional statistics can be added using the option stat. This is documented in the help file, if you type : help asdoc##4Regressions These details are listed in Section 3.10 of the help file. 3.10 stat(stats from e()) (used only with option nest) stat() can be used to report additional regression statistics that are stored in macro e(). For example: stat (rmse, rss) Please note that each statistic should be separated by the character comma. Some of the most commonly used e() statistics of regression models are as follows: ----------------------- Statistics ------------------------ N Number of observations. Reported by asdoc as default r2 R-squared. Reported by asdoc as default r2_a Adjusted r-squared F F-statistics rmse RMSE rss Residual sum of squares ll Log-likelihood chi2 Chi-square value --------------------------------------------------------

[@YasirBinTariq]

Thank you so much.

[@YasirBinTariq]

One more question? Does asdoc support quietly function?

[@StataProfessor]

In some commands yes, such as sum reg cor. However, asdoc converts the log output from some commands, in such cases qui cannot be used such as ameans, tab, etc.

[@YasirBinTariq]

Thank you

[@MuhammadMoiz91]

Thank you so much! I am using asdoc now... Can you please provide a link to your LinkedIn profile somewhere?

[@shuoguo5345]

Dear Stat Professor, I am having trouble putting various regression tables together and the error seems to be cluster(locid), when I type this in, it says option cluster() not allowed, I am doing gls regressions. Please let me know if you know how to resolve this error!! thank you so much

[@StataProfessor]

Can you please post the code line that generates the given error?

[@StataProfessor]

If you like asdoc, you shall like asdocx even more. asdocx can export to Excel and has tons of other features, see this link for details fintechprofessor.com/asdocx/

[@MukeshKumar-ln1iv]

hii sir thanks for developing such a wonderful 'asdoc' package, in the current exercise where did you defined the 'stars' for level of significance, could you reply, please

[@StataProfessor]

I used the defaults. i.e when you do not specify stars. However, you can set your own stars using setstars option, you can read about it here fintechprofessor.com/2018/12/19/asdoc-cutomizing-the-regression-output-ms-word-from-stata-confidence-interval-adding-stars-etc/, read point 4 there

[@Snipedddd]

The regression values asdoc displays in Word are different from what I see in the stata output, what am I doing wrong?

[@AttaullahShah]

Please post the full asdoc command here or email me at [e-mail]

[@tapangrelindis9050]

same for me

[@victorosei677]

Such a great contribution to the stata world. Please can you share your do file?

[@AttaullahShah]

Please subscribe to the channel. I shall try to find it and share with you.

[@StataProfessor]

Shahzad Khan has asked :I am using three regression with same dependent and controls but with different independent . I don’t know how to make make a table of it. Note.: I can not use all independent in same model" . A provide a breif answer in this blog post fintechprofessor.com/creating-a-nested-regression-table-with-asdoc-in-stata/

[@germansverdlov3196]

THANK YOU!!!

[@IMzz12]

Thank you

[@Palaund]

Thank you!

[@clem2248]

Hi, it says that the nest option is not valid.. Help please :)

[@StataProfessor]

Please provide more details. What was the exact Stata code that you typed and what was the error message shown on the Stata screen.

[@viktoriadome4057]

Hi Professor Thank you very much for the video. I would like to ask you about the add (dummy, yes) command because STATA keeps returning an error: invalid 'yes' r(198) and I cannot seem to figure out why. I hope you will be able to help me. Please see my command here: asdoc probit H1 J7A SIZE FOREIGN1 STATEOWN1 EXPORTER COMPETITORS COMPETITORS_binary MANEXP SUR VEYt i.a0 i.countrynew, nest drop(i.a0 i.countrynew) add (Industry dummies, yes, Country dummies, yes) I also tried: ... replace add (Industry dummies, yes, Country dummies, yes) but my attempt has also been unsuccessful. Thanks for your help in advance. Kind Regards Viktoria