proc sql;
select a.item, a.mean as Patient, b.mean as comm
into:t1, :t2, :t3
from region.patient_core1 as a, comm.patient_core1 as b
where a.item=b.item ;
quit;
没搞懂楼主的问题。select into 是用来产生 宏变量的 (t1, t2, 和 t3)。如果要生成一个SAS data set，可以用一下命令：
proc sql;
create table 任意名字 as
select a.item, a.mean as Patient, b.mean as comm
from region.patient_core1 as a, comm.patient_core1 as b
where a.item=b.item ;
quit;
proc sql;
create table 任意名字 AS
select a.item, a.mean as Patient, b.mean as comm
from region.patient_core1 as a, comm.patient_core1 as b
where a.item=b.item ;
quit;
扫码加好友，拉您进群
全部版块
我的主页
收藏
