Displaying 1 result from an estimated 1 matches for "numabc".
Did you mean:
numa
2010 Oct 11
1
importing numeric types via sqlQuery
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...