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.