Thanks very much - xml_tab works great.
>>> "Sergiy Radyakin" <[email protected]> 12/16/08 5:37 PM >>>
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
<[email protected]> 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/
*
* 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/
