What is a SAS procedure that can be used to count the number of people?

[sasnewbie5]

What is an appropriate procedure that I can use in SAS to count the number of people in each department? I've provided a snippet of the dataset.

Thanks!

[novinosrin]

proc freq/sql/summary.  take a look

proc sql;

create table want as

select dept, n(emp) as num_of_people

from have

group by dept;

quit;

[sasnewbie5]

Is there one that doesn't use SQL statements? I tried using the proc freq but for some reason it just output the dataset I already had.

[r_behata · Accepted solution]

proc freq data= emp noprint;
	tables dept / missing out=temp(drop=percent);
run;

[sasnewbie5]

How could I use a procedure to calculate the average salary and also the number of ppl in each department. The code I have below gives the following message: Statement is not valid or it is used out of proper order. Not sure what the problem is. I was trying to use proc means.

proc means data = hw9.combo;
	class dept;
	mean = salary;
run;

[PeterClemmensen]

Please post usable sample data in the form of a data step if you want tested, usable code answers 🙂

Do something like this

proc freq data=have;
   tables dept;
run;