Hi, I've got a data set that looks like this (let's assume the grades are only A B C D): Test Grades 1 A 1 B 1 B 1 A 1 C 1 B 1 A 1 C 1 B 1 A I want to count how many grades are there for each type (including D) and the result to look like the following: Test Grades Number 1 A 4 1 B 4 1 C 2 1 D 0 I am using the followin code: proc sql; create table want as select test, grades, count(*) as number from have group by est, grades order by est, grades; quit; And the problem is that this code doesn't add the row that shows there are 0 D.
... View more
