"Error: near ".": syntax error" with sqldf in R

Question

For whatever reasons, my code that used to work does not work anymore and I get the following error message "Error: near ".": syntax error". The code is below. How should I modify it to make it work again? Thank you very much!

uhc_phys <- sqldf("select 
      a.iso3,a.year,a.whoname,a.Phys
      b.iso3,b.year,b.whoname,b.Phys
      min(abs(a.year - b.year)) min_value
    from uhc_hwf a  
    left join uhc_hwf b on a.year - b.year in (0,1,2,3,4,5) and
      a.iso3 = b.iso3 and
      b.Phys is not null
    group by a.iso3, a.year
    having a.year in ('2012','2017')")[1:8]

r2evans · Accepted Answer · 2020-02-25 15:52:42Z

1

You are missing commas between some of your selected fields. Try this:

uhc_phys <- sqldf("select 
      a.iso3,a.year,a.whoname,a.Phys        ,
      b.iso3,b.year,b.whoname,b.Phys        ,
      min(abs(a.year - b.year)) min_value
    from uhc_hwf a  
    left join uhc_hwf b on a.year - b.year in (0,1,2,3,4,5) and
      a.iso3 = b.iso3 and
      b.Phys is not null
    group by a.iso3, a.year
    having a.year in ('2012','2017')")[1:8]

(Commas spaced out a bit to highlight which ones are missing.)

answered Feb 25, 2020 at 15:52

r2evans

167k8 gold badges92 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nellicopter Over a year ago

Thanks! I am blind today!

r2evans Over a year ago

Please accept it if this addresses your question. Thanks!

Collectives™ on Stack Overflow

"Error: near ".": syntax error" with sqldf in R

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related