topic Re: Counting unique values in SAS Programming

Counting unique values

heretolearn — Wed, 20 Jun 2018 23:45:32 GMT

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!

Re: Counting unique values

novinosrin — Thu, 21 Jun 2018 00:01:55 GMT

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;

Re: Counting unique values

heretolearn — Thu, 21 Jun 2018 00:22:39 GMT

Great, thank you!