Using PUTEXCEL to export Stata output to MS Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 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
      th-cam.com/video/DzG-cXcA3h4/w-d-xo.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 4 ปีที่แล้ว +1

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

    • @mikejonaseconometrics1886
      @mikejonaseconometrics1886  4 ปีที่แล้ว +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.

  • @michaeljosvawchristensen1856
    @michaeljosvawchristensen1856 ปีที่แล้ว

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

  • @varold2042
    @varold2042 3 ปีที่แล้ว

    Thank you man! very very helpful.

  • @eloisedricotdagneau3712
    @eloisedricotdagneau3712 ปีที่แล้ว +1

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

    • @rao8559
      @rao8559 ปีที่แล้ว

      use double quotes

  • @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

  • @gglucs1799
    @gglucs1799 3 ปีที่แล้ว

    Thank you

    • @mohamedsalahtraidi6714
      @mohamedsalahtraidi6714 2 ปีที่แล้ว

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

  • @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!