EDIT GROUP

EDIT GROUP allows you to edit fields defined by COMPUTE ... GROUP BY. You can also specify how many lines to skip between groups and define the separator character that separates a grouping from its computed value.

Syntax:

►►─── EDIt GROup ─┬─ group-by-expression ─┬───────────────────────────────────►
                  └─ ALL ─────────────────┘

 ►─┬───────────┬──────────────────────────────────────────────────────────────►
   └─ LEVel n ─┘

 ►─┬──────────────────────┬───────────────────────────────────────────────────►
   └─ SKIp ─┬─ n lines ─┬─┘
            └─ PAGe ────┘

 ►─┬───────────────────────────────────────────┬──────────────────────────────►◄
   └─ SEParator character separator-character ─┘

Parameters:

group-by-expression: An expression specified in the GROUP BY clause of the COMPUTE command is edited. This group-by-expression must identically match the expression specified in the GROUP BY clause of the COMPUTE command.
ALL.: All of the expressions specified in the GROUP BY clause of the COMPUTE command are edited.
LEVEL n: Specifies the break level, in numeric order, with 1 representing the highest level. The default n value is 1.
SKIP n LINES/PAGE: Specifies to skip n lines or a page between the computed expression and the next grouping.
SEPARATOR CHARACTER: Defines the character that separates the grouping from its computed expression. Separator-character-value must be one character in length.

Example:

If you specify a separator character of - (hyphen), your report would look like:

DEPARTMENT/EMPLOYEE/EMPOSITION REPORT mm/dd/yy DEPT-ID-0410 EMP-LAST-NAME-0415 SALARY-AMOUNT-0420 2000 NICEMAN 14000.00 --------------------- TOTAL SALARY 214500.00 1000 FITZHUGH 13000.00 1000 JOHNSON 13500.00 1000 ORGRATZI 39000.00 1000 PEOPLES 80000.00 --------------------- TOTAL SALARY 145500.00 -2-