Proc SQL: Except keyword not recognized

Reply
Senior User
Posts: 1

Proc SQL: Except keyword not recognized

proc sql;
   create table my_check as
      select a.id1 from my_table1 a
      except 
      select b.id2 from my_table2 b;
quit;

 

I need to use the EXCEPT function in Proc SQL.The above code actually works for INTERSECT, but I'm noticing the 'except' keyword doesn't light up blue like the 'intersect' keyword does.

Does 'except' work in proc sql?

 

Thanks!!

Respected Advisor
Posts: 4,609

Re: Proc SQL: Except keyword not recognized

Yes, except does work. It is just the syntax highlighter that misses some keywords.

PG
Ask a Question
Discussion stats
  • 1 reply
  • 98 views
  • 0 likes
  • 2 in conversation