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   Michael Betz <[email protected]>
To   "[email protected]" <[email protected]>
Subject   RE: st: Significance stars in -esttab-
Date   Thu, 18 Aug 2011 13:17:45 +0000

Hi, I did try %g formats, but then some coefficients with stars have more (or less) than two significant digits past the decimal.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Stas Kolenikov
Sent: Monday, August 15, 2011 9:50 PM
To: [email protected]
Subject: Re: st: Significance stars in -esttab-

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/

*
*   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