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: Significance stars in -esttab-


From   Michael Betz <betz.40@buckeyemail.osu.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
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: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Stas Kolenikov
Sent: Monday, August 15, 2011 9:50 PM
To: statalist@hsphsun2.harvard.edu
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
<betz.40@buckeyemail.osu.edu> 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index