topic Re: countif function in SAS Procedures

countif function

Greek — Mon, 16 Dec 2013 15:22:29 GMT

Good morning,

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

Have

Mary

Jim

Steven

Want

Thank you!

Reeza — Mon, 16 Dec 2013 16:18:09 GMT

PROC FREQ.

Proc freq data=sashelp.class;

Table Age/Out=Age_Categories;

run;

Marina — Mon, 16 Dec 2013 20:04:07 GMT

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__ — Mon, 16 Dec 2013 20:27:50 GMT

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 — Mon, 16 Dec 2013 20:53:22 GMT

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!