search for: ratenew

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 erro...