topic Re: How to insert external images in SAS reporting PDF Excel in Graphics Programming

How to insert external images in SAS reporting PDF Excel

ucvikas — Tue, 08 Dec 2015 15:13:20 GMT

For example take sashelp.cars dataset. I want to print image of each model in my final output along with other columns like horsepower etc . I have .jpg images saved externally with model name and want to print right image in front of right model .

This means that for each row I might have different image .

i would like output in Excel if not possible then PDF.

Can anyone help me how to do this in SAS9.2 ? Below is sample code but I do ot know how to add a column with image as content of it.

ods pdf file="&output_location./report.html";

proc report data=sashelp.cars(keep=model type horsepower origin);
where origin='Europe' and type='Sedan';
column model horsepower;
run;

ods pdf close;

Re: How to insert external images in SAS reporting PDF Excel

DartRodrigo — Tue, 08 Dec 2015 16:02:38 GMT

Hi mate,

I've never try this but checkout this Embed images in a PROC REPORT table

There is a code and you can try yourself.

Hope this helps

Re: How to insert external images in SAS reporting PDF Excel

sanjay1 — Wed, 14 Sep 2016 10:24:46 GMT

"Ods pdf text" statement may help you to add external images

Re: How to insert external images in SAS reporting PDF Excel

Cynthia_sas — Sun, 18 Sep 2016 15:45:58 GMT

ODS PDF TEXT will allow you to insert TEXT and preimage or postimages at procedure breaks. If you want to have a picture of a model in a report cell for that model, then using the PROC REPORT suggestion will be your best bet.

cynthia