大家好,我想把若干个数据库进行合并(求并集而非交集),使用人大经济论坛上一个高手的程序,但是报错了,请各位帮着看看咋回事!
/*合并控制变量数据库,放在work逻辑库中*/
proc sql;
create table control as
select distinct
a.stkcd, a.accper,a.accperyy,
b.pay_top3,
c.shrcr1,c.shrcr3
from
cont.earning as a
union all
cont.gaoguanxinchou as b
union all
cont.guquanjizhong as c
on a.stkcd =b.stkcd =c.stkcd
and a.accper=b.reptdt=c.reptdt
order by stkcd;
quit;
[img]file:///D:\Documents\Tencent Files\313519864\Image\[T)1O5ET)])[P`]1}_6L4GY.jpg[/img]