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 |
proc sql;
create table want as
select group, sum(yes) as count
from your_dataset
group by group;
quit;
proc sql;
create table want as
select group, sum(yes) as count
from your_dataset
group by group;
quit;
Or use PROC SUMMARY
proc summary data=your_dataset nway;
class group;
var yes;
output out=want(drop=_:) sum=count;
run;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.