Displaying 1 result from an estimated 1 matches for "54469517def".
2010 Oct 11
1
importing numeric types via sqlQuery
...692def 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...