Problem Note 36113: Tabulated subtotals do not appear after each group in SAS® Report output in the SAS® Add-In for Microsoft Office
 |  |  |  |  |
In SAS Add-In for Microsoft Office, when you tabulate totals using the SAS Report format, grouped totals appear at the bottom of the tabulated output rather than after each group. If you use an output format such as HTML the totals correctly appear after each group.
As a workaround, you can insert code into the insert custom code section of the task. In order to do this, you must generate the summary table by using Summary Tables task instead of the wizard. In the task, select Preview Code, click the Insert Code button, and then double-click on the first available line in order to insert the following code.
ODS tagsets.sasreport12 options(rolap="on");
|
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
| Windows Vista | 4.2 | 4.22 | 9.2 TS2M0 | 9.2 TS2M0 | ||
A fix for this issue for SAS Add-in for Microsoft Office 4.2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A21.html#36113A fix for this issue for SAS Add-in for Microsoft Office 4.21 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A33.html#36113| Type: | Problem Note |
| Priority: | high |
| Topic: | Third Party ==> Products ==> Microsoft Office Query and Reporting |
| Date Modified: | 2009-09-09 12:49:30 |
| Date Created: | 2009-06-01 16:16:34 |