Previous Topic: 5.2.4.3 CICCIN Usage Considerations

Next Topic: 5.2.5 CICS File/DBD Activity File (CICCSF)

5.2.4.4 CICCIN 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.  Generate a horizontal bar graph of yesterday's incident
    counts by hour.

      PROC CHART DATA=&PCICX..CICCIN01;
      HBAR HOUR / SUMVAR=CINCOUNT DISCRETE;
      RUN;

2.  Generate a frequency table of the occurrence of incidents
    by incident code.  Use month-to-date data.

      PROC FREQ DATA=&PCICM..CICCIN00;
      TABLES CINCODE / NOROW NOCOL; WEIGHT CINCOUNT;
      RUN;