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

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