data temp;

set temp;

avg = mean(q1, q2, q3, q4, q5, q6);

run;

proc sql;

create table temp2 as

select Group__, avg(avg) as avg

from temp

group by Group__;

data temp2;

set temp2;

avg=avg*0.9;

run;