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 "Heekyung \"Hellen\" Kim" To Subject RE: st: how to put both coefficient and exponentiated form in a table using estout or similar command Date Fri, 14 Oct 2011 07:30:42 -0400

```Thank you!

Sorry for keeping asking a question.

How can I label N_clust and D1 for a table (to present in my word document)?
I found how to label variables, but couldn't find how to label stat numbers.

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Carsten Sauer
Sent: Friday, October 14, 2011 4:06 AM
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 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
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.
>
>
>
> -----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/

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