topic footnote image pdf report in SAS Programming

footnote image pdf report

sum_sand — Thu, 07 Nov 2024 20:47:52 GMT

proc report data=sashelp.class;

columns sex name ;

run;

ods path (prepend) work.template(update) sashelp.tmplmst;

proc template;

define style custom_style;

parent=styles.pearl;

style Document /

margin=0.3in;

style Table /

bordercolor=cxB0B7BB

borderwidth=0.5pt

borderstyle=solid;

class Header /

backgroundcolor=lightblue height=40; /* Optional: Change header background color */

class fonts /

'TitleFont' = ("<MTsans-serif>, Albany",14pt,bold)

'TitleFont2' = ("<MTsans-serif>, Albany",14pt,medium italic)

'docFont' = ("<MTsans-serif>, Albany",8pt);

end;

run;

%let tdate = %sysfunc(date(),mmddyy10.);

%let ttime= %sysfunc(time(),timeampm11.);

title;

options nodate nonumber orientation=landscape papersize=letter topmargin=.25in bottommargin=.25in leftmargin=.25in rightmargin=.25in;

/* Generate PDF report */

ods pdf file="&path.\dummy..pdf"

notoc

style=custom_style

startpage=no;

/* Create the report */

proc report data=sashelp.class;

columns sex name ;

compute name;

if sex='F' then call define(_col_,'style', 'style={background=pink}');

else if sex='M' then call define(_col_, 'style', 'style={background=cyan}');

endcomp;

footnote1 H=0.01 j=right "^S={preimage='C:\Users\CDPH.jpg'}";

run;

ods pdf close; /* Close the PDF destination */

Re: footnote image pdf report

ballardw — Thu, 07 Nov 2024 22:17:55 GMT

You may want to look at this post: https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-PDF-PRE-and-post-images-in-a-title-statement/td-p/345450

There is some difference in the way the solution uses braces and brackets. Plus there might be a preference for POSTIMAGE with J=Right.

I am not sure what you want the H= 0.01 on the Footnote for but that might also be part of the issue if the image isn't appearing.

I have to assume that you have set ODS ESCAPECHAR='^'; somewhere as I don't see one. And that the image file exists in the stated location. If your SAS system runs on a server C: likely doesn't mean your harddrive.

Re: footnote image pdf report

sum_sand — Thu, 07 Nov 2024 22:24:25 GMT

I was missing

ODS ESCAPECHAR='^';

in my code.

Thanks!