Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: estout append - new column


From   Richard Williams <[email protected]>
To   [email protected], "[email protected]" <[email protected]>
Subject   Re: st: estout append - new column
Date   Sun, 22 Jul 2012 20:38:42 -0500

At 02:22 PM 7/22/2012, Braunfels, Philipp (Stud. SBE / Alumni) wrote:
Dear all,
just found my own solution. I installed a new version of outreg and now it works fine. the version to install is "sg97_2".

I believe that is a fairly old version of outreg. Maybe you want an older version for some reason, but if not the most current version is available on SSC. Do -findit outreg- .


greets



On Sun, Jul 22, 2012 at 9:06 PM, Braunfels, Philipp (Stud. SBE / Alumni) <[email protected]> wrote:
> Dear Statlisters,
> I am seeking for your advice once more. Currently I am trying to store several regression outputs to an excel file using -estout- with the "append" option. However, "append" in conjunction with estout always adds the second regression output below the first one. However, I would like that the second regression output is added to the right column of the first output:
>
> I want:
> output1  output2  output3
>
> Estout does:
> output1
> output2
> output3
>
>
> I used "outreg" instead, which does exactly what I want if I use the option "merge". However, when I use outreg it just writes strange codes in txt files (not like estout which writes nice readable outputs). That´s why I want to use estout again.
> Below is an example of my outreg output using merge:
>
>
> {\rtf1\ansi\deff0{\fonttbl{\f0\froman Times New Roman;}{\f1\fswiss Arial;}{\f2\fmodern Courier New;}} > \trowd\intbl\trautofit1\trgaph144\sb79\sa79\trqc\clbrdrt\brdrs\cellx1176\clbrdrt\brdrs\cellx2688\clbrdrt\brdrs\cellx4368\clbrdrt\brdrs\cellx6048\clbrdrt\brdrs\cellx7728\clbrdrt\brdrs\cellx9408\clbrdrt\brdrs\cellx11088\clbrdrt\brdrs\cellx12264\clbrdrt\brdrs\cellx13944\clbrdrt\brdrs\cellx15624\clbrdrt\brdrs\cellx17304\fs24 \ql I\cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell \qc \cell\row > \trowd\intbl\trautofit1\trgaph144\sb79\sa0\trqc\clbrdrt\brdrs\cellx1176\clbrdrt\brdrs\cellx2688\clbrdrt\brdrs\cellx4368\clbrdrt\brdrs\cellx6048\clbrdrt\brdrs\cellx7728\clbrdrt\brdrs\cellx9408\clbrdrt\brdrs\cellx11088\clbrdrt\brdrs\cellx12264\clbrdrt\brdrs\cellx13944\clbrdrt\brdrs\cellx15624\clbrdrt\brdrs\cellx17304\fs24 \pard\intbl\ql msciwde\cell \pard\intbl\tqdec\tx538 {\fs24 1.546}\cell \pard\intbl\tqdec\tx538 {\fs24 0.777}\cell \pard\intbl\tqdec\tx538 {\fs24 2.717}\cell \pard\intbl\tqdec\tx538 {\fs24 1.222}\cell \pard\intbl\tqdec\tx538 {\fs24 1.213}\cell \pard\intbl\tqdec\tx538 {\fs24 2.420}\cell \pard\intbl\tqdec\tx538 {\fs24 0.339}\cell \pard\intbl\tqdec\tx538 {\fs24 2.785}\cell \pard\intbl\tqdec\tx538 {\fs24 1.530}\cell \pard\intbl\tqdec\tx538 {\fs24 1.862}\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa79\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql \cell \pard\intbl\tqdec\tx538 {\fs20 (0.239)**}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.210)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.287)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.217)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.216)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.294)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.301)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.488)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.285)***}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.283)***}\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa0\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql icrg300\cell \pard\intbl\tqdec\tx538 {\fs24 -0.003}\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa79\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql \cell \pard\intbl\tqdec\tx538 {\fs20 (0.006)}\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa0\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql icrg200\cell \pard\intbl\tqdec\tx538 {\fs24 0.003}\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell \pard\intbl\tqdec\tx538 {\fs24 }\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa79\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql \cell \pard\intbl\tqdec\tx538 {\fs20 (0.004)}\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell \pard\intbl\tqdec\tx538 {\fs20 }\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa0\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql _cons\cell \pard\intbl\tqdec\tx538 {\fs24 0.036}\cell \pard\intbl\tqdec\tx538 {\fs24 0.002}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.038}\cell \pard\intbl\tqdec\tx538 {\fs24 0.002}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.005}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.019}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.012}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.001}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.012}\cell \pard\intbl\tqdec\tx538 {\fs24 -0.010}\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa79\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql \cell \pard\intbl\tqdec\tx538 {\fs20 (0.285)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.012)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.021)*}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.012)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.013)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.018)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.014)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.021)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.015)}\cell \pard\intbl\tqdec\tx538 {\fs20 (0.013)}\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa0\trqc\cellx1176\cellx2688\cellx4368\cellx6048\cellx7728\cellx9408\cellx11088\cellx12264\cellx13944\cellx15624\cellx17304\fs24 \pard\intbl\ql {\i R}{\super 2}\cell \pard\intbl\tqdec\tx538 0.39\cell \pard\intbl\tqdec\tx538 0.32\cell \pard\intbl\tqdec\tx538 0.67\cell \pard\intbl\tqdec\tx538 0.52\cell \pard\intbl\tqdec\tx538 0.51\cell \pard\intbl\tqdec\tx538 0.68\cell \pard\intbl\tqdec\tx538 0.06\cell \pard\intbl\tqdec\tx538 0.60\cell \pard\intbl\tqdec\tx538 0.55\cell \pard\intbl\tqdec\tx538 0.70\cell\row > \trowd\intbl\trautofit1\trgaph144\sb0\sa79\trqc\clbrdrb\brdrs\cellx1176\clbrdrb\brdrs\cellx2688\clbrdrb\brdrs\cellx4368\clbrdrb\brdrs\cellx6048\clbrdrb\brdrs\cellx7728\clbrdrb\brdrs\cellx9408\clbrdrb\brdrs\cellx11088\clbrdrb\brdrs\cellx12264\clbrdrb\brdrs\cellx13944\clbrdrb\brdrs\cellx15624\clbrdrb\brdrs\cellx17304\fs24 \pard\intbl\ql {\i N}\cell \pard\intbl\tqdec\tx538 123\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 22\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 23\cell \pard\intbl\tqdec\tx538 24\cell \pard\intbl\tqdec\tx538 24\cell\row
> \pard\qc\sb79\sa79\fs19 * {\i p}<0.05; ** {\i p}<0.01\par
> \pard\sb0\sa0\fs24\par
> }
>
>
>
> I am thankful for any help!
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

-------------------------------------------
Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
HOME:   (574)289-5227
EMAIL:  [email protected]
WWW:    http://www.nd.edu/~rwilliam


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index