Section 1, Task 3: Create a Test PDB and Process, Reduce, and Report on Data
Action 2: Add or create table and variable definitions
Step b: Process the staged data into PDB

  1. Submit the following program from the PROGRAM EDITOR window.
    %CPSTART(MODE=BATCH,                                    #1
             ROOT='your/itsv',
             SITELIB='your/itsv/sitelib',
             PDB='your/fax/pdb.',
             ACCESS=write,
             _RC=CPSTRC
             );
    %PUT CPSTART return code is &CPSTRC;                    #2
    %INCLUDE FAXES.SAS;                                     #3
    %FAXES;                                                 #4
    RUN;                                                    #5
    
    %CPPROCES(COLLECTR=GENERIC,TOOLNM=SASDS,GENLIB=WORK,    #6
              _RC=CPPRRC);
    %PUT CPPROCES return code is &CPPRRC;                   #7
    

    Notes:

    1. Invokes the IT Service Vision %CPSTART macro and references your active PDB for FAX data. The PDB= parameter is set to the name (high-level-qualifiers) that you used for the new PDB.

    2. This prints the value of the %CPSTART macro's return code, stored in CPSTRC.

    3. The code for staging the fax data is invoked next. In this example, the code is available in the %FAXES macro.

    4. The %CPPROCES macro executes to process the generic collector’s staged data into the detail level of the PDB. In this example, the macro processes data to the UFAXES table from the FAXES data set (named as the UFAXES table’s external name) in the WORK library. (By default, the COLLECTR= parameter is set to GENERIC in the %CPPROCES macro.) The COLLECTOR=GENERIC and TOOLNM= SASDS parameters are not required because these are the default values for the %CPPROCES macro. For more about the %CPPROCES macro and its parameters, see the Macro Reference documentation for IT Service Vision.

    5. This prints the value of the %CPPROCES marco's return code, stored in CPPRRC.

  2. Save the program.

    From the PROGRAM EDITOR window, follow this path:

    File -> Save as...

    Save the output somewhere in your filesystem for later retrieval.