topic Re: What is a SAS procedure that can be used to count the number of people? in New SAS User

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

sasnewbie5 — Mon, 10 Dec 2018 21:39:19 GMT

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!

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

novinosrin — Mon, 10 Dec 2018 21:46:09 GMT

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;

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

sasnewbie5 — Mon, 10 Dec 2018 21:49:45 GMT

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.

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

r_behata — Mon, 10 Dec 2018 21:52:28 GMT


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

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

PeterClemmensen — Mon, 10 Dec 2018 21:59:06 GMT

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;

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

sasnewbie5 — Mon, 10 Dec 2018 23:08:32 GMT

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;