Spaces within strings that precede and follow the characters that are generated with the inline SUPER and SUB functions are removed when you use the ODS destination for Excel.

You can use the NOBREAKSPACE=ON style attribute to retain the blank spaces within the string.  Click the Full Code tab to see an example.

 

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	Microsoft Windows 8 Enterprise x64	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Enterprise 32-bit	9.4 TS1M3	9.4 TS1M5
		Microsoft® Windows® for x64	9.4 TS1M3	9.4 TS1M5
		z/OS 64-bit	9.4 TS1M3	9.4 TS1M5
		z/OS	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Pro 32-bit	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8 Pro x64	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise 32-bit	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Enterprise x64	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Pro 32-bit	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 8.1 Pro x64	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows 10	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2008	9.4 TS1M3
		Microsoft Windows Server 2008 R2	9.4 TS1M3
		Microsoft Windows Server 2008 for x64	9.4 TS1M3
		Microsoft Windows Server 2012 Datacenter	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Datacenter	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 R2 Std	9.4 TS1M3	9.4 TS1M5
		Microsoft Windows Server 2012 Std	9.4 TS1M3	9.4 TS1M5
		Windows 7 Enterprise 32 bit	9.4 TS1M3	9.4 TS1M5
		Windows 7 Enterprise x64	9.4 TS1M3	9.4 TS1M5
		Windows 7 Home Premium 32 bit	9.4 TS1M3	9.4 TS1M5
		Windows 7 Home Premium x64	9.4 TS1M3	9.4 TS1M5
		Windows 7 Professional 32 bit	9.4 TS1M3	9.4 TS1M5
		Windows 7 Professional x64	9.4 TS1M3	9.4 TS1M5
		Windows 7 Ultimate 32 bit	9.4 TS1M3	9.4 TS1M5
		Windows 7 Ultimate x64	9.4 TS1M3	9.4 TS1M5
		64-bit Enabled AIX	9.4 TS1M3	9.4 TS1M5
		64-bit Enabled Solaris	9.4 TS1M3	9.4 TS1M5
		HP-UX IPF	9.4 TS1M3	9.4 TS1M5
		Linux for x64	9.4 TS1M3	9.4 TS1M5
		Solaris for x64	9.4 TS1M3	9.4 TS1M5

* 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 below retains the spaces within the label after the character is added with the SUPER function.

---

ods escapechar="^";
ods excel file="c:\temp\test.xlsx";

proc print data=sashelp.class label;
   var name / style={width=1in nobreakspace=on};
   label name="Add ^{super 1} a space"; 
run;

ods excel close;

Type:	Problem Note
Priority:	medium

Date Modified:	2016-09-20 16:15:33
Date Created:	2016-09-19 09:43:01