This requires some programming. Here's an example;
sysuse auto, clear
xi: reg price weight i.rep
capture matrix drop num
foreach cat of varlist _Irep* {
count if `cat'==1 & e(sample)
matrix num = nullmat(num), r(N)
local collab "`collab'`cat' "
}
matrix colname num = `collab'
estadd matrix num
estout, cell("num b") style(smcl)
which yields
--------------------------------------
.
num b
--------------------------------------
weight 2.440292
_Irep78_2 8 783.9009
_Irep78_3 30 1379.115
_Irep78_4 18 2068.267
_Irep78_5 11 3245.272
_cons -3000.405
--------------------------------------
ben
On Nov 20, 2007 6:08 PM, Raoul Reulen <[email protected]> wrote:
> I am running a logistic regression model and save the estimates to estout. Now for a specific factor in the model I would also like to add the number of observations for each level of the factor.
>
>
>
> So for example;
>
>
>
> xi: logit dead i.diagnosis
>
> .estout . using "output/table2.xls", cells("b(fmt(%9.1f)) ci(par( ( , ) ))") eform replace
>
>
>
> Whereby::
>
> dead (yes=1, no=0)
>
> Diagnosis (leukaemia=1, Hodgkins=2, retinoblastoma=3 etc)
>
>
>
> So this gives the estimates and confidence intervals for the factor diagnosis. How do I add the number of observations for each level of the factor diagnosis? So for example:
>
>
>
> Diagnosis Number estimate 95%CI
>
> Leukaemia 450 3.0 (2.0,5.0)
>
> Hodgkins 230 4.9 (3.0,8.4)
>
>
>
> How do I get a column with the number of observations such as in this example if possible?
>
>
>
> Thanks,
>
>
>
> Raoul
>
>
> Raoul Reulen
> Cancer Research UK Graduate Training Fellow
>
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
