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;