我做了以下这个SAS code.
目的在于做一个各学院的成绩分析，最后也达到了我想要的效果。
现在我想要在最后输出结果的时候，一， 能把统计的数据表和对应的Gchart做成一一对应的关系（因为我是用MACRO做的table和gchart,所以现在只能显示完全部的统计表，再显示所有的直方图，不是那么直观。

二， 如果能把科目的名称（course_identification)也放在排头里面就好了。

谢谢大家




proc sql;
create table work.grades as select t1.*,
t2.college,
t2.college_desc,
t2.department,
t2.department_desc,
t2.academic_period_desc
from odsstu.registration_enrollment t1
join odsstu.course_catalog t2
on t1.academic_period=t2.academic_period and
t1.course_identification=t2.course_identification
where
t1.academic_period ="&academic_period" and
t1.census_period = '0' and
t1.grade_type in ('C','R','S') and
t1.final_grade not is missing and
t2.college="&college"
order by college asc, course_identification asc, final_grade desc;
quit;

data _null_;
set grades;
call symput('academic_period_desc',trim(academic_period_desc));
run;

proc freq data=grades order=data;
by course_identification;
tables final_grade;
title 'Grade Distribution for '"&academic_period_desc"' Semester';
run;

proc gchart data=grades;
by course_identification;
vbar final_grade;
title 'Grade Distribution for '"&academic_period_desc"' Semester';
run;