The ODS destination for Excel does not support generating hyperlinks with the URL= attribute within an inline format. The text is displayed but the link is not generated when you specify the URL= attribute within an inline format.

If a hyperlink is desired in a title or footnote, the LINK= option in a TITLE or FOOTNOTE statement can be used. However, if the hyperlink is desired for a simple string such as a label or text using the ODS TEXT= statement, the Excel =HYPERLINK function can be used.  Click the Full Code to see sample code that illustrates this.

Operating System and Release Information

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

* 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 illustrates adding a URL to a label or text string with the ODS destination for Excel.

---

ods escapechar="^"; 

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

proc print data=sashelp.stocks label; 
   var stock; 
   label stock="=HYPERLINK(""http://www.ibm.com"",""Stock"")"; 
run; 

ods excel close; 

Type:	Usage Note
Priority:

Date Modified:	2017-08-04 15:23:54
Date Created:	2017-05-26 16:19:51