DATA Step, Macro, Functions and more

Counting unique values

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Counting unique values

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!


Accepted Solutions
Solution
a month ago
PROC Star
Posts: 1,833

Re: Counting unique values

Posted in reply to heretolearn
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;

View solution in original post


All Replies
Solution
a month ago
PROC Star
Posts: 1,833

Re: Counting unique values

Posted in reply to heretolearn
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;
Occasional Contributor
Posts: 15

Re: Counting unique values

Posted in reply to novinosrin

Great, thank you!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 66 views
  • 1 like
  • 2 in conversation