I have some data Year Student ID Class 2000 1 Math 2000 2 Math 2000 3 English 2000 4 English 2001 1 Math 2001 2 Chemistry 2001 3 English 2001 1 Chemistry And want to create a table for the number of distinct students and distinct classes. i.e. Year Student ID Class 2000 4 2 2001 3 3 However, my code: proc sql;
create table a.registry as select distinct year as year, count(distinct i.student) as student, count(distinct i.class) as class
from a.list i;
quit; gives me the same value each year, i.e. Year Student ID Class 2000 4 3 2001 4 3 Does anyone know how to fix this?
... View more