Displaying 1 result from an estimated 1 matches for "c_opr".
Did you mean:
c_op
2008 Apr 03
2
sqldf file specification, non-ASCII
...ad a 3GB file originally stored in .sas7bdat-format. I convert
it to comma-delimited ASCII format with StatTransfer before trying to
import just the rows I need into R. The problem is that I get this
error:
> f <- file("hugedata.csv")
> DF <- sqldf("select * from f where C_OPR like 'KKA2%'",
file.format=list(header=T, row.names=F))
Error in try({ :
RS-DBI driver: (RS_sqlite_import: hugedata.csv line 1562740 expected
52 columns of data but found 19)
Error in sqliteExecStatement(con, statement, bind.data) :
RS-DBI driver: (error in statement: no such tab...