counting the number of cases for a particular variable using another

[BenBrady]

I have a dataset similar to the table below (but much bigger). I want to know the number of 'yes' per group.

i.e so group a would be 2, b would 3 and c 1. Not sure how to write code to do this on the large scale

group	yes
a	1
a	1
a
b	1
b	1
b	1
c	1
c
c

[novinosrin · Accepted solution]

proc sql;
create table want as
select group, sum(yes) as count
from your_dataset
group by group;
quit;

[novinosrin]

Or use PROC SUMMARY

proc summary data=your_dataset nway;
class group;
var yes;
output out=want(drop=_:) sum=count;
run;

[ballardw]

If you want a report that people read, and may need to made "pretty" consider Proc Report:

proc report data=have;
   columns group yes;
   define group / group;
run;