data crackman;
input name year month y@;
cards;
1 1991 1 1
1 1991 2 2
1 1991 3 3
1 1992 1 3
1 1992 2 2
1 1992 3 1
2 1991 1 4
2 1991 2 2
2 1991 3 6
2 1992 1 6
2 1992 2 2
2 1992 3 4
;
run;
proc sort out=crackman;
by year month;
run;
proc sql;
create table result as
select name, year, month, y,avg(y) as avg ,(y/calculated avg-1)*100 as rate from crackman group by year, month;
quit;
proc print;
run;