No announcement yet.
  • Filter
  • Time
  • Show
Clear All
new posts

  • Export Regression Results to Excel 2016 - Stata IC 15.1


    How I can export Regression Results to Excel 2016.

    I have tried different ways but it is not working.

    Best Regards,

    Vítor Pereira
    Stata/IC 15.1

  • #2
    Without further information from you, it is likely that any response will repeat things you already tried, and that will neither be helpful to you nor satisfying for the member who spent their time writing the response.

    Take a few moments to review the Statalist FAQ linked to from the top of the page, as well as from the Advice on Posting link on the page you used to create your post. Note especially sections 9-12 on how to best pose your question. It's particularly helpful to copy commands and output from your Stata Results window and paste them into your Statalist post using code delimiters [CODE] and [/CODE], and to use the dataex command to provide sample data, as described in section 12 of the FAQ.

    Section 12.1 is particularly pertinent

    12.1 What to say about your commands and your problem

    Say exactly what you typed and exactly what Stata typed (or did) in response. N.B. exactly!
    Never say just that something "doesn't work" or "didn't work", but explain precisely in what sense you didn't get what you wanted.
    The more you help others understand your problem, the more likely others are to be able to help you solve your problem.

    With that said, you will probably be wanting to use the putexcel command. It's useful to build up your knowledge by reporting simple results from a standard dataset, so that if you have problems others can easily run your code and test corrections. For example,
    sysuse auto, clear
    regress mpg weight displacement
    Last edited by William Lisowski; 11 Feb 2019, 11:06.


    • #3
      You have asked about exporting regression output to Excel, still, I would mention asdoc here that can export regression outputs in a variety of formats and variations. Those tables can be easily copied and pasted in Excel later on.

      For those who are not yet familiar with asdoc, asdoc can be downloaded from SSC and can be used with almost all Stata commands. Here is a short blog post that shows how asdoc can be used with any Stata command You can also watch several YouTube videos that show the use of asdoc

      * For installation of the stable version 
      ssc install asdoc
      * For installation of the new beta version
      net install asdoc, from( replace
      help asdoc
      One short example
      sysuse auto, clear
      asdoc reg price mpg rep78 headroom trunk weight length turn , replace
      Attaullah Shah, PhD.
      Associate Professor of Finance, Institute of Management Sciences Peshawar, Pakistan
      If you use MS Word, do check my asdoc program that easily sends Stata output to MS Word


      • #4
        Dear William Lisowski,

        Thank you for your help.


        • #5
          Dear Attaullah Shah,

          Thank you for your help.


          • #6
            Dear Attaullah Shah,

            I have used the asdoc and exported fine for one model with all the details I want including 95% CI and so on.
            How about getting all the details of the output for more than one model. I use outreg2 and still does not give me 95% CI.

            reg Y x1 X2 X3 etc...

            ereturn list
            outreg2 [zlen_hlygnut1 zlen_hlygnut2 zlen_hlygnut3 zlen_hlygnut4] using zlen_hlygnut1234, e (all) replace see

            Can you Kindly help me export more than one models with all the details that your asdic command exports?

            Thanking you in advance,
            Aye Aye Khaine


            • #7
              Dear Attaullah Shah,

              Also, how can I export all the details of mixed model results for multiple models simultaneously?

              Thank you