Counting unique values

[heretolearn]

Hello!

Can someone guide me how to count unique values across rows by a certain variable? Below is my dataset:

id     med    class

1      A         1

1      B         1

1      C         2

1      D         4

2      S         3

2      A         1

3      A         1

This is what I would like

id    count_med    count_class

1     4                    3

2     2                    2

3     1                    1

Thank you!

[novinosrin · Accepted solution]

data have;
input ID   med  $  class;
cards;
1      A         1
1      B         1
1      C         2
1      D         4
2      S         3
2      A         1
3      A         1
;
run;
proc sql;
create table want as
select id,count(distinct med) AS count_med, 
             count(distinct class) as count_class
from have
group by id;
quit;

[heretolearn]

Great, thank you!