5. FILES › 5.2 VTOC/Catalog Activity Information Area Files › 5.2.1 Data Set Allocation File (VCADAA) › 5.2.1.4 VCADAA Retrieval Examples

5.2.1.4 VCADAA 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.  List all data sets created in the last 30 days with a
    high level data set name qualifier of 'CMPR'.

 DATA;
 SET &PVCAX..VCADAA01;
 IF DSNAME=:'CMPR';
 IF CREATEDT > DATEPART(ENDTS) - 30;
 PROC PRINT; VAR DSNAME VOLSER CREATEDT DAASPACA DAASPACU;

2. Show all non-VSAM data sets having greater than 13 extents
   and the total megabytes they occupy. Report the largest
   data sets first.

 DATA ONE;
      SET &PVCAX..VCADAA01;
      IF DAADSTYP EQ 'OS' AND DAAEXTNO GT 13;
 PROC SORT;
      BY DESCENDING DAAALLSP;
 PROC PRINT NOOBS UNIFORM N;
      VAR DSNAME DAAEXTNO DEVTYPE VOLSER CREATEDT
          DAAREFDT DAAALLSP;
      SUM DAAALLSP;
      TITLE
  'LISTING OF NON-VSAM DATA SETS WITH MORE THAN 13 EXTENTS';
 RUN;

3. Show all values of BLKSIZE in the form of a graph. Also
   show the amount of space allocated by data sets using each
   BLKSIZE.

 PROC CHART DATA=&PVCAX..VCADAA01;
      HBAR BLKSIZE / TYPE=SUM SUMVAR=DAAALLSP DISCRETE;
      TITLE1
        'SUMMARY OF MEGABYTES ALLOCATED / BY BLOCK SIZE';
 RUN;

4. Show the frequency distribution of management class name
   (MGMTCLAS) using the CA MICS element STORMGTC. Show how
   management class is distributed within storage group. The
   element name for storage group is STORNAME.

 PROC FREQ DATA=&PVCAX..VCADAA01;
 TABLES STORNAME*STORMGTC;
 RUN;