Mike, two thoughts, off the top of my head - 1.) two queries one to get number of employees and average salary for entire company, attributing each to a (macro) variable, and the other to calculate the individual department numbers. 2.) As Reeza mentions, use a sub-query to calculate the aforementioned company figures, then join to the aggregates for each department: something like proc sql; select department, avg(salary) as calculated dept_avg_salary, dept_avg_salary/company_avg_salary as pct_of_overall format=percent8.1 from employees inner join (select avg(salary) as company_avg_salary from employees)... quit;
... View more