Reporting Examples › 6.6 Analysis of Job Abends Incurred by Department

6.6 Analysis of Job Abends Incurred by Department

PROBLEM:

    In an effort to gain a better understanding of the types
    of problems that users and programmers are encountering
    with their batch jobs, a cross-tabulation report to
    quantify abend occurrence by type and within department
    is required.


DATABASE FILES TO BE ACCESSED:

    &PBATX..BATJOB01
        Yesterday's Batch User Job Activity File


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC FREQ enables a cross-tabulation to quantify abends
    by abend code and department ID.

SAS CODE EXAMPLE:

************************************************************;
* ANALYSIS OF JOB ABENDS FOR DEPARTMENTS                   *;
*          AXB AXG ASG OPS                                 *;
************************************************************;
 DATA;
 SET &PBATX..BATJOB01;
 IF JOBSYSAB=1;
 IF JOB IN:('AXB' 'AXG' 'ASG' 'OPS');
 JOB=SUBSTR(JOB,1,3);
 PROC FREQ; TABLES TERMCODE*JOB /
  NOCOL NOPERCENT NOROW;
 TITLE "ANALYSIS OF JOB ABENDS FOR USERS AXB AXG ASG OPS
 ";


GENERATED OUTPUT REPORT:

    Figure 6-3 illustrates the output reports produced by the
    SAS code illustrated above.

 
                                         ANALYSIS OF JOB ABENDS FOR USERS AXB AXG ASG OPS       16:18 THURSDAY, APRIL 20, yyyy
 
                                                      TABLE OF TERMCODE BY JOB
 
                                      TERMCODE(TERMINATION CODE)   JOB(JOB IDENTIFICATION)
 
 
                                      FREQUENCY|AXB     |AXG     |OPS     |ASG     |  TOTAL
                                      ---------+--------+--------+--------+--------+
                                           001 |      0 |      0 |      0 |      8 |      8
                                      ---------+--------+--------+--------+--------+
                                           013 |      2 |      0 |      0 |      0 |      2
                                      ---------+--------+--------+--------+--------+
                                           222 |      3 |      0 |      5 |      7 |     15
                                      ---------+--------+--------+--------+--------+
                                           522 |      1 |      1 |      7 |      4 |     13
                                      ---------+--------+--------+--------+--------+
                                           613 |      0 |      0 |      2 |      0 |      2
                                      ---------+--------+--------+--------+--------+
                                           622 |      0 |      1 |      4 |      2 |      7
                                      ---------+--------+--------+--------+--------+
                                      TOTAL           6        2       18       21       47
 
 

Figure 6-3. Cross-tabulation of Abends by Department