/*生成上年度值*/

proc sql;

create table btd.sq_all0 as select distinct

a.*,

b.zichan as sq_zichan,

b.dysdszc as sq_dysdszc,

b.dysdsfz as sq_dysdsfz,

(a.dysdsfz-(calculated sq_dysdsfz))-(a.dysdszc-(calculatedsq_dysdszc)) as dddysdsfy

from

all0 as a

left join

all0 as b

on a.stkcd=b.stkcd and a.year=b.year+1

order by stkcd,year;

quit;