'If A and not B' equivalent in proc sql

[Lupacante]

Hi all,

When merging datasets, is there a proc sql equivalent to the 'if a and not b' statement in data steps?

Thank you,
Marco

[RW9 · Accepted solution]

Yep, there are a few ways.  One could be:

proc sql;

     create table want as

     select     A.ID

     from       WORK.A A

     left join   WORK.B B

     on          A.ID=B.ID

     where     B.ID is null;

quit;

[asiddiqui]

You can also do it in SAS if it makes it easier for you.

Proc sort data= a;

by Id;

run;

Proc sort data= b;

by ID;

run;

data abc;

merge a(in=a) b;

by ID;

if a=1;

run;