Using PUTEXCEL to export Stata output to MS Excel

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 15

  • @Owanango
    @Owanango 3 года назад +27

    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
      @behnamghorbanichenari1565 2 года назад +1

      Hi ... You may like to watch this
      ruclips.net/video/DzG-cXcA3h4/видео.html

  • @rapmantheoneman
    @rapmantheoneman 2 года назад +2

    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

  • @boniphace1
    @boniphace1 3 года назад +1

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

    • @mikejonaseconometrics1886
      @mikejonaseconometrics1886  3 года назад +2

      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.

  • @eloisedricotdagneau3712
    @eloisedricotdagneau3712 Год назад +1

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

    • @rao8559
      @rao8559 Год назад

      use double quotes

  • @michaeljosvawchristensen1856
    @michaeljosvawchristensen1856 Год назад

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

  • @SG-lj8uu
    @SG-lj8uu 2 года назад +1

    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

  • @varold2042
    @varold2042 3 года назад

    Thank you man! very very helpful.

  • @yukatsu4972
    @yukatsu4972 3 года назад

    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
      @nilapay 3 года назад

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

    • @yukatsu4972
      @yukatsu4972 3 года назад

      @@nilapay thank you! I will try that!

  • @gglucs1799
    @gglucs1799 3 года назад

    Thank you