proc sql; select distinct lastname label "Took Orders", takenby, count (shipped) as ordship from vlib.allemp, vlib.allordr where takenby=empid group by takenby having ordship=6; ...

This example uses the SQL procedure to query the ORACLE table PAYROLL. The PROC SQL query retrieves all job codes and provides a total salary amount for each job code. libname myoralib oracle ...