Clickable link in SAS VA 7.4

[ADN]

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).

[koyelghosh]

@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

[ADN]

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