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

[Dirk Enzmann <dirk.enzmann@uni-hamburg.de>]

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/