4. CUSTOMIZATION › 4.3 Specifying Rates › 4.3.1 Defining the Rate Table › 4.3.1.8 Specifying an Ext. Journal File Preprocessing Exit

4.3.1.8 Specifying an Ext. Journal File Preprocessing Exit

This section only applies if you are specifying options for
an external journal file in an external file unit.

You can write an optional exit to preprocess the data from
your external file.  The data set you create in this
preprocessing exit is the data set that should be input (SET)
in the external journal file input routine.  The
preprocessing exit is called prior to the SAS DATA step that
reads in the data.

Write the exit by selecting Option 7 on the Rate Table File
Options Menu (MWF;4;2;3;6;7).  The exit is automatically
placed in the ACTUJjjR member in your prefix.MICS.USER.SOURCE
data set where "jjj" is the external journal file name.
ACTUJjjR is created if it does not exist.

You may want to write a preprocessing exit if your external
file contains detailed data that you want to summarize before
it is read into the external journal file.  For example, if
your external file contained detailed processing records from
a tape management system, you could summarize the data by
user and total tapes mounted for the period.


CODING GUIDELINES

The code in this exit must be a complete SAS DATA or PROC
step or a series of SAS DATA or PROC steps.

The following sections contain a worksheet and example to
help you write the external journal file preprocessing exit:

 1 - External Journal File Preprocessing Exit Worksheet
 2 - External Journal File Preprocessing Exit Example