Hyperlink to the id in excel

[radha009]

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

[SASKiwi]

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

[radha009]

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.

[SASKiwi]

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.