https://communities.sas.com/t5/SAS-Procedures/proc-freq-doesn/m-p/19099#M3832 there're many teachers working for different department,most of them will teach in more than one department.count frequency of teachers for each year and each school.<BR /> sample:<BR /> department year teacher<BR /> econ 2002 Samon<BR /> econ 2003 Samon<BR /> manag 2003 Stephen<BR /> manag 2003 Sissi<BR /> Chem 2002 Sissi<BR /> Chem 2003 Samon<BR /> Math 2003 Stephen<BR /> Math 2004 Laura<BR /> Eng 2002 Laura<BR /> Eng 2003 Stephen Mon, 10 May 2010 22:12:44 GMT deleted_user 2010-05-10T22:12:44Z https://communities.sas.com/t5/SAS-Procedures/proc-freq-doesn/m-p/19099#M3832 there're many teachers working for different department,most of them will teach in more than one department.count frequency of teachers for each year and each school.<BR /> sample:<BR /> department year teacher<BR /> econ 2002 Samon<BR /> econ 2003 Samon<BR /> manag 2003 Stephen<BR /> manag 2003 Sissi<BR /> Chem 2002 Sissi<BR /> Chem 2003 Samon<BR /> Math 2003 Stephen<BR /> Math 2004 Laura<BR /> Eng 2002 Laura<BR /> Eng 2003 Stephen Mon, 10 May 2010 22:12:44 GMT https://communities.sas.com/t5/SAS-Procedures/proc-freq-doesn/m-p/19099#M3832 deleted_user 2010-05-10T22:12:44Z