User`s guide

i. Create a file containing these statements:
* Printing a table definition in the SAS log;
%CPSTART( pdb=pdbname, mode=batch );
%CPCAT; cards4;
print table name=_ALL_;
/* The four semicolons must be in column one */
;;;;
%CPCAT( cat=work.temp.prtab.source );
%CPDDUTL( entrynam=work.temp.prtab.source, list=yes );
where pdbname is the name of your PDB. For more information on the PRINT TABLE control statement,
see the %CPDDUTL control statements in the Macro Reference documentation for IT Service Vision.
ii. Start SAS from the UNIX shell command prompt as follows:
sas filename -terminal -batch -dmsbatch -fsdevice
ascii.vt100
where filename is the name of the above file. Or, type the contents of the above file (if the IT Service
Vision server software is already running, omit the invocation of the %CPSTART macro) starting at the
first line in the body of your PROGRAM EDITOR window. Submit the above file for SAS to run.
The control statements display in the SAS log, followed by the output that they generate. To print the log,
see the instructions earlier in this prerequisite.
2. In the tables that you chose, you have determined which variables you want to use and you have reviewed the
default settings of the variables and the variables’ statistics.
On the hardcopy versions of the table definitions, mark in what you want to change, if anything, based on the actions
below. Later in this task you will implement these changes.
a. Review the BY variables list and CLASS variables lists for each of the tables that you selected.
The kept status of the variables in the BY variables list and CLASS variables list must be Yes.
The BY variables list applies to the detail level of the table. The purpose of the BY variables list is to sort the
observations in the detail level to match the sort order of the observations incoming during the processing step
and to detect observations that have duplicate values in the BY variables.
Under normal circumstances, you do not need to modify the BY variables list, but if you need to modify the list
you can. For example, if you add a variable in an exit, you may (or may not) want to add that variable to the BY
variables list.
The variables on the list must have a Kept status of Yes. DATETIME must be on the BY variables list. To the
right of DATETIME on the list, use only HOUR and/or SHIFT. To the left of DATETIME on the list, you can
use any variables.
CLASS variables lists, displayed in the bottom of the Edit Table window, are used to group data so that the same
values of all CLASS variables are together for the reduction step. The lists also assure that data are in the proper
sort order for reporting on the reduction levels. By default, the CLASS variable lists contain the same variables in
the same order as the BY variables list, but the CLASS variables list in your tables may be different. The CLASS
variables list for a reduction level can be different from the BY variables list and can be different from all other
CLASS variables lists, but it must contain the DATETIME variable.
If you want character string metrics like MACHINE and JOB to be carried into reduction levels for reporting, add
them to the CLASS variables lists immediately to the left of the DATETIME variable. (This presumes that you
changed the Kept status of the string variable to Yes earlier. However, even if their Kept status is Yes, string
variables that are not on the CLASS variables list are dropped from the non-detail levels because there are no
statistics for string variables.)