countif function

[Greek]

Good morning,

I was wondering whether there is a countif function like the one in Excel that can count across rows...

Have

Mary

Mary

Mary

Jim

Jim

Jim

Jim

Jim

Steven

Steven

Want

Mary	3
Jim	5
Steven	2

Thank you!

[Reeza · Accepted solution]

PROC FREQ.

Proc freq data=sashelp.class;

Table Age/Out=Age_Categories;

run;

[Marina]

You also can use PROC SQL or PROC MEANS:

proc sql;

create table want as

select distinct name,

count(name) as count_names

from have

group by name;

quit;

proc means data=have;

class name;

output out=want

     (where=name ne ' '

     drop=_type_

     rename=_freq_=count_names);

run;

[data_null__]

Check the documentation regarding the NWAY option and you won't need the where data set option.

Also check out TYPES and WAYS statements.

[Greek]

Proc Freq! Of course!

Thank you.

I wish i knew how to use sql. I keep on bumping to it. It is on my list!