对于一年求平均，很容易做，比如
proc sql;create table temp2 as select distinct
stkcd,year,
mean(a) as average_a
from temp1
group by stkcd,year
order by stkcd,year
;quit;
proc sql;
create table temp2 as select distinct
a.stkcd,a.year,
mean(b.a) as average_a
from temp1 a, temp1 b
where a.stkcd=b.stkcd and 0<=a.year-b.year<=1
/*每年计算当年以及前一年的平均*/
group by a.stkcd,a.year
order by a.stkcd,a.year
;quit;
扫码加好友，拉您进群
全部版块
我的主页
收藏
