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;