Combining Multiple Reports :: SAS(R) Model Manager 12.3: Tutorials

About Combining Multiple Reports

You can combine multiple reports from the Reports node to create a single, aggregated report. SAS Model Manager administrators and advanced users can create an aggregated report in two steps. First, you open the Define Aggregated Report window from an organizational folder, a project, or a version. Using reports that reside in the Reports folder, you select those that you want in your aggregated report to create an aggregated report definition. Next, you generate the aggregated report using the aggregated report definition. The format of the report can be PDF, HTML, or RTF. Aggregated reports are stored in the Documents folder within the node from which you selected the Define Aggregated Report pop-up menu option.

The reports that are selected are rerun to create the aggregated report. If the data set content that the selected reports use has changed since the last time you ran the report, the results might be different from the original reports. Ad hoc reports, LGD reports, and PD reports cannot be added to an aggregated report.

In this exercise, you combine multiple reports to create an aggregated report.

Create an Aggregated Report

To create an aggregated report, you must have two or more existing reports in the Reports node in the 2013 version. You first create an aggregated report definition, and then generate the report.

To create an aggregated report:

Right-click the 2013 version folder in the Tutorial2 project, and select Define Aggregated Report. The Define Aggregated Report window appears.

Note: The Define Aggregated Report pop-up menu item is available only to SAS Model Manager administrators and advanced users.
In the Name field, enter Tutorial–7 Aggregated Report for the name of the report.
(Optional) In the Description field, enter a description for the report.
Accept the default value of PDF in the Format list box. The other available output formats are HTML and RTF.
Expand the Reports node of the 2013 version in the Available items box. Select the Delta, Dynamic Lift, and Model Profile reports that you created in Tutorial 2 from the Available items box, and click the single right arrow. The reports appear in the Selected items box.

Note: To add all reports in the Reports node, click the double right arrow. To remove reports from the Selected items box, select the report and click the single left arrow to remove one report, or click the double right arrow to remove all reports.
(Optional) To order the reports, select a report, and use the up and down arrows.
When all of the reports are in the Selected items box and in the correct order, click OK. An object for the aggregated report definition and an Output node appear in the Documents folder within the 2013 version.
Expand the Documents folder.
Right-click the aggregated report definition name and select Generate Aggregated Report. A message appears to indicate whether the report was generated. If it was successful, click Close. If it was not successful, click Details to view the SAS log.
To view the report, expand the Output folder for the aggregated report, right-click the report, and select Open. If prompted, enter your user ID and password.

Edit an Aggregated Report (Optional)

To edit an aggregated report:

Expand the Documents folder in the 2013 version. Right-click the aggregated report and select Edit Aggregated Report. The Edit Aggregated Report window appears.
Modify the report definition:
1. In the Name field, modify the name.
2. In the Description field, enter a description for the report.
3. Click the Format list box and select an output format. The default is PDF.
4. To add reports to the report definition, select the report in the Available items box and click the single right arrow.
5. To remove reports from the report definition, select the report from the Selected items box and click the single left arrow.
6. To order the reports, select a report and use the up and down arrows.
7. Click OK.
Right-click the aggregated report name and select Generate Aggregated Report. A message appears to indicate whether the report was generated. If it was successful, click Close. If it was not successful, click Details to view the SAS log.
To view the modified report, expand the Output folder for the aggregated report, right-click the report, and select Open. If prompted, enter your user ID and password.

Note: To delete an aggregated report, right-click the report node in the Documents folder, and select Delete. Click Yes to confirm. The aggregated report definition and Output folder are deleted.