topic Re: proc export with url coming from a column in SAS Procedures

proc export with url coming from a column

Nasser_DRMCP — Wed, 03 Jul 2024 20:32:19 GMT

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

Re: proc export with url coming from a column

Kurt_Bremser — Wed, 03 Jul 2024 20:41:01 GMT

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

Please post usable example data.

Re: proc export with url coming from a column

Reeza — Wed, 03 Jul 2024 20:51:59 GMT

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

Re: proc export with url coming from a column

Ksharp — Thu, 04 Jul 2024 01:28:59 GMT

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;

Re: proc export with url coming from a column

Nasser_DRMCP — Thu, 04 Jul 2024 08:11:28 GMT

MANY THANKS !!!