Common Techniques Used In Reporting › 5.2 Using CA MICS Files › 5.2.3 Unlike Files and a Single Cycle

5.2.3 Unlike Files and a Single Cycle

You can combine the observations from different files into
combined observations in a new SAS data set, as long as the
files have common keys and a common sequence.

Assume that you want to display the percent of time that the
CPU was busy and the system's page-in rate by hour of the day
for yesterday.  You would find that the two variables that
you need are in two different files, as shown below.

File       Variable  Description

HARCPUnn   CPUPCBSY  Pct CPU BUSY
SCPPAGnn   PAGPSDPG  Demand Page Rate

Both files are in the DAYS timespan and have common keys and
sequence, thereby enabling a direct combination of their
respective observations by the SAS MERGE technique.  You can
verify this by checking the File Organization topics for the
two files in the Files chapter of the Hardware and SCP
Analyzer Guide or by using the Data Element Browse feature
described in the Document Access Guide.

The SAS statements result in the variables from each file
being combined into a single output observation.  If an
observation is missing in one file for a corresponding
observation in the other, the variables from that file are
set to missing (.) in the output observation.

The output observations resulting from the program and
illustration in Figure 5.3 are shown below with indications
that the variables have been set with actual values or were
set to missing.

      DAY    HOUR  CPUPCBSY PAGPSDPG
    +-------------+-----------------+
    |   1      8  |    N         N  |
    +-------------+-----------------+
    |   1      9  |    N         .  |
    +-------------+-----------------+
    |   1     10  |    N         N  |
     +-------------+-----------------+
    |   1     11  |    .         N  |
    +-------------+-----------------+

    DATA NEWFILE;
    SET &PHARD..HARCPU01 &PSCPD..SCPPAG01;
      BY SYSID YEAR MONTH DAY HOUR;


        HARCPU01             NEWFILE              SCPPAG01
      DAY    HOUR                               DAY    HOUR
    +-------------+       Observation #       +-------------+
    |   1      8  |---+         1         +---|   1      8  |
    +-------------+   |                   |   +-------------+
    |   1      9  |--+|         2         |+--|   1     10  |
    +-------------+  ||                   ||  +-------------+
    |   1     10  |-+||         3         ||+-|   1     11  |
    +-------------+ |||                   ||| +-------------+
                    |||                   |||
                    |||                   |||
                    |||                   |||
                    |||                   |||
                    |||    DAY    HOUR    |||
                    |||  +-------------+  |||
                    ||+--|   1      8  |--+||
                    ||   +-------------+   ||
                    |+---|   1      9  |   ||
                    |    +-------------+   ||
                    +----|   1     10  |---+|
                         +-------------+    |
                         |   1     11  |---+|
                         +-------------+


Figure 5-3.  Combining Unlike CA MICS Files