Data visualization with SAS programming

How to insert external images in SAS reporting PDF Excel

Reply
Contributor
Posts: 56

How to insert external images in SAS reporting PDF Excel

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;

Regular Contributor
Posts: 212

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

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 Smiley Happy

Frequent Contributor
Posts: 99

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

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

SAS Super FREQ
Posts: 8,646

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

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
Post a Question
Discussion Stats
  • 3 replies
  • 316 views
  • 0 likes
  • 4 in conversation