Message-ID: <BANLkTimguH+hUn8kE6fcvaoiiUdbrkdQVw@mail.gmail.com>
Date: 2011-04-13T20:42:31Z
From: Gabor Grothendieck
Subject: Decimals in R/SQL
In-Reply-To: <2EFC465A5231C8448A638DD72E6D58000BA577AA@dc-mail2.kff.org>
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