PROC SUMMARY

[Kirito1]

I was working on a data where I want to have a summary of the data using proc summary. The sample data as below.

Now what I want is how many email ids that emp_code has...Something like below

Can someone help how can I achieve this...........Thank you in advance for all the contributors.

[Kirito1]

Because when I try to use proc summary for this.........An error pops up........stating
ERROR: Variable EMAIL_ID in list does not match type prescribed for this list. I know this could be done using proc freq but I have to use proc summary cuz I have some omre functions to apply on the dataset I am working on.

[Kurt_Bremser · Accepted solution]

Counting is done in PROC FREQ:

proc freq data=have;
tables emp_code;
run;

or, in SQL:

select emp_code, count(*) as freq_email
from have
group by emp_code;