data AllSubjects(keep=Age Subject); input Age @; do i=1 to 3; input Subject $ @; output; end; datalines; 13 Math History English 14 Math Science English run; proc sql; create table schedules_sql as select Class.*, Subject from sashelp.class(where=(Age in (13,14))), AllSubjects where Class.Age=AllSubjects.Age order by Subject, Age, Name; quit; proc print data=schedules_sql; by Subject; id Subject; title1 "Many-to-many results"; run;