Performing Queries Using PROC SQL - 34 of 37

PHOTO EMBED

Sat Nov 02 2024 12:26:54 GMT+0000 (Coordinated Universal Time)

Saved by @VanLemaime

     proc sql;
        select jobcode,avg(salary) as Avg
           from sasuser.payrollmaster
           group by jobcode
           having avg(salary)>40000
           order by jobcode;
content_copyCOPY

https://sas.1or9.com/fru3oq9fam/59267/m10/m10_34.htm