merge - proc sql join

[nannà]

Hi,

I usually use the data step below;

data test;

merge table_A (in=a) table_B (in=b);

by X Y;

if a and not b;

run;

Can I make the same result whit PROC SQL in Guide?

Any suggestions?

Many thanks

[bheinsius · Accepted solution]

Yes:

proc sql;

create table test as

   select    *

   from      a

   left join b

   on        a.x=b.x

   and       a.y=b.y

   where     b.y=''

  ;

quit;

You can use the code in a Program node or click it together using a Query task.

-Bart

[nannà]

Thanks  very much!!