subject:"\[R\] sqldf if iif"

Re: [R] sqldf if iif

2011-11-26 Thread Jeff Newmiller

sqldf uses the SQLite database by default for backend processing. The "iif" function is specific to the Jet database engine syntax (which underlies MS Access). You could read up on SQLite syntax, or you could avoid using nonstandard SQL syntax, retrieve the data into a data frame, and use R code

[R] sqldf if iif

2011-11-26 Thread Carlos Rivera

Dear all, I have problems with iif function using sqldf library. I counted abundance (Num) of different "SPECIES" in two moments (esf) saving the information in two Tables (esf50, esf100): esf50 SAMPLE SPECIES Num esf 1289diso1 44