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 at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: misreading excel numbers when imported in Stata 11.2


From   Dirk Enzmann <dirk.enzmann@uni-hamburg.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: misreading excel numbers when imported in Stata 11.2
Date   Tue, 02 Apr 2013 19:00:45 +0200

I don't believe you - I think you made a typing error when comparing 6.15000000000001 to 6.1999998 (either in you mail or earlier).

Thus, my first hint: Double check your data / results.

Second hint: See whether
http://www.stata.com/support/faqs/data-management/float-data-type/
http://blog.stata.com/2011/06/17/precision-yet-again-part-i/
or more generally
http://blog.stata.com/tag/precision/
will help you to understand the problem.

Third hint: If not a typo, it seems to be a precision problem. Be in the lookout for -float()- in the documents refered to above.

Dirk

Tue, 2 Apr 2013 14:57:07 +0000,  <Caterina.ASTARITA@ec.europa.eu> wrote:
>
> I have a problem in importing data from excel to STATA 11.2, both
> with copy and paste and with importing a csv file.
> Stata misread the number or at the least the number visualized in
> Stata are different from the one visualized in Excel.
>
> For example the number in excel is 6.15000000000001 whereas in Stata
> is read as 6.1999998.
>
> Any hint?
>
> Thanks

========================================
Dr. Dirk Enzmann
Institute of Criminal Sciences
Dept. of Criminology
Rothenbaumchaussee 33
D-20148 Hamburg
Germany

phone: +49-(0)40-42838.7498 (office)
       +49-(0)40-42838.4591 (Mrs Billon)
fax:   +49-(0)40-42838.2344
email: dirk.enzmann@uni-hamburg.de
http://www2.jura.uni-hamburg.de/instkrim/kriminologie/Mitarbeiter/Enzmann/Enzmann.html
========================================
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index