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
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;
Why not create a HTML page? It's the natural language of the web.
Please post usable example data.
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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.