Previous Topic: 4.2.4.4.3 Name Statement (NAME or NAMX)

Next Topic: 4.2.4.4.5 Data Dependency Statement (DEPEND)

4.2.4.4.4 Computation Statement (EXP)

This statement defines SAS statements necessary to calculate
the value of a derived data element.  The expression
statement must follow the NAME statement (normal, @@FIRST,
@@LAST) to which it applies and have a TYPE statement defined
as compute (C).  Note that an expression statement is not to
be provided if the TYPE statement is defined as compute with
no expression (CN).

This statement is used to define the computation of averages,
percentages, and special computations (for example, avg
working set size).

Note: The validity of the SAS statements is not checked
during component generation. Errors in the expression will
not be realized until derived elements are computed during
the daily update or reporting.

STATEMENT FORMAT

   EXP nn xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
       |   |
       |   +---EXPSTAT - SAS statement(s).
       |
       +--- EXPNO - Expression sequence number.


STATEMENT OPTION DEFINITIONS

EXP - Defines the computation expression.

      EXPNO - Expression sequence number.  If there is only
              one statement to the expression this value is
              01.  If multiple statements are required then
              this sequence number defines the order that the
              statements appear and is incremented by one.

      EXPSTAT - SAS statements defining derivation formulas
                (columns 8-69).  Multiple statements are
                concatenated as a single expression.  The
                expression in a single statement is a maximum
                of 61 characters in length.

STATEMENT EXAMPLE

The following examples illustrate the recommended way
to compute an average, percentage, and special value.

Average Concurrent TSO Users
----------------------------

EXP 01 IF INTERVLS > 0 THEN TSOAVUSR=TSONOUSR / INTERVLS;


Percent of Batch Jobs Meeting Target
------------------------------------

EXP 01 IF JOBCOUNT > 0 THEN JOBPCMET=(JOBSRVMT*100)/JOBCOUNT;


Control Performance Group Average Working Set Size
--------------------------------------------------

EXP 01 IF PGAMSD*PGACTS > 0 THEN
EXP 02   PGAAVRSF=(PGAMTS*PGACSD*50)/(PGAMSD*PGACTS);
EXP 03 ELSE PGAAVRSF=0;