Re: [R] sqldf syntax, selecting rows, and skipping

2011-09-29 Thread David Winsemius
On Sep 29, 2011, at 10:06 AM, Juliet Hannah wrote: I am using the example in this post: https://stat.ethz.ch/pipermail/r-help/2010-October/257204.html # create a file write.table(iris,"iris.csv",row.names=FALSE,sep=",",quote=FALSE) # this does not work # has the syntax changed or is there

[R] sqldf syntax, selecting rows, and skipping

2011-09-29 Thread Juliet Hannah
I am using the example in this post: https://stat.ethz.ch/pipermail/r-help/2010-October/257204.html # create a file write.table(iris,"iris.csv",row.names=FALSE,sep=",",quote=FALSE) # this does not work # has the syntax changed or is there a mistake in my usage? # the line from the post above i

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

Re: [R] SQLDF syntax

2011-04-19 Thread Gabor Grothendieck
On Mon, Apr 18, 2011 at 6:34 PM, new2R 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

[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] sqldf syntax

2010-08-27 Thread Bond, Stephen
other suggestion about data.table and report. Cheers everybody. Stephen B -Original Message- From: Gabor Grothendieck [mailto:ggrothendi...@gmail.com] Sent: Thursday, August 26, 2010 4:26 PM To: Bond, Stephen Cc: r-help@r-project.org Subject: Re: [R] sqldf syntax On Thu, Aug 26, 2010 at 2:

Re: [R] sqldf syntax

2010-08-26 Thread Gabor Grothendieck
On Thu, Aug 26, 2010 at 2:31 PM, Bond, Stephen wrote: > Please correct the following > >> sqldf("update esc left join forwagg  on esc.ym=forwagg.Date set >> esc.ri2=forwagg.N1 where esc.age=12","select * from main.esc") > Error in sqliteExecStatement(con, statement, bind.data) : >  RS-DBI driver:

[R] sqldf syntax

2010-08-26 Thread Bond, Stephen
Please correct the following > sqldf("update esc left join forwagg on esc.ym=forwagg.Date set > esc.ri2=forwagg.N1 where esc.age=12","select * from main.esc") Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: near "left": syntax error) Thanks. Step