BookmarkSubscribeRSS Feed
ucvikas
Obsidian | Level 7

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;

3 REPLIES 3
DartRodrigo
Lapis Lazuli | Level 10

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

sanjay1
Obsidian | Level 7

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

Cynthia_sas
SAS Super FREQ
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

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1736 views
  • 0 likes
  • 4 in conversation