6.18 Print The Data Elements Contained in a File

Reporting Examples › 6.18 Print The Data Elements Contained in a File

6.18 Print The Data Elements Contained in a File


PROBLEM:

    You may need to identify the data elements that are
    maintained in a CA MICS database file. A report naming
    the data element, long label description, format, and
    length is required.  This process may be used for any
    file.

DATABASE FILES TO BE ACCESSED:

    &PBATX..BATJOB01 (sample file)
        Yesterday's Batch User Job Activity File


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC CONTENTS may be used for this purpose.


SAS CODE EXAMPLE:

************************************************************;
* PRINT CONTENTS (DATE DICTIONARY) FOR A FILE              *;
************************************************************;

 PROC CONTENTS DATA=&PBATX..BATJOB01;
 TITLE "BATCH JOB FILE DATA ELEMENT LIST";


GENERATED OUTPUT REPORT:

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

BATCH JOB FILE DATA ELEMENT LIST 11:19 Thursday, September 9, yyyy CONTENTS PROCEDURE Data Set Name DETAIL.BATJOB01 Observations 467 Member Type DATA Variables 245 Engine BASE Indexes 0 Created Tuesday, August 31, 2010 01:38:19 AM Observation Length 912 Last Modified Tuesday, August 31, 2010 01:38:19 AM Deleted Observations 0 Protection Compressed CHAR Data Set Type Reuse Space NO Label Batch User Job Activity File Point to Observations YES Data Representation MVS_32 Sorted NO Encoding Default -----Engine/Host Dependent Information----- Data Set Page Size: 55296 Number of Data Set Pages: 9 Number of Data Set Repairs 0 Physical Name SYSPROG.NMICS.UNITR.DAYS Release Created 8.0202M0 Release Last Modified 8.0202M0 Created by MIXRDALY Last Modified by MIXRDALY Subextents 1 Total Blocks Used 80 -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos Format Informat Label 1 ACCTNO1 Char 10 0 DIVISION 2 ACCTNO2 Char 4 10 SUMMARY1 3 ACCTNO3 Char 8 14 SUMMARY2 4 ACCTNO4 Char 8 22 DETAIL 20 DAY Num 2 115 Day of Month 10 DAYNAME Char 3 55 Name Of Day Of Week 28 ENDTS Num 7 132 DATETIME19.2 DATETIME19.2 End Time Stamp 21 HOUR Num 2 117 Hour Of Day 14 JESJOBNO Char 5 70 JES Job Number 15 JOB Char 8 75 Job Identification 122 JOBA3480 Num 3 420 3480 Tape Data Set Allocations 72 JOBACOMM Num 2 318 Communication Data Set Allocations 170 JOBACTTM Num 5 591 TIME12.2 TIME12.2 Job Active Time 120 JOBADASD Num 3 414 DASD Data Set Allocations 73 JOBAGRAF Num 2 320 Graphics Data Set Allocations 171 JOBALCTM Num 5 596 TIME12.2 TIME12.2 Job Allocation Time (Partial list of data elements in this file)

Figure 6-16.  List of Data Elements in a CA MICS Database File