/*解决实际问题之关联不同公司不同年份相同职员所做的任务*/
/*关联公司职员表与职员所做的任务表*/
data company;
input company $ time name $;
cards;
a 199906 ar
a 199912 er
a 200306 de
a 200412 se
b 199912 de
b 200306 sf
b 200503 dn
b 200506 ar
;
data task;
input name $ task $;
cards;
ar a
ar b
ar c
sf b
sf d
er e
er d
;
proc sql;
create table comtask1 as
select
a.company,
a.time,
a.name,
b.task
from company as a
left join task as b
on a.name=b.name
order by company,time
;
quit;