Hi, I have this sas dataset that contains the list of id`s. When the VA user clicks on any of the id`s then a dynamic URL corresponding to that id is created using stored process and a PROC report runs that creates an HTML page with the Text having hyperlink to the newly created URL. So basically what i am doing is 2 way step i.e. first creating dynamic URL and then creating seperate HTML page to open it. Is there any way in which it can be done in single step. That is user click on the id, dynamic URL is created and it pops up on the new screen? Please find attached screenshot as well. This is first screen with different id`s On clicking on any id a stored process runs and new HTML page opens in new tab Clicking on the hyperlink in the HTML page the actual reports corresponding to that id opens up in new tab. %global wantreg _odsdest _odsstyle ;
%macro setopt;
%let _odsdest=HTML;
%let _odsstyle=sasweb;
options nodate nonumber missing='0' orientation=landscape;
%mend setopt;
%macro Repot(wktid=);
%let url=/*dynamic url taking wktid as input*/
data test;
VA_REPORT= "Click here for VA Report";
url = "&url";
run;
proc report nowd;
col url VA_REPORT;
define url /noprint;
define VA_REPORT /display;
compute VA_REPORT;
call define(_col_, "url", url);
endcomp;
run;
%mend Repot;
*ProcessBody;
%setopt;
%stpbegin;
%Repot(wktid=&wktid);
%stpend; So basically i wan`t to avoid the HTML page that shows up with the actual URL for VA report corresponding to a particular id, instead directly opening the VA reports for that id.
... View more
