Common Techniques Used In Reporting › 5.1 Specifying the Input File

5.1 Specifying the Input File

Fully Qualified File Names
--------------------------

CA MICS files are actually SAS data sets.  A SAS data set may
be specified in a SET statement in the following format:

SET filename;

To access a CA MICS file in a SAS program, the file name must
be fully qualified.  This means it must be composed of the CA
MICS file name concatenated after a z/OS DD name, in the
following format:

&diiit..iiifffcc

where:

&  Identifies the following expression as a SAS macro
   variable.  This macro is provided by CA MICS.  SAS uses it
   to find the actual DD name/file name combination for you.

d  Identifies the specific database you want to access.

t  Identifies the timespan, as follows:

   X is DETAIL
   D is DAYS
   W is WEEKS
   M is MONTHS
   Y is YEARS
   T is TABLES

iii  The information area, as described in File Naming
     Conventions.

fff  A file, as described in File Naming Conventions.

cc   The cycle, as described in File Naming Conventions.

For example, to identify the most recent daily cycle of the
CPU Activity File (HARCPU) in the primary database (P), in
the DAYS timespan, you would specify

SET &PHARD..HARCPU01;

The macro in this statement would then be expanded by SAS
into this statement:

SET PDAYS.HARCPU01;

Since the z/OS data set where the CA MICS file is located may
change at any time, this macro technique gives you a way to
identify your report's input files that does not depend on
their location.


The LIBNAME Statement
---------------------

If you need to access a CA MICS file that is not in one of
the CA MICS databases residing on DASD, like history audit
archive files and history archive files, you could use the
LIBNAME SAS statement.  For example, to access the audit
archive tape for the BATJOB file, you would code the
following:

LIBNAME GETAUD 'PRIMARY.MICS.AUDIT.BATJOB(0)';


The MFILE Macro
---------------

A CA MICS macro named MFILE is available to simplify the
specification of CA MICS database files.  It is most useful
when you must specify a range of cycles for a file.  Here are
two examples:

SET %MFILE(DATABASE=d,TIMESPAN=t,FILE=fc);

SET %MFILE(DB=d,TS=t,F=fc);

where:

d  Is the database identifier for the specific database you
   want to access.

t  Is the full name for the timespan: DETAIL, DAYS, WEEKS,
   MONTHS or YEARS.

fc Is the three-character abbreviation identifying a specific
   file followed by a 2-digit cycle number or a 5-digit cycle
   range.  Therefore fc is either 5 or 8 characters long:

   o For a single file cycle, specify fffcc.

   o For a range of cycles, specify fffcc-cc.