[R] Sqldf INSERT INTO

2011-04-20 Thread new2R
Hi, I am new to R and trying to migrate from SAS. I am trying to copy data from one table to another table which have same columns using sqldf. but not working and showing "NULL" I wrote statement as sqldf("INSERT INTO new select * from data") but showing NULL Please help me in this regard. Th

Re: [R] SQLDF syntax

2011-04-19 Thread new2R
Thank you very much. Its working. -- View this message in context: http://r.789695.n4.nabble.com/SQLDF-syntax-tp3458919p3460448.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mail

[R] SQLDF syntax

2011-04-18 Thread new2R
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

Re: [R] Import dbf file

2011-04-18 Thread new2R
Thank you..david That helps me. -- View this message in context: http://r.789695.n4.nabble.com/Import-dbf-file-tp3458468p3458526.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/ma

[R] "object read.dbf" is not found

2011-04-18 Thread new2R
Hi I am new to R. I am trying to import dbf file using read.dbf but getting error message "object read.dbf" is not found. Please help in this regard. Thank you -- View this message in context: http://r.789695.n4.nabble.com/object-read-dbf-is-not-found-tp3458409p3458409.html Sent from the R

[R] Import dbf file

2011-04-18 Thread new2R
Hi I am new to R. I am trying to import dbf file using read.dbf but getting error message "object read.dbf is not found. Please help in this regard. Thank you -- View this message in context: http://r.789695.n4.nabble.com/Import-dbf-file-tp3458366p3458366.html Sent from the R help mailing li