Proc SQL: Except keyword not recognized

sobrio40 — Tue, 02 May 2017 19:04:43 GMT

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!!

Re: Proc SQL: Except keyword not recognized

PGStats — Tue, 02 May 2017 19:50:51 GMT

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

topic Re: Proc SQL: Except keyword not recognized in SAS Programming

Proc SQL: Except keyword not recognized

Re: Proc SQL: Except keyword not recognized