another try

来源: 暖小蛇于 2010-07-13 19:34:17 [档案] [博客] [旧帖] [给我悄悄话] 阅读数 : (405 bytes)

回答: 太对了，谢谢！由 Janezhu 于 2010-07-13 18:41:54

proc sort data=dataset; by name date; run;

data dataset;
set dataset;
by name date;
if first.name then do;
counter=0;
retain counter;
end;
counter+1;
run;

proc sql;
select name, avg(ret) as avg_ret_1 from dateset
group by name;
run;

proc sql;
select name, avg(ret) as avg_ret_2 from dateset
where counter gt 1
group by name;
quit;