- /*解决实际问题之关联不同公司不同年份相同职员所做的任务*/
- /*关联公司职员表与职员所做的任务表*/
- 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;