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/