Re: st: eliminating reference category lines using esttab

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

Use the drop option:

sysuse auto, clear
reg price i.rep78
esttab using test, drop(1b*) csv replace

Carsten

Am 15.03.2012 17:28, schrieb Colleen Nugent:
> After running some regressions using factor variable notation (i.varname), I'm using the esttab command to make a table in Excel using the following code:
> esttab using Filename.csv, eform wide p(3) scalars(F p df_m N_subpop)
>
> The output in Excel includes lines for each reference category when my variables have more than just two categories and it includes the odds ratio 1.00 for each.  However, when I run these regressions without storing the estimates and sending them to Excel, I don't get extra lines for reference categories in the output window.
>
> I want to eliminate the reference category lines in my Excel output.  In the version of Stata I was using prior to 12.1 (10.1), I never got Excel output that included reference category lines unless I asked for it using the refcat option.  (Incidentally, according to the manual for 12.1, refcat is no longer an option for esttab.)  I tried "norefcat," which gave me an error, and I also tried an option listed in the manual under esttab called "nolines."  I still got the extra reference category lines when I used this option.
>
> Does anyone know how to eliminate the extra lines for the reference categories in the Excel output using esttab?
> Thanks in advance!
> *
> *   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
SFB 882 "Von Heterogenitäten zu Ungleichheiten"
Teilprojekt A6 "Die Legitimation von Ungleichheiten - Strukturelle Bedingungen von Gerechtigkeitseinstellungen"
Fakultät für Soziologie
Universität Bielefeld
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/