Statalist


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

Re: st: scientific notation in tables


From   "Sergiy Radyakin" <serjradyakin@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: scientific notation in tables
Date   Tue, 16 Dec 2008 18:37:35 -0500

Hello Norbert,

I'd suggest not using Copy+Paste at all. It is tedious, prone to
mistakes and impossible to replicate.
Use one of the plethora of exporting modules that are available for
Stata now: findit Excel.
My preference is -XML_TAB-

Regards, Sergiy Radyakin


On Tue, Dec 16, 2008 at 5:58 PM, Norbert Michel
<Norbert.Michel@nicholls.edu> wrote:
> Hello all.
>
> I am using population weights to calculate aggregate figures, which results in fairly large numbers (hundreds of millions).
>
> I need to sum columns (variable totals for all observations), and I have tried using a few different summary stat commands, but I keep running into the same problem.
>
> My problem is that STATA is displaying everything (in the tables) in scientific notation; that would be fine, but when I copy and paste into Excel, I lose all of the detail.  For example, 305,423,221 gets rounded to 305,000,000....and this is not fine.
>
> I have changed the formatting for how the variable is displayed in stata, and also for how the variable is stored in stata.  Neither has changed the output that I end up with in the result tables.
>
> Does anyone have any ideas?
>
> Thank you.
> Norbert Michel
>
> *
> *   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   |   What's new   |   Site index