topic Re: Count function in SAS Programming

Count function

hmc — Tue, 27 Jun 2017 15:48:58 GMT

hi, I have a data file something like this,

policynumber name

3 Jon

4 Alex

3 Jon

5 Tim

3 Jon

i want to count how many number of policies each individual has, can anyone please help me in this

Re: Count function

ChrisBrooks — Tue, 27 Jun 2017 16:00:37 GMT

There are a few different ways of doing this - you could do something like

proc sql;
	create table polcount
	as select name, count(name) as totalpols
	from have
	group by name;
quit;

Re: Count function

hmc — Tue, 27 Jun 2017 16:04:02 GMT

Thank you, can i use that code in SAS?

Re: Count function

ChrisBrooks — Tue, 27 Jun 2017 16:09:59 GMT

You certainly can - if it fits the bill could you mark my reply as an accepted solution please? It saves others from responding to an issue which has already been solved.

Re: Count function

MikeZdeb — Tue, 27 Jun 2017 16:30:06 GMT

Hi, or other PROCS ...

proc means data=x n nonobs;
class name;
run;

proc freq data=x;
table name;
run;

Re: Count function

hmc — Tue, 27 Jun 2017 16:42:39 GMT

thank you i got it