topic Re: Calculating distinct counts per another variable in SAS Programming

Calculating distinct counts per another variable

BenBrady — Sun, 08 Dec 2019 22:49:55 GMT

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 — Sun, 08 Dec 2019 23:00:03 GMT

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;