another try

来源: 2010-07-13 19:34:17 [博客] [旧帖] [给我悄悄话] 本文已被阅读:

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;