Count function

[hypart]

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!

[lakshmi_74 · Accepted solution]

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;

[hypart]

Thanks so much!  You're awesome!

[ballardw]

proc tabulate data=have;

    class name grade;

    table name, grade*n='';

run;

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

[hypart]

Thank you