PROC SQL Tutorial 6 - inner join

inner join

 

두 테이블에서 같은 값을 가지는 변수만을 남김 변수명은 달라도 상관없음

 

proc sql;

select *

from one, two

where one.x = two.x;

data step으로 하는 법

 

data merged;

merge one two;

by x; run;

 

proc sql;

select one.x, a, b

from one, two

where one.x = two.x

order by x;

table alias를 이용할 수도 있음

 

proc sql;

select staffmaster.empid, lastname, firstname, jobcode

from sasuser.staffmaster, sasuser.payrollmaster

where staffmaster.empid=payrollmaster.empid;

 

대신

 

proc sql;

select s.empid, lastname, firstname, jobcode

from sasuser.staffmaster as s,

sasuser.payrollmaster as p

where s.empid = p.empid;