Bookmark and Share

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


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

Re: st: Significance stars in -esttab-


From   Stas Kolenikov <[email protected]>
To   [email protected]
Subject   Re: st: Significance stars in -esttab-
Date   Mon, 15 Aug 2011 21:50:14 -0400

Would %9.2g format behave in the way you need?

On Mon, Aug 15, 2011 at 4:24 PM, Michael Betz
<[email protected]> wrote:
> Hi,
>
> I'm using Stata 11 and trying to create a table using esttab. My problem is with the number format for the coefficients and t-stats. I want two significant digits past the decimal, but want numbers smaller than 0.01 to show up in exponential format. Using the code below,
>
>       . esttab model* using resultsfile, b(2) t(2) r2 wide star(* .1 ** .05 *** .01) nopa nonum plain csv
>
> any number less than 0.01 shows up as 0.00. I've tried replacing b(2) with b(%9.2f), but to no avail. I am importing to Excel so I tried exporting the table with a different number format (i.e. %9.8f) and then changing the number format in Excel, but any coefficient with a significance star is treated as text in Excel.
>
> In the end, I'd like to export to excel a table the has numbers with two significant digits if the value is greater than 0.01 and is in exponential format if the coefficient is less than 0.01. The table must include significance stars.
>
> Thanks,
> Mike
>
>
> *
> *   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/
>



-- 
Stas Kolenikov, also found at http://stas.kolenikov.name
Small print: I use this email account for mailing lists only.

*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index