Hi Rizzi, how about a reproducible example/data.frame?
:-) milton On Thu, Jul 30, 2009 at 1:46 PM, <rizzo.mich...@epamail.epa.gov> wrote: > > Hello, > > I am having a problem using sqldf. I'm trying to choose a subset of > observations from a data set based on the date and maximum value of a > variable by date. > > Here is the code I am using: > > test<-sqldf("select distinct * from bextuse group by sdate having > bext=max(bext)",method="raw"); > > The result I get back is a data frame with 0 rows and 0 columns. I have > tried the code in another program that utilizes SQL, and I retrieve the > 14 rows I was expecting to get. > I looked at the SQLite information on the web, and it mentions that the > "having" clause can be used to select observations from grouped data > using aggregating functions. > > Any help or advice is greatly appreciated. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.