BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
songsujing
Fluorite | Level 6

Hello need help for  the following issue, Thanks a lot

I used the following code to insert the 2 background pictures to excel, but they arrange in vertically I would like to in Horizontally, trying to add options using horigin and Vorigin but it didn't work

 

ods excel file = "Output/SOMMAIRE_2023-06.xlsx"  
        options( embedded_titles="on"  Sheet_name="SOMMAIRE" autofilter='all' frozen_headers ='yes'  sheet_interval = "NONE" );
  
goptions iback='Input/bell.jpg'  imagestyle=fit vsize=1in hsize=1.5in;
proc gslide; run; quit;
goptions iback ='Input/vdm.png'  imagestyle=fit vsize=1in hsize=1.5in  ;
proc gslide; run; quit;
 
title j=l  " SOMMAIRE RAPPORT" ;
 
proc report data = _temp missing
style(header) = { background=lightred}
style(summary) = { fontweight=bold}
  ;
the images generated is like:
songsujing_0-1690062123445.png

I would like to switch to the following, how should I do it:  Thanks a lot

songsujing_1-1690062198112.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
HB
Barite | Level 11 HB
Barite | Level 11

If all else fails, combine the images into one image (bell-vdm.png) and insert that.

View solution in original post

2 REPLIES 2
HB
Barite | Level 11 HB
Barite | Level 11

If all else fails, combine the images into one image (bell-vdm.png) and insert that.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 2 replies
  • 4770 views
  • 0 likes
  • 2 in conversation