Hello,
I'm trying to run models with a hefty number of independent vars in STATA and so far putexcel seems to be the best option in terms of the granularity of control and most importantly, put them in excel in different sheets (which is something sorely lacking in outreg/2 or estout).
Is there anyone who knows how to do this? I found this one post (I'm adding the link at the end) but it only discusses adding in the stars manually, which is impractical.
Thanks in advance for your help!
Best, Wameq
https://www.statalist.org/forums/forum/general-stata-discussion/general/1414399-how-to-combine-the-putexcel-with-significance-symbol-star
I've not tried it with putexcel, but putdocx will allow you to export a formatted table using "eststo" and "estimates table" first.
Here is a tutorial on basic putdocx:
https://youtu.be/rgd_frM6kKA
Here is an example of using combo of "putdocx" and "estimates table"
https://www.stata.com/stata-news/news32-3/spotlight-putdocx/
Thanks Michael R Jonas , this is helpful! I've been struggling with two things mainly:
1. Formatting the tables at a granular level for around 36 models in one go (12 tables with three models each)
2. Adding them to different sheets in the same excel file
After I couldn't find anything online, I've used a combination of xml_tab and putexcel to get my tables. Happy to share the do file if you're interested.
Hi Wameq A Raza ,
If you could, I would be very interested in taking a look at your do file.
Thank you :)
- Badges
- Science topic
- Similar topics
- Biological Science
- Kinesiology
- Running