[R] importing numeric types via sqlQuery

[jim holtman]

I would assume that the digitis are not being chopped off.  It is just
that R will typically print data to 7 significant digits:

> x <- 54469517.307692307692
> x
[1] 54469517
> options(digits=20)
> x
[1] 54469517.3076923
>

Your data it there and you can set 'options' to show it if you want
to.  Also with floating point, you will only get about 15 digits of
accuracy (see FAQ 7.31).


On Mon, Oct 11, 2010 at 4:19 PM, E C <mmmraspberries at hotmail.com> wrote:
>
> Hi everyone,
> I am using the sqlQuery function (in RODBC library) to import data from a database into R. My table (called temp) in the database looks like this:
> category        numabc  54469517.307692307692def        36428860.230769230769
> I used the following R code to pull data into R:data <-sqlQuery(channel, "select category, num from temp;")
> However, the result is that "num" gets all its decimal places chopped off, so "data" looks like this instead in R:category      numabc  54469517def     36428860
>
> I've tried various alternative approaches, but none have fixed the problem. When I cast the variable to a numeric type like this (data <-sqlQuery(channel, "select category, num::numeric from temp;"), it still gave me the same result. Casting to a real type like this (data <-sqlQuery(channel, "select category, num::real from temp;") resulted in scientific notation that also rounded the numbers.
> Any suggestions? Much appreciated!
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem that you are trying to solve?