Count function

[hmc]

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

[ChrisBrooks]

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;

[hmc]

Thank you, can i use that code in SAS? 

[ChrisBrooks]

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.

[MikeZdeb · Accepted solution]

Hi, or other PROCS ...

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

proc freq data=x;
table name;
run;

[hmc]

thank you i got it