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;
How would you do it manually in Excel?
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?
Thank you so much. I will start doing excel meantime while waiting if any one response, mentioning "we can do that". Thanks Again.
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!
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.
Ready to level-up your skills? Choose your own adventure.