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