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).
@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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.