data src_rec; input name $ sex $ school $ dt date9. score; datalines; AAA F Law 9-sep-14 10 BBB F IT 10-Aug-14 20 CCC M Law 19-Sep-14 30 DDD F Art 10-Dec-14 25 EEE F Law 9-sep-14 40 FFF M Biz 10-Aug-14 45 GGG F Law 9-Dec-14 55 HHH M IT 6-Dec-14 50 III M Law 19-Nov-14 45 JJJ M Art 10-Aug-14 20 kkk F Law 9-Dec-14 25 lll F Biz 8-Dec-14 20 ; run; data date_flg ; set src_rec; if intck('day',(INTNX('week',dt,0,'B' )),today())>= 7 then do; flag = 'This week' ; else do; flag = 'last week' ; run; proc tabulate data = date_flg; class school sex flag; var score; table (school*sex ),flag='No of student Registered'*n=''(flag='Sum of score'*score=''*sum='')(flag='Avg of score'*score=''*mean='') ; run;
... View more