Problem Note 45525: Data might be missing from non-Listing ODS output when using an ACROSS variable in PROC REPORT with the NOCOMPLETECOLS option
Columns of data might not appear in non-Listing ODS output when using an ACROSS variable in PROC REPORT with the NOCOMPLETECOLS option.
To circumvent the problem, remove the NOCOMPLETECOLS option. In situations where the removal of this option produces unwanted empty columns, add the NOZERO option to the DEFINE statement for the ACROSS variable.
The sample code on the Full Code tab generates an RTF file that illustrates the problem, and an RTF file that demonstrates the workarounds. An example of both RTF files can be opened from the Results tab.
Operating System and Release Information
SAS System | Base SAS | z/OS | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 9.2 TS1M0 | 9.3 TS1M2 |
Windows Vista | 9.2 TS1M0 | 9.3 TS1M2 |
Windows Vista for x64 | 9.2 TS1M0 | 9.3 TS1M2 |
64-bit Enabled AIX | 9.2 TS1M0 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 9.2 TS1M0 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.2 TS1M0 | 9.3 TS1M2 |
HP-UX IPF | 9.2 TS1M0 | 9.3 TS1M2 |
Linux | 9.2 TS1M0 | 9.3 TS1M2 |
Linux for x64 | 9.2 TS1M0 | 9.3 TS1M2 |
OpenVMS on HP Integrity | 9.2 TS1M0 | 9.3 TS1M2 |
Solaris for x64 | 9.2 TS1M0 | 9.3 TS1M2 |
*
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.
The sample code below generates RTF files that illustrate the problem, and demonstrate the workarounds. Both RTF files can be opened from the
Results tab.
/* The Wagon column appears in the Listing (Output) window but not in the RTF file. */
ods rtf file='test1.rtf';
proc report data=sashelp.cars(obs=30) nowd nocompletecols;
column make type, invoice dummy;
define make / group;
define type / across;
define invoice / display;
define dummy / noprint;
run;
ods rtf close;
/* With the circumventions, the Wagon column now appears in */
/* both the Listing (Output) window and in the RTF file. */
ods rtf file='test2.rtf';
proc report data=sashelp.cars(obs=30) nowd ;
column make type, invoice dummy;
define make / group;
define type / across nozero;
define invoice / display;
define dummy / noprint;
run;
ods rtf close;
Columns of data might be missing from non-Listing ODS output when using an ACROSS variable in PROC REPORT with the NOCOMPLETECOLS option.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-09-16 13:12:57 |
Date Created: | 2012-01-27 16:32:11 |