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: Rounding Errors Stata 12
From
Jeph Herrin <[email protected]>
To
[email protected]
Subject
Re: st: Rounding Errors Stata 12
Date
Wed, 13 Feb 2013 09:41:01 -0500
Did you check to see if Excel was rounding it's display? Because it
usually does. It might be hiding those last digits from you.
J
On 2/13/2013 9:25 AM, Gray, Charles wrote:
I am having an issue with Stata 12 adding decimal places to data that I
insheet. I simply have a dataset in .csv format. The dataset contains a
variable 'item_revenue.' When I open the dataset in Excel, several
observations have a value of 60237.8 for the 'item_revenue' variable.
However, when I insheet the dataset into Stata, these values change to
60237.801. My insheet command is simply,
insheet using "data.csv", comma clear
My understanding is that the .csv format saves only the text and values
as they are displayed in cells of the active worksheet. So does anyone
know why Stata would add decimal places to a variable?
Thanks,
Charlie
*
* 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/
*
* 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/