SUM FUNCTION ON A RANGE

The sum function can be executed on a range of data by using a short script.
This needs to be executed as a block of script so that everything gets passed
to the interpreter at the same time. Otherwise after the screen refreshes,
the
range will reset automatically thereby allowing the sum function to operate
on the entire column.

Example code for the above is:

def RangeSum{
set %1 -bs %2; /* set starting row to 2nd parameter */
set %1 -es %3; /* set ending row to 3rd parameter*/
sum(%1); /* apply sum function */
set %1 -e; /* reset range */
};

This will now define the macro RangeSum which will accept 3 parameters.
To use the macro, use the following syntax:

RangeSum Data1_b 5 20;

This will perform the sum function on the dataset Data1_b for rows 5 through
20.

PICK PEAKS TOOLBAR