Exporting Stata to Word using putdocx
HTML-код
- Опубликовано: 15 дек 2018
- An example of using the new putdocx command to get formatted tables of Stata 16 output exported directly into a word document.
Link to "Gentle Introduction to Stata"
www.amazon.com/gp/product/159...
Link to the excellent Introduction to Econometrics Textbook by AH Studenmund:
www.amazon.com/gp/product/933...
Link to Jeffrey Wooldridge Introductory Econometrics Textbook:
www.amazon.com/gp/product/813...
My Twitter is:
/ michaelrjonas
My Google Scholar Page:
scholar.google.com/citations?...
ResearchGate:
www.researchgate.net/profile/...
Mike ~ this is so helpful! For so many Stata videos, this definitely stands out as the most helpful!
This video solve the issue of editing the resulting mess of copying Stata output and pasting in Excel or Word. Thanks Mike. Great video.
Excellent explanation, you were clear and concrete.
exactly what i needed, simple but everything you need to get going :D
Fantastic video. all my queries were answered from the previous video. A lot of videos don't explain well. You nailed it. Thank you so much. Oh, I wanted to know how to export graphs, as tables and graphs are 2 important things to export to word doc.
Thank you Sir
Besides regression, does this also work for other time series results such as number of time lags and unit root testing?
Hi MIke thanks for your help with this, is there anyway to export a regression table to word but with the Rsquared values included in the table?
Mike, I used your Stata codes as shown in your video, but failed:
putdocx clear //clear putdocx
putdocx begin //create an active.docx in memory
putdocx paragraph //add paragraph
putdocx text ("Evaluation: Mean and SD") //add the text of our title using putdocx text
univar A1-A29 //estimate results
putdocx table Table9A=etable //this step does not work
could you please give me advice or correction?
Thank you so much Mike, I faced a problem, having an alert "failed to save document". May I get your help please?
can you post the command you used? maybe I can see the problem then - thanks!
Hello!
I have a question regarding this. If I am working through cisco VPN, on the directory and I want to save it on my local computer, how can I do that? Because I am only able to save the log files on the particular working directory to which I am connected through VPN. Tried changing the work directory but no luck! Please kindly help with this. Thank you in advance:)
Hello Mike, thanks. I have two observations 1) The word document created does not include the top part of the regression output (source and statistics) 2) The output for test results(eg. using testparm command) does not show up in the word document. Can you give feedback on this?
I have the same problem 😅
Good points! And the table name is not showing up in the Word document as well?
how about save tabe and cross table summery
Hello Mike, I want to ask if this function is only applicable to exporting regression tables or is it also applicable to exporting other tables as well such as the ADF test result? If so, do I use the putdocx table Table=etable command as well as when I was trying to do this action it says info for etable not found, I wonder if there is any way to export my ADF table to word?
Thanks Mike!
Hi Justin - the 'etable' option is specific to estimation results, and it seems there is not a direct way to apply putdocx to dfuller (or many other types) output. I've seen the option of saving the table as a matrix and applying putdocx to that. A better way seems to be to use the "asdoc" .ado file. (1) ssc install asdoc (2) asdoc dfuller x. This will create a word file that you can access right from stata with your results. You can format from there, or use built-in options (I'm still working it out)
@@mikejonaseconometrics1886 Thank you for this reply. I think it would be very interesting if you could make a video on how to work with asdoc. For example, right now I am working with the mdesc and msschk packages and would like to nicely export the tables into word, but I don't have a clue.
Here you go: ruclips.net/video/eBdbS_A1BNk/видео.html
which one would you recommend asdoc or putdocx for students or researchers
Hello sir I am doing regression with bysort command at county level having different regression coefficient for each county , i want to export to excel, results for all county, which command will work to get all coefficient of regressions. Thanks
Hello! How do you call the document saved I can't find it in my Documents
Hello! The document will save to your working directory, which can be changed/set in Stata with "file" - "change working directory". Let me know if any other issues come up.
Hello Mike , thanks. However, the "putdocx table=etable" command does not work with "nestreg: reg" command. See the error report:
Command :
nestreg: reg ........
putdocx table Table1=etable
Error report:
"information for the estimation table not found;
Please replay estimation results and try again"
Could you kindly help with this. Thanks
It does not work on bma results
it is a very interesting video, but not applicable for Stata version 14.1
Yes, sorry about that - I will add to the description that this command was introduced only in Stata 15. Thanks for watching and please let me know if there are any topics you'd like to see.
Sir stata screen is not clearly visible please..
Thank you for letting me know about the technical issue. I will work on re-uploading the topic with better quality.
Thank you sir