Displaying 1 result from an estimated 1 matches for "bodnew".
Did you mean:
bodner
2011 Apr 18
2
SQLDF syntax
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,
>