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

# Re: st: how to put both coefficient and exponentiated form in a table using estout or similar command

 From Carsten Sauer To statalist@hsphsun2.harvard.edu Subject Re: st: how to put both coefficient and exponentiated form in a table using estout or similar command Date Fri, 14 Oct 2011 10:05:56 +0200

```Try this example example:
sysuse auto, clear
su length, d
gen class = 1 if length<   r(mean)
replace class = 0 if length>   r(mean)
xi:nbreg rep78  foreign i.class, vce(cluster class)
su foreign if e(sample)==1&   foreign ==1
estadd scalar D1 = r(N)
esttab, s(N N_clust D1)

Carsten

Am 13.10.2011 23:43, schrieb Heekyung "Hellen" Kim:
```
```I have a related question to -estout, again.

I need to put the number of observations in each group of two groups in the
samples from the analysis (D=1 and D=0).  Then I have about 900 classes.
The "stat" command calls for only the total number of observations.  Is
there any way I can make estout add three rows of N's for one group, N for
the total number of observations, and then N for the number of classes?

My regression looks like this:

xi:nbreg y D i.class, vce(cluster class)

So I want to make -estout write N for D=1, N for all, N for the number of
classes.

Thank you for the answer in advance.

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Carsten Sauer
Sent: Sunday, October 09, 2011 1:33 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: how to put both coefficient and exponentiated form in a
table using estout or similar command

Try the following example:

sysuse auto
nbreg rep78 price mpg
estout, cells(b(star fmt(2)) se(par fmt(2)) expb (par([ ])))
drop(lnalpha:) stats(N ll chi2, fmt(%8.0f %8.2f))

Am 09.10.2011 18:44, schrieb Heekyung "Hellen" Kim:
```
```Thank you so much for the reply.

I can see that I can make a table with two columns using -esttab with
eform(0 1).  Is there a way for me to put the expontionated form under the
raw coefficient in a bracket in the same column?

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Richard Herron
Sent: Saturday, October 08, 2011 5:06 PM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: how to put both coefficient and exponentiated form in a
table using estout or similar command

Have you tried storing the regression with -eststo- then using
-esttab- with the -, eform- option?

Here's a like to an example on the -estout- package page:

(The -estout- package is available from SSC:
http://repec.org/bocode/e/estout/index.html)

On Sat, Oct 8, 2011 at 16:39, Heekyung "Hellen" Kim<hekim@mit.edu>   wrote:
```
```Hi, I want to use -estout (or anything like that) to have a result table.

I am using xtnbreg or nbreg.  I want to put both coefficient and
exponentiated form in ONE table.

I can do one of each using estout without eform for the first and estout
with eform option for expoentiated form.

Is there any way to show both in one table ?

estout, cells(b(star fmt(2)) se(par fmt(2))) drop(_I* o._I*) stats(N ll
chi2, fmt(%8.2f))
estout, cells(b(star fmt(2)) se(par fmt(2))) drop(_I* o._I*) stats(N ll
chi2, fmt(%8.2f)) eform

I used the above two line to have SEPARATE tables.  I wish to have one
```
```table
```
```containing both.

-Helen

*
*   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/

*
*   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/
```
```
--

Carsten Sauer
Soziale Ungleichheit und Sozialstrukturanalyse
Universität Bielefeld
Fakultät für Soziologie
Postfach 10 01 31
33501 Bielefeld
Tel.: 0521 106-67291/-6948 (Sekr. Frau Fischer)
Fax: 0521 106-6479

*
*   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/
```