topic Re: 'If A and not B' equivalent in proc sql in SAS Procedures

'If A and not B' equivalent in proc sql

Lupacante — Thu, 03 Apr 2014 15:05:37 GMT

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 — Thu, 03 Apr 2014 15:22:55 GMT

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 — Thu, 03 Apr 2014 15:56:53 GMT

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;