第二个,按BG分组筛选。
proc sql;
select a.studentid,a.finaaid,avg(a.finaaid) as avg_finaaid,b.zip,
case when b.zip in (42101,42103,42104) then "BG"
else "NOTBG" end as new_zig
from finaid as a
left join zip as b on a.studentid=b.id
group by new_zig
having a.finaaid > (calculated avg_finaaid);quit;