- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Why not create a HTML page? It's the natural language of the web.
Please post usable example data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content