Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[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 <[email protected]>
To
[email protected]
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, <[email protected]> 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: [email protected]
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/