5. FILES › 5.2 HAR Information Area Files › 5.2.2 Physical Channel Activity File (HARPCA) › 5.2.2.4 Retrieval Examples

5.2.2.4 Retrieval Examples

This section presents typical HARPCA retrieval examples.


In the examples, a SAS macro variable is used to specify the
DDname part of the CA MICS file name. These macro variables
are a standard part of CA MICS and are available for all
files. The macro variable name has the form &diiit, where d
is the database identifier, iii is the information area
name, and t is the timespan.  For the examples, a database
identifier of P is used.  The identifier is installation
dependent, so you should find out what the identifiers are at
your installation.

1.  Print yesterday's channel busy percentage for each RMF
    measurement interval for channel 4:

    DATA;
    SET &PHARX..HARPCA01;
    IF CHANNEL='4';
    PROC PRINT; VAR SYSID STARTTS ENDTS PCAPCBSY;

2.  Print yesterday's average and maximum hourly channel busy
    percentages for each hour in zone 1 for channel B:

    DATA;
    SET &PHARD..HARPCA01;
    IF ZONE='1';
    IF CHANNEL='B';
    PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
                PCAPCBSY PCAMPBSY;

3.  Display the average percent channel busy over the last
    six weeks for prime time (zone 1) hours:

    DATA FILE1;
    SET &PHARW..HARPCA01 &PHARW..HARPCA02
        &PHARW..HARPCA03 &PHARW..HARPCA04
        &PHARW..HARPCA05 &PHARW..HARPCA06;
    IF ZONE='1';
    %LET BY = SYSID CHANNEL CPUID YEAR WEEK ZONE;
    %LET BREAK = ZONE;
    PROC SORT DATA = FILE1; BY &BY;
    DATA FILE1;
    SET FILE1;
    %PCASUM;
    PROC PRINT; VAR SYSID CHANNEL CPUID YEAR WEEK
                PCAPCBSY;