topic Re: Count function in SAS Programming

Count function

hypart — Wed, 12 Apr 2017 04:24:16 GMT

I have a dataset with thousands of datalines that I need counted. Here's an example of what I'm trying to do:

dataset exampe1:

eric	a
eric	b
eric	a
eric	b
eric	a
sara	b
sara	c
sara	b

I would like to take dataset example1 and create this output:

	# of times a	# of times b	# of times c
eric	3	2	0
sara	0	2	1

Thank you!

Re: Count function

lakshmi_74 — Wed, 12 Apr 2017 04:43:27 GMT

proc sql;
create table want as
select name,grade, count(*) as total from one group by name,grade;
quit;
proc transpose data=want out=result(drop=_NAME_) prefix=total_;
by name;
id grade;
var total;
run;

Re: Count function

hypart — Wed, 12 Apr 2017 05:23:02 GMT

Thanks so much! You're awesome!

Re: Count function

ballardw — Wed, 12 Apr 2017 15:20:11 GMT

proc tabulate data=have;

class name grade;

table name, grade*n='';

run;

If you want a report and do not need a dataset.

Re: Count function

hypart — Thu, 13 Apr 2017 05:29:32 GMT

Thank you