call symput("t_year",put(intnx('day',date(),-1),year4.)); *昨天的当前年份;
%macro aa;
%if &t_year='2018' or &t_year='2019' %then %do;
proc sql;
create table z7 as
select a.xiangmu,a.mubiao,a.xishu, b.yj_ly label='去年平均' ,a.yue1,a.yue2,a.yue3,a.yue4,a.yue5,a.yue6,a.yue7,a.yue8,a.yue9,a.yue10,a.yue11,a.yue12
from z5 a left join z6 b
on a.xiangmu=b.xiangmu;
quit;
%end;
%else %do;
proc sql;
create table z7 as
select a.xiangmu,a.mubiao,a.xishu, b.yj_ly label='去年平均' ,a.yue1,a.yue2,a.yue3,a.yue4,a.yue5,a.yue6,a.yue7,a.yue8,a.yue9,a.yue10,a.yue11,a.yue12
from z5 a left join qxnpj b
on a.xiangmu=b.xiangmu;
quit;
%end;
%mend;
%aa;