topic Re: How to use a macro variable in ods html in SAS Programming

How to use a macro variable in ods html

Azuki707 — Tue, 20 Apr 2021 06:49:36 GMT

ods html body=outbox style=normal rs=none;

ods html text="<div align='left'> Dear Team,<BR>
<BR> Kindly refer to the attached report for 500 Apr 2021.
<br>
<br> Thank You!<br><br>

</div>";

I want to make "Apr 2021" as a variable which I created earlier. &Month &Year. How can I call it in the html?
ods html close;

Re: How to use a macro variable in ods html

yabwon — Tue, 20 Apr 2021 07:20:52 GMT

/* Try this */
%let Month = Apr;
%let Year = 2021;
filename outbox "%sysfunc(pathname(work))/test.html";

ods html body=outbox style=normal rs=none;

ods html text="<div align='left'> Dear Team,<BR>
<BR> Kindly refer to the attached report for 500 &Month. &Year..
<br>
<br> Thank You!<br><br>



</div>";
proc print data=sashelp.class(obs=3);
run;

ods html close;

Bart

Re: How to use a macro variable in ods html

Azuki707 — Tue, 20 Apr 2021 07:33:45 GMT

It works! Thanks!