Using PUTEXCEL to export Stata output to MS Excel

[@Owanango]

Why does stata complicate it. Why not just allow users to export the entire results into excel and they can format in there like SPSS and other products

[@behnamghorbanichenari1565]

Hi ... You may like to watch this kzbin.info/www/bejne/equqXpaOmKZmnpY

[@rapmantheoneman]

This is an amazing explanation. Thank you, Mike! At the same time this is not very user friendly-just to export without all of this manipulation-I hope STATA can make this easier for those not so savvy

[@michaeljosvawchristensen1856]

How can you use it with a loop? Thx for the tutorial

[@eloisedricotdagneau3712]

When I put: putexcel A10='Hi', STATA tells me 'Hi' invalid name... Any advice?

[@rao8559]

use double quotes

[@boniphace1]

Mike you are amazing.Kindly take us through any simulation model like General Equilibrium Model

[@mikejonaseconometrics1886]

Joshua, Thank you for watching, and for the kind words. I probably won't have a chance to do a simulation topic soon, but will keep it in mind. I'm working on time-series topics for now, so let me know if anything would be helpful in that area.

[@yukatsu4972]

Hi and thank you for the video. I tried the exact same thing but when I typed and hit putexcel A2='e(df_m)' it came out as 'e invalid name r(198). Can you please tell me hot I can solve this please? Thank you in advance

[@nilapay]

try A2=`e(df_m)' instead of A2='e(df_m)', the first single quotation mark is slightly slanted

[@yukatsu4972]

@@nilapay thank you! I will try that!

[@varold2042]

Thank you man! very very helpful.

[@gglucs1799]

Thank you

[@mohamedsalahtraidi6714]

can you explaine th export to excel for matrice (p,q) in tabulation

[@SG-lj8uu]

you didn't explain how to extract values from the r(table) 🥴😤 anyway i figured it out: you need to use after the equals sign matrix(r(table)[R,C] where R is the row number and C is the column number