Calculating distinct counts per another variable

[BenBrady]

I would like to calculate the distinct 'person type' by 'qual' in my example attached. I know you can do this using sql but just wasnt sure how.

[novinosrin · Accepted solution]

Do you mean this?

proc sql;
create table want as
select qual, count(distinct person_type) as count
from your_data
group by qual;
quit;