BookmarkSubscribeRSS Feed
SASuserlot
Barite | Level 11

I had a request, that I never done before. I need to create a Excel sheet from dataset. Along with this I need to  insert an image as notes/comment  for each subject in excel sheet related to specific names. So when I rollover each name I can see the image of that subject.  I stuck at after just converting Excel. Can you please suggest any inputs and suggestions. Thanks in advance. I am attaching the sample image of excel how I am expecting the output. so I am expecting for each name.

proc export 
  data=sashelp.class 
  dbms=xlsx 
  outfile="C:\Users\xx\Desktop\New folder\class.xlsx" 
  replace;
run;

Screenshot (2).png

 

4 REPLIES 4
Reeza
Super User

How would you do it manually in Excel?

SASuserlot
Barite | Level 11

Hi Reeza,

If you asking question how did I do it , in excel. This is the useful link 

https://excel-bytes.com/insert-picture-in-note-office-365-excel/

the request I made is it possible to do it in excel? or its better to generate the excel then do images manually?

Reeza
Super User
I asked because if it's via a formula there are ways to mimic that functionality in SAS.

I'm not aware of a method to set the fill effects background of a comment via SAS though.
SASuserlot
Barite | Level 11

Thank you so much. I will start doing excel meantime while waiting if any one response, mentioning "we can do that". Thanks Again.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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