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
Last Updated: March 1, 2024