topic Re: PROC SUMMARY in New SAS User

PROC SUMMARY

Kirito1 — Tue, 10 Jan 2023 07:24:46 GMT

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.

Re: PROC SUMMARY

Kirito1 — Tue, 10 Jan 2023 07:31:46 GMT

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.

Re: PROC SUMMARY

Kurt_Bremser — Tue, 10 Jan 2023 07:32:16 GMT

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;