Problem Note 38000: PROC TABULATE might generate malformed output in ODS destinations
PROC TABULATE might generate malformed output in all ODS destinations when both implicit and explicit statistic requests are specified in the TABLE statement.
Following is an example of this type of request.
proc tabulate data=sashelp.class;
class name sex;
var weight;
table name, sex (all weight*n)*f=5. ;
run;
In this case, ALL is assigned the default statistic of N. WEIGHT needs the explicit assignment "of N" because the default statistic is SUM.
To circumvent this problem, specify explicit statistic requests for all variables in the TABLE statement. For example:
table name, sex (all*n weight*n)*f=5. ;
Operating System and Release Information
| SAS System | Base SAS | z/OS | 9.21 | | 9.2 TS2M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.21 | | 9.2 TS2M0 | |
| Linux | 9.21 | | 9.2 TS2M0 | |
| HP-UX IPF | 9.21 | | 9.2 TS2M0 | |
| 64-bit Enabled Solaris | 9.21 | | 9.2 TS2M0 | |
| 64-bit Enabled HP-UX | 9.21 | | 9.2 TS2M0 | |
| Windows Vista | 9.21 | | 9.2 TS2M0 | |
| 64-bit Enabled AIX | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft® Windows® for x64 | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows XP 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | | 9.2 TS2M0 | |
| Linux for x64 | 9.21 | | 9.2 TS2M0 | |
| OpenVMS on HP Integrity | 9.21 | | 9.2 TS2M0 | |
| Solaris for x64 | 9.21 | | 9.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If default and explicit statistics requested are specified in a TABLE statement, PROC TABULATE might generate malformed output in ODS destinations.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2010-02-03 14:58:10 |
| Date Created: | 2009-12-02 12:05:49 |
