/*合并控制变量数据库,放在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]