create table btd.all3 as
select distinct
a.ind1-ind12, /*请教:sql语句好像不能识别这种var1-varN的类似表达啊???计算出来的数据集用了一个temp……代替,全是空值*/
a.year2000-year2010,
b.*
from cont.control as a
right join
btd.all2 as b
on a.stkcd=b.stkcd and a.year=b.year;
quit;
proc sql;
create table btd.all3 as
select distinct a.in1,a.in2,a.in3,a.in4,a.in5,a.in6,a.in7,a.in8,a.in9,a.in10,a.in11,a.in12,
a.in13,a.in14,a.in15,a.in16,a.in17,a.in18,a.in19,a.in20,
a.y1,a.y2,a.y3,a.y4,a.y5,a.y6,a.y7,a.y8,a.y9,a.y10,a.y11,a.y12,
b.*
from cont.control_yy_w2 as a right join btd.all2 as b
on a.stkcd=b.stkcd and a.year=b.year;
quit;