Fellow R programmers, I'd like to submit SQLDF statements with R objects as column names.
For example, I want to assign "X" to "var1" (var1<-"X") and then refer to "var1" in the SQLDF statement. SQLDF needs to understand that when I reference "var1", it should look for "X" in the dataframe. This is necessary because my SQLDF is part of a larger function that I call that repeatedly with different column names. Code below... thank you in advance! Mike library(sqldf) testdf<-data.frame(c(1,2,3,4,5,6,7,8,9,10),c(1,1,1,2,2,2,3,3,3,3)) names(testdf)<-c("X","Y") # Works as intended sqldf("select sum(X) as XSUM, Y as Y from testdf group by Y") # Now... can I reference var1 in the code? var1<-"X" # Unsuccessful Atteps sqldf("select sum(var1) as XSUM, Y as Y from testdf group by Y") sqldf("select sum(get(var1)) as XSUM, Y as Y from testdf group by Y") sqldf("select sum(return(var1)) as XSUM, Y as Y from testdf group by Y") -- Michael Schumacher mike.schumac...@gmail.com Manager Data & Analytics, ValueClick 818-851-8638 [[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.