Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

st: estout append - new column


From   "Braunfels, Philipp (Stud. SBE / Alumni)" <P.Braunfels@student.maastrichtuniversity.nl>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index