For generic collectors, you must explicitly run the staging code before processing the staged data into the PDB.

For ease of management of the code, you may want to create a SAS macro to execute the staging code. This can be accomplished through the following steps:

• Determine what to call the macro. Assume the decision is macro_name.
• Create a file called macro_name.sas.
• The first line in the file should read as follows:

  %MACRO macro_name ;

• Have the staging code as the body of the macro.
• Type the following as the last line:

  %MEND;

You can now use the macro to run the staging code by simply invoking the macro:

%macro_name ;

For the fax example, here is sample code to define a macro called %FAXES:

In a file called FAXES.SAS, have the following code:

%MACRO FAXES ;

[the staging code goes here; see Fax Appendix 2: Sample Code for Staging the Data]

%MEND FAXES ;

Here is how to invoke the %FAXES macro:

%FAXES ;

Interactively, start IT Service Vision and then submit the following code to the SAS PROGRAM EDITOR window. In batch/background, run the SAS procedure and in it start IT Service Vision and then run the following code.

%INCLUDE macro_name.SAS;
%macro_name;                                            #1
RUN;

%CPPROCES(COLLECTR=GENERIC,TOOLNM=SASDS,GENLIB=WORK,    #2
          _RC=CPPRRC);
%PUT CPPROCES return code is &CPPRRC;                   #3

Notes:

1. Runs the macro that stages that data.
   
   
2. The %CPPROCES macro executes to process the generic collector's staged data into the detail level of the active PDB.
   
   
3. Prints the value of the %CPPROCES return code, stored in CPPRRC.

For example,

In the PROGRAM EDITOR Window, type the following

%CPREDUCE ();

Check the SAS LOG window for any messages, warnings, or errors, in the reduce step.