[R] Decimals in R/SQL

Gabor Grothendieck ggrothendieck at gmail.com
Wed Apr 13 22:42:31 CEST 2011


On Wed, Apr 13, 2011 at 4:34 PM, Rachel Licata <RachelL at kff.org> wrote:
> Thanks again Jim - that is really helpful and I apologize that I am new to R.  How can I convert to numeric in SQL and when I am working on a table in a database?  The file is huge so that is why I am using SQL and the database to work through it.
> Thanks!
>

There are some examples here (a few of them, as noted, require the
development version of sqldf):

http://code.google.com/p/sqldf/#15._Why_do_certain_calculations_come_out_as_integer_rather_than

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com



More information about the R-help mailing list