Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: eliminating reference category lines using esttab


From   Carsten Sauer <carsten.sauer@uni-bielefeld.de>
To   statalist@hsphsun2.harvard.edu
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

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index