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?
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?
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
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.
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
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! 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, 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?
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.
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.
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.
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?
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?
Besides regression, does this also work for other time series results such as number of time lags and unit root testing?
exactly what i needed, simple but everything you need to get going :D
how about save tabe and cross table summery
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
which one would you recommend asdoc or putdocx for students or researchers
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?
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.
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
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! 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, 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: th-cam.com/video/eBdbS_A1BNk/w-d-xo.html
It does not work on bma results
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.
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.
Thank you Sir
Thank you sir