4. FILES › 5.2 VTS Component Files › 5.2.4 VTS Component HVT Information Area Files › 5.2.4.11 Hnode Grid Activity File (HVTGRC) › 5.2.4.11.4 HVTGRC Retrieval Examples

5.2.4.11.4 HVTGRC 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.  Using the most recent DAYS timespan HVTGRC file, display
    the queue status for data and volumes to be transferred
    to another cluster, per hour.
 
    PROC SUMMARY DATA=&pHVTd.HVTGRC01 NWAY;
      CLASS HVTCLID HOUR ;
      VAR GRCAVDQA GRCAVIQA GRCAVDTC GRCAVLVC;
      OUTPUT OUT=STATS MEAN=;
    RUN;
      PROC PRINT DATA=STATS LABEL;
      ID HOUR;
      VAR HVTCLID GRCAVDQA GRCAVIQA GRCAVDTC GRCAVLVC;
      TITLE 'Cluster Transfer Queue Status';
    run;