5. FILES › 5.2 CICS Information Area Files › 5.2.8 CICS MRO Activity File (CICCMR) › 5.2.8.4 CICCMR Retrieval Examples

5.2.8.4 CICCMR 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 function ship request count by hour.

      PROC PRINT DATA=&PCICD..CICCMR01;
      ID HOUR; VAR CICSID CICAPU CMRCOUNT CMRELPTM;
      SUM CMRCOUNT CMRELPTM;
      RUN;

2.  Generate a summary report showing function shipping
    activity by CICSID and application unit (CICAPU) for the
    last three days.

      %LET BY = CICSID CICAPU MONTH YEAR DAY;
      %LET BREAK = DAY;
      DATA CICCMR(KEEP=%CMRKEEP(OP=FILEOPTS,TS=DAYS));
      SET &PCICD..CICCMR03
          &PCICD..CICCMR02
          &PCICD..CICCMR01;
      RUN;
      PROC SORT DATA=CICCMR;
      BY &BY;
      RUN;

      DATA SUMCMR(KEEP=CICSID CICAPUB MONTH YEAR DAY
       CMRCOUNT CMRELPTM);
      SET CICCMR;
      BY &BY;
      IF FIRST.CICAPU THEN CICAPUB=CICAPU;
      ELSE CICAPUB=' ';
      %CMRSUM(SUMBY=&BY,SUMBREAK=&BREAK,OUT=SUMCMR,
      DERV=YES);
      RUN;

      PROC PRINT DATA=SUMCMR N; BY CICSID;
      PAGEBY CICSID;
      ID CICAPUB;
      VAR MONTH YEAR DAY CMRCOUNT CMREPLTM;
      RUN;