sas的proc sql的四种jion和对应的data步的merge

1. Inner join

Merge a(in=ina) b(in=inb);

If ina and inb

proc sql;

title "inner join equate where";

select *

from sql.Branches b inner join sql.Transact t

on b.actnum=t.actnum;

run;

1. Left join

Merge a(in=ina) b(in=inb);

If ina;

proc sql;

    select b.actnum, branch 'Branch belong', trans 'transaction'

    from sql.Branches b left join sql.Transact t

    on b.actnum = t.actnum

    order by trans desc;

quit;

1. Right join

Merge a(in=ina) b(in=inb);

If inb

proc sql;

    select b.actnum, branch 'Branch belong', t.actnum, trans 'transaction'

    from sql.Branches b right join sql.Transact t

    on b.actnum = t.actnum

    order by trans desc;

quit;

1. Full join

Merge a(in=ina) b(in=inb);

If ina or inb

proc sql;

    select b.actnum, branch '#Branch#belong', t.actnum, trans '#transaction#happened'

    from sql.Branches b full join sql.Transact t

    on b.actnum = t.actnum

    order by trans desc;

quit;