4. CUSTOMIZATION › 4.4 Accounting for Complex-Level External Files › 4.4.2 Defining the Complex-Level Ext. File Input Routine

4.4.2 Defining the Complex-Level Ext. File Input Routine

The complex-level external file input routine contains the
SAS code used to read the external data source.  The routine
is stored in the member ACTUfffI in sharedprefix.MICS.SOURCE,
where "fff" is the last three characters of the external file
name defined in Section 4.4.1.1.  It is invoked when external
file charging is performed.


CODING CONSIDERATIONS

o The routine must be a valid SAS routine with no embedded
  DATA or PROC statements.

o The routine must either set YEAR, MONTH, ACTYEAR, and
  ACTMONTH or set ENDTS.  If the routine does not set the
  YEAR, MONTH, ACTYEAR, and ACTMONTH variables, they will be
  derived from the ENDTS.  This prevents inconsistencies
  between YEAR and MONTH compared to ACTYEAR and ACTMONTH
  which can cause problems with external file aging.

o The routine must set the variables SYSID and SUBSYSID if
  you are using system or subsystem algorithm qualification.

o The quantities to be used for charging must be read from
  the input file.

o The COSTCTR variables must be assigned.  This can be done
  in your external file input routine or in
  sharedprefix.MICS.PARMS(COSTRTE).  If you place the code in
  COSTRTE:

  - All cost center assignments can be done by a centralized
    routine.

  - You must test the variable ROUTINE for the value
    fffINPUT, where "fff" is the last three characters of the
    external file name.  Code the following SAS statement in
    your input routine:

        %INCLUDE SHRPARMS(COSTRTE);


The following sections contain a worksheet and example to
help you write the complex-level external file input routine:

 1 - Complex-Level Ext. File Input Routine Worksheet
 2 - Complex-Level Ext. File Input Routine Example