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

[Carsten Sauer <carsten.sauer@uni-bielefeld.de>]

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
> estadd expb
> 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:
> > http://repec.org/bocode/e/estout/advanced.html#advanced001
> >
> > (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/