sqldf icon indicating copy to clipboard operation
sqldf copied to clipboard

sqldf with label attached to a variable does not work

Open spal2024 opened this issue 6 months ago • 1 comments

I am a fan of sqldf when it comes to data wrangling as I came from SAS background. However I have noticed when a variable has a label attached to it, we could not use sqldf. We get the error message as 'Error in match.fun(asfn) : 'c("as.labelled", "as.Date")' is not a function, character or symbol' I think it's a known issue. The way I am dealing with this situation is creating a brand new variable without a label using mutate function and feed those columns into sqldf. Is there any alternative way you guys suggest?

spal2024 avatar Aug 29 '24 03:08 spal2024