Economics & Deeplearning

outer join 에는 세가지가 있음 left, right, full 문법은 select ~ from ~ left join|right join|full join ~ on 으로 해결함 left outer join proc sql;select *from oneleft jointwoon one.x = two.x; right outer join proc sql;select *from oneright jointwoon one.x=two.x; full outer join proc sql;select *from onefull jointwoon one.x=two.x; data merged;merge three four;by x;run; proc sql;select three.x, a, bfrom threefull j..