Usage Note 39443: SAS® Web Report Studio does not correctly render hyperlinks in tabular output created by stored processes
In tabular output created by stored processes, SAS Web Report Studio displays URLs as plain text or it displays unlinked values, depending on how the link is specified.
Note: URLs in graphical output do display as hyperlinks in SAS Web Report Studio.
Sample One
The following stored process adds a URL value to each observation in the SASHELP.CLASS data set.
*ProcessBody;
%stpbegin;
data testclass;
set sashelp.class;
format url $50.;
url='<a href="http://www.sas.com">SAS</a>';
run;
proc print data=testclass;
run;
%stpend;
|
If you run this stored process in SAS Web Report Studio 3.1 or 4.2, you see the following results.

Note: Support for using this method of specifying a URL was added in version 4.3.
Sample Two
If you use the STYLE option on a PROC PRINT statement in order to define the link, the style is simply ignored. In this case, "11" is displayed as an unlinked value wherever it appears in the CLASS table.
*ProcessBody;
%stpbegin
proc format;
value link 11="http://www.sas.com";
run;
proc print data=sashelp.class;
var age / style(data)={url=link.};
run;
%stpend;
|
Sample Three
Similar to the previous example, the following PROC REPORT code displays the linked values as plain text in the table.
*ProcessBody;
%stpbegin;
proc report data=sashelp.class;
col age name weight height sex;
compute name;
urlstring='http://www.google.com';
call define(_col_,'URL',urlstring);
endcomp;
run;
%stpend;
|
Workarounds
URLs display as hyperlinks if you run the stored process using the SAS® Stored Process Web Application. So, as a workaround, you can link to the SAS Stored Process Web Application from SAS Web Report Studio.
Operating System and Release Information
SAS System | SAS Web Report Studio | Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
Windows Vista | 4.2 | | 9.2 TS2M0 | |
Windows Vista for x64 | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled Solaris | 4.2 | | 9.2 TS2M0 | |
HP-UX IPF | 4.2 | | 9.2 TS2M0 | |
64-bit Enabled AIX | 4.2 | | 9.2 TS2M0 | |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
z/OS | 4.2 | | 9.2 TS2M0 | |
Linux for x64 | 4.2 | | 9.2 TS2M0 | |
Solaris for x64 | 4.2 | | 9.2 TS2M0 | |
*
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: | Usage Note |
Priority: | |
Topic: | Query and Reporting ==> Interactive Querying
|
Date Modified: | 2010-04-26 17:00:14 |
Date Created: | 2010-04-26 16:47:47 |