On Mon, Apr 18, 2011 at 6:34 PM, new2R <bv_agrico at yahoo.co.in>
wrote:> Hi,
>
> I am new to R and trying to migrate from SAS. I am trying to use sqldf to
> create a new table from existed table and change some of the columns. I
have
> table called DataOld with columns commodity, rate and total and I am trying
> to create new table called DataNew with columns commodity, ratenew and
> totalNew.
>
>> sqldf("create table datanew as select commodity, ratenew as rate *
10,
>> totalnew as total *10 from DataOld")
>
> I got error message " Error in sqliteExecStatement(con, statement,
> bind.data) :
> ?RS-DBI driver: (error in statement: near "*": syntax error)
>
Its expression as name, not name as expression. Try this:
> library(sqldf)
> BODnew <- sqldf("select demand, Time, demand + 1 as demandPlusOne
from BOD")
> BODnew
demand Time demandPlusOne
1 8.3 1 9.3
2 10.3 2 11.3
3 19.0 3 20.0
4 16.0 4 17.0
5 15.6 5 16.6
6 19.8 7 20.8
For more, the sqldf home page at sqldf.googlecode.com has links
to sqlite site where you can find sql syntax diagrams. See the links
along the left side of the page there.
--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com