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, 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 <>
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
or more generally
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.


Tue, 2 Apr 2013 14:57:07 +0000,  <> 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

phone: +49-(0)40-42838.7498 (office)
       +49-(0)40-42838.4591 (Mrs Billon)
fax:   +49-(0)40-42838.2344
*   For searches and help try:

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