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]
st: estout append - new column
From
"Braunfels, Philipp (Stud. SBE / Alumni)" <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: estout append - new column
Date
Sun, 22 Jul 2012 21:06:37 +0200
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/