Minimum, Maximum and Average Salary By Class

You can easily perform calculations on the values of fields by using prefix operators.  In the example below, the prefix operators, MIN., MAX. and AVE. are used to obtain the minimum, maximum and average salary rate by class code for all active/on leave positions within the CSU.  Note:  The verb ADD or WRITE can be used in place of SUM.  For an additional example of using prefix operators, see the sample program: Identifying New Hires.

 

EX SAC

TABLE FILE SAC

SUM MIN.SAC:SALARY

    mAX.SAC:SALARY

    aVE.SAC:SALARY

BY SAC:CLASS

END