topic merge - proc sql join in SAS Enterprise Guide

merge - proc sql join

nannà — Mon, 30 Jan 2012 09:40:47 GMT

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 — Mon, 30 Jan 2012 09:54:58 GMT

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à — Mon, 30 Jan 2012 11:55:37 GMT

Thanks very much!!