proc export with url coming from a column

[Nasser_DRMCP]

Hello,

i need some hep.

what I have ==>this is my have_table with client number and the web site of the client for exmaple in the "url" column.

what I would like to get ==> an excel file with the "client" colum and by cliquing on a client number, the web site of the corresponding client would open.

result ==> I try this code but I do not succeed to make an url depending of the client (of the row).

many thanks in adance for your help

regards

Nasser

[Kurt_Bremser]

Why not create a HTML page? It's the natural language of the web.

Please post usable example data.

[Reeza]

Use PROC REPORT with ODS EXCEL instead.

See Page 7 in this paper for a code example https://support.sas.com/resources/papers/proceedings18/2479-2018.pdf

---

@Nasser_DRMCP wrote:

Hello,

i need some hep.

what I have ==>this is my have_table with client number and the web site of the client for exmaple in the "url" column.

what I would like to get ==> an excel file with the "client" colum and by cliquing on a client number, the web site of the corresponding client would open.

result ==> I try this code but I do not succeed to make an url depending of the client (of the row).

many thanks in adance for your help

regards

Nasser

---

[Ksharp · Accepted solution]

data have;
input id $ url :$40.;
cards;
1234 http://www.sas.com
4321 http://www.nasa.gov
;

ods excel file='c:\temp\want.xlsx';
proc report data=have nowd;
column url id ;
define url/display noprint;
define id/display ;
compute id;
call define(_col_,'url',url);
call define(_col_,'style','style={foreground=blue textdecoration=underline hreftarget="_blank"}');
endcomp;
run;
ods excel close;

[Nasser_DRMCP]

MANY THANKS !!!