Problem Note 59952: The NEWLINE function is ignored when a string contains additional inline functions when you use the ODS destination for Excel
 |  |  |  |  |
Forcing text to a new line does not occur in the ODS destination for Excel when the NEWLINE ODS inline function is specified in a string that also includes other inline functions. The text does not wrap correctly when other inline functions are included in the same string as the NEWLINE function.
To circumvent the problem, use the encoded value for the new line instead of the NEWLINE function. Click the Full Code tab to see a sample program that illustrates the problem and the circumvention.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 |
| z/OS 64-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft® Windows® for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 R2 | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2008 for x64 | 9.4_M3 | 9.4 TS1M3 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Linux for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.4_M3 | 9.4_M5 | 9.4 TS1M3 | 9.4 TS1M5 | ||
The sample code below uses the encoded value of for the line break when the text also includes an additional inline function.
data test;
do i=1 to 10;
test=i;
output;
end;
run;
ods excel file="c:\temp\test2.xlsx" options(absolute_column_width="60" flow="headers");
ods escapechar='~';
proc report data=test style(header)={protectspecialchars=off};
column i test;
define i / display "The line break should occur here and it does with this ~{style [color=red] test}";
define test / display "The line break should occur here ~{newline 1} but does not in this ~{style [color=red] test}";
run;
ods excel close;
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-08-18 14:44:35 |
| Date Created: | 2017-02-10 15:43:40 |