topic How can I add a target parameter to a PROC REPORT CALL DEFINE URL? in SAS Programming

How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

eshupp — Mon, 13 Mar 2023 11:20:02 GMT

I am trying to add a TARGET= to a URL generated in a PROC REPORT with CALL DEFINE so that the generated hyperlink works correctly in a framed environment. There does not appear to be documented way to do this that I have found. I have seen some references to modifying the style template but have not found any working examples. I tried fooling the system by including double quotes in my CALL DEFINE to extend the generated HREF which almost worked, but the actual html converted the buried double quotes to " which did not work when displaying the page.

compute link;
href=cat("&htmlbody..html#",trim(scan(path,-1,'\')),'" target="body');
call define(_col_,'URL',href);
endcomp;

Results in this HTML:

<tr>
<td class="l data" style=" border-width: 0px;"><a href="BODY.html#Report#16" target="body">Messages by Severity</a>
</td>
</tr>

which does not work properly. Any suggestions on how I can generate a proper target="body" with CALL DEFINE?

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

ballardw — Mon, 13 Mar 2023 11:27:17 GMT

I would suggest showing an example with no macro variables or function calls needed: i.e. a fixed URL before attempting to get a more complex example working.

From what you show for the resolved path I strongly suspect that your macro variables aren't what you want.

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

eshupp — Mon, 13 Mar 2023 11:50:05 GMT

Thanks for your comment.

I can tell that the macro variables are resolving properly from the generated HTML in the post. Also, when I edit the generated HTML output file and change all " strings to " (double quotes) the page works properly. My assumption is that this can be solved with a PROC TEMPLATE alteration of the style, or an additional CALL DEFINE to reset a style parameter. I just don't know which parameter to override.

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

Tom — Mon, 13 Mar 2023 14:13:01 GMT

@eshupp wrote:

Thanks for your comment.

I can tell that the macro variables are resolving properly from the generated HTML in the post. Also, when I edit the generated HTML output file and change all " strings to " (double quotes) the page works properly. My assumption is that this can be solved with a PROC TEMPLATE alteration of the style, or an additional CALL DEFINE to reset a style parameter. I just don't know which parameter to override.

Huh? Why did you output " if you wanted " ?

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

eshupp — Mon, 13 Mar 2023 14:38:53 GMT

I did not, ODS converted my " to " when it generated the HTML.

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

Tom — Mon, 13 Mar 2023 15:07:59 GMT

Because it is interpreting ' target="body"' as part the URL.

You are passing just the content of the HREF= option of the <a> tag. I do not see any method to modify the value of the target= option of the <a> tag.

Re: How can I add a target parameter to a PROC REPORT CALL DEFINE URL?

eshupp — Tue, 14 Mar 2023 13:16:24 GMT

Thanks to Chevell at SAS support the solution to this is adding HREFTARGET= to the PROC REPORT STYLE(COLUMN) parameter:

proc report data=reportdata
style(report)={just=c frame=box}
style(header)={frame=void}
style(column)={frame=void hreftarget="_blank"}
nowd;

href=catt("c:\output\body.html#",name);

call define(_col_,'URL',href);

endcomp;

run;

This added the target="_blank" to the generated anchor.