topic Re: counting the number of cases for a particular variable using another in SAS Programming

counting the number of cases for a particular variable using another

BenBrady — Fri, 13 Mar 2020 00:58:14 GMT

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

novinosrin — Fri, 13 Mar 2020 01:00:50 GMT

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

novinosrin — Fri, 13 Mar 2020 01:04:06 GMT

Or use PROC SUMMARY

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

ballardw — Fri, 13 Mar 2020 14:38:53 GMT

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;