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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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