Using MICS Formats in Reporting

Document ID : KB000027664
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

CA MICS builds many formats that contain descriptions or other useful information that can be used to produce reports. 

Resolution:

 

There are several ways to use formats to look up information on CA MICS defined elements.

LENGTH ZONE_LBL $40.;
ZONE_LBL = PUT(ZONE,$ZONENM.);

In this example the variable ZONE is used to obtain a description from the format $ZONENM. The description is assigned to the variable ZONE_LBL.

Some formats contain multiple pieces of information and SAS string functions are needed to extract the piece you want. The following example demonstrates one method. The SCAN function is used to parse the string returned from $SYSID.

LENGTH CPU_MDL $20.;
CPU_MDL = SCAN(PUT(ORGSYSID,$SYSID.),2,' ') ;

The above example extracts the CPU Model that is associated with the ORGSYSID. CPU Model is the second word of the string.

If your job uses a MICS proc, the format libraries will be allocated for you. Otherwise, you will have to allocate sharedprefix.MCOLIB and prefix.MUOLIB data sets and include them on your FORMATSRCH option in your SAS code.

Some useful formats are listed below.

           FORMAT    COMPONENT  DESCRIPTION
           --------  ---------  --------------------------------------
           $ACTCMPF  ACT        Computation Code Description
           $ACTCPUF  ACT        Computation Code Units
           $ACTCICF  ACT        Invoice Category for Computation Codes
           $ACTIVCF  ACT        Invoice Category Description
           $PRFGP    BAS        Performance Group Description by SYSID
           $SYSID    BAS        Information from prefix.PARMS(SYSID)
                                including SYSID and CPU Model Name
           $ZONENM   BAS        Zone Description

Taking advantage of the SAS formats provided by MICS can save time otherwise spent maintaining code.