topic Hyperlink to the id in excel in SAS Programming

Hyperlink to the id in excel

radha009 — Sat, 08 Dec 2018 04:16:09 GMT

I have excel report with column id (1 , 2, 3...). I want to add a hyperlink to the id.
In proc report
Compute id;
Urlstring = ( I didn’t get this how to use the url and where?
Call define ;
Call define;
End compute;

I have url like, http://www. Google .com/ test/?number=id

Thank you

Re: Hyperlink to the id in excel

SASKiwi — Sat, 08 Dec 2018 05:25:14 GMT

A common topic - try this: https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Clickable-external-hyperlink/m-p/494468#M21677

Re: Hyperlink to the id in excel

radha009 — Sat, 08 Dec 2018 16:44:20 GMT

my code :

ods excel file='c:\test\hidelink.xlsx';
proc report data=work.project
column request release_id href;
define request / display;
define release_id /display;
define href / computed;

compute href / character length=100;
href = catt('https://staff.contact.com/nav_to.do?uri=request.do?sysparm_query=number=',request);
call define('request','url',href);
endcomp;
run;
ods _all_ close;

the hyperlnk to the request is not displaying. when i click the request number it should go to the above link based on the reques number.

Re: Hyperlink to the id in excel

SASKiwi — Sat, 08 Dec 2018 21:05:33 GMT

As I understand it, to get a working hyperlink you need to wrap your URL in an Excel formula using the HYPERLINK function like so (example from above link):

      compute d1 ;
            IF d1='=HYPERLINK("[https://goo.gl/G4a0A9]", "https://www.cms.gov/Medicare/Quality-Initiatives-Patient-Assessment-Instruments/Value-Based-Programs...")' THEN DO;
               CALL define(_col_,'style','style=[textdecoration=underline foreground=blue]');
            END;

I suggest you get your formula working in Excel first manually then paste it into SAS.