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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.