Bookmark and Share

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: eliminating reference category lines using esttab

From   Carsten Sauer <[email protected]>
To   [email protected]
Subject   Re: st: eliminating reference category lines using esttab
Date   Thu, 15 Mar 2012 17:38:48 +0100

Use the drop option:

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


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:


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:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index