proc sql;
select a.Name, b.Sex, c.Age
from SASHELP.CLASS as a
left join SASHELP.CLASS as b
on a.Name = b.Name
left join SASHELP.CLASS as c
on a.Name = c.Name;
quit;
多个表格left join
proc sql;
select a.Name, b.Sex, c.Age
from SASHELP.CLASS as a
left join SASHELP.CLASS as b
on a.Name = b.Name
left join SASHELP.CLASS as c
on a.Name = c.Name;
quit;
你在sas里面合并多张表 如果每张变都有相同的字段能配上 你就用左连接 连接多少张表都可以吧
比如:
proc sql;
create table 表名 as
select a.cust_id,a.var2......,b.var1,b.var2......,c.var1,c.var2....
from 表1 a left join 表2 b on a.cust_id=b.cust_id left join 表3 c on a.cust_id=c.cust_id.......照此可以继续.........................;
quit;
这种可以拼接多张表,根据自己的条件来