proc sql;
create table temp as
select id, avg(avg) as avg
from sasuser.mis301f2010
group by id;
run;
proc means data=temp;
run;
data temp;
set temp;
adj = 4.38-avg;
run;
proc sql;
create table sasuser.mis301f2010 as
select a.*, b.adj
from sasuser.mis301f2010 a left join temp b
on a.id = b.id;