Problem Note 4574: Spanned headers in PROC REPORT may cause incorrect cellwidth when using
ODS
When using a spanned header in PROC REPORT and ODS to create RTF or
PPRINTER files (PCL, PDF or PS), the cellwidth may be incorrect. The
problem is that the spanned header forces all of the columns to become a
proportion of the spanning header. This incorrect behavior will exist
even if the CELLWIDTH= style attribute is applied to one or more of the
columns.
The example below illustrates the problem. In the output, column A is
about 1.1cm wide even though the largest value is only about .08cm wide.
Regardless of the CELLWIDTH= attribute applied to column A, the
cellwidth maintains a width of at least 1.1cm.
Example:
ODS PRINTER PS FILE='test.ps';
data test;
a='A';
b='BBBBBBBBBBBBBBBBBBBBBBBBBB';
Do c=1 To 10;
output;
end;
run;
proc report data=test nowd;
column ("spanning" a b) c;
define a / STYLE={CELLWIDTH=0.8cm};
run;
ODS PRINTER CLOSE;
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#004574
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 (with
Asian Language Support) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#004574
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows XP Professional | 8.2 TS2M0 | 9 TS M0 |
| Microsoft Windows NT Workstation | 8.1 TS1M0 | 9 TS M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.1 TS1M0 | |
| Microsoft Windows 2000 Server | 8.1 TS1M0 | 9 TS M0 |
| Microsoft Windows 2000 Datacenter Server | 8.1 TS1M0 | 9 TS M0 |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | 9 TS M0 |
| Microsoft Windows 2000 Advanced Server | 8.1 TS1M0 | 9 TS M0 |
| OpenVMS VAX | 8.1 TS1M0 | |
| IRIX | 8.1 TS1M0 | |
| 64-bit Enabled Solaris | 8.1 TS1M0 | |
| Solaris | 8.1 TS1M0 | |
| OS/2 | 8.1 TS1M0 | |
| z/OS | 8.1 TS1M0 | 9 TS M0 |
| ABI+ for Intel Architecture | 8.1 TS1M0 | |
| Linux | 8.2 TS2M0 | 9 TS M0 |
| Tru64 UNIX | 8.1 TS1M0 | 9 TS M0 |
| 64-bit Enabled AIX | 8.1 TS1M0 | |
| HP-UX | 8.1 TS1M0 | |
| 64-bit Enabled HP-UX | 8.1 TS1M0 | |
| CMS | 8.1 TS1M0 | |
| OpenVMS Alpha | 8.1 TS1M0 | 9 TS M0 |
| AIX | 8.1 TS1M0 | |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> ODS (Output Delivery System)
|
| Date Modified: | 2004-07-14 14:46:55 |
| Date Created: | 2001-03-22 14:55:39 |