Announcement

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

  • Outreg2 output split over 3 columns doing ARIMA regression

    I have a problem getting the right output doing ARIMA regressions using outreg2.

    For example, I did the following regression.
    Code:
    arima RV in 1/844, ar(1/2)
    outreg2 using table1.doc, replace addstat (Log Lik, e(ll)) ctitle(Model I)
    I used this code to get the results into Word. The output is shown below in a screenshot

    However, I get the output split over 3 different columns. I would like to have all results in 1 column (everything under column (1) for example). Is this possible with outreg2 or do I have to adjust this manually?

    Ideally I would like to append more models to this table using the append function as well. Merging the columns would help immensely with this!
    Click image for larger version

Name:	table.PNG
Views:	2
Size:	10.3 KB
ID:	1728557


    Thanks in advance!
    Attached Files

  • #2
    Cross-posted at https://www.reddit.com/r/stata/comme...using_outreg2/

    Please note: it is a request here and a rule on r/stata that you tell people about cross-postings.

    Comment


    • #3
      If you have Stata 17 or newer, you can use etable to build your
      estimation table and collect export to publish it to a Word
      document.

      Here is an example from the arima help file.
      Code:
      webuse wpi1
      arima wpi, arima(1,1,1)
      etable, stars(.1 "*" .05 "**" .01 "***") ///
          showstarsnote ///
          showeq ///
          mstat(N) ///
          mstat(ll)
      collect export est_table.docx, replace
      Here is the resulting table.
      Code:
      --------------------------------------
                                    D.wpi
      --------------------------------------
      U.S. Wholesale Price Index
        Intercept                  0.750 **
                                 (0.334)
      ARMA
        L.ar                       0.874 ***
                                 (0.055)
        L.ma                      -0.412 ***
                                 (0.100)
      sigma
        Intercept                  0.725 ***
                                 (0.037)
      Number of observations         123
      Log likelihood             -135.35
      --------------------------------------
      *** p<.01, ** p<.05, * p<.1

      Comment

      Working...
      X