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 at the end of May, and its replacement, statalist.org is already up and running.


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

st: eliminating reference category lines using esttab


From   Colleen Nugent <cnugent@sociology.rutgers.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: eliminating reference category lines using esttab
Date   Thu, 15 Mar 2012 12:28:51 -0400 (EDT)

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/


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