topic Clickable link in SAS VA 7.4 in SAS Visual Analytics

Clickable link in SAS VA 7.4

ADN — Fri, 05 Jul 2019 06:39:13 GMT

Hi,

It is possible to create a clickable hyperlink like the one below in Excel in SAS VA 7.4 in a list table (Instead of the user double clicking on a row to open the link).

Re: Clickable link in SAS VA 7.4

koyelghosh — Fri, 05 Jul 2019 19:51:42 GMT

@ADN Yes you can do it as long as you know what is the web address for each company. In the code below I have assumed address for Yahoo is https://www.Yahoo.com and so on. Below is the code and the output. Please change it to suit your requirement. The result should be Test.html in your folder.

DATA Have;
	INPUT CompanyName $30.;
	DATALINES;
	Yahoo
	Google
	Microsoft
	;
RUN;
DATA WANT;
	SET Have;
	Hyperink='<a  href="https://www.'||TRIM(CompanyName)||'.com">'||TRIM(CompanyName)||'</a>';
RUN;
ODS HTML BODY="Test.html";
PROC PRINT DATA=WANT;
RUN;
ODS HTML CLOSE;

Output

Re: Clickable link in SAS VA 7.4

ADN — Mon, 08 Jul 2019 08:20:57 GMT

Hi, Thanks for the solution. But I am actually looking for the same report in SAS VA and not as html.