This is my first time using PROC SQL. My task is to identify the average, min, and max salary by department. I have successfully calculated the stats, but cannot seem to figure out how to present each department uniquely. I have no errors on my log. proc sql;
create table salinfo as
select
Dept_ID,
Dept_Name,
mean (Salary) as AverageSalary format=comma12.,
min(Salary) as MinSalary format=comma12.,
max(Salary) as MaxSalary format=comma12.
from work.combine;
quit;
... View more
