export table and graph in one sheet without removing existing sheet

[akarki001]

I am trying to export table and graph in one sheet using ODS excel but every-time i run, it wipeout all other existing sheet of the excel file. Is there anyway i can create new sheet like proc export does. if you suggest proc export to use, please let me know how to export graph right under table with nice format. Thank you.

[Reeza]

Unfortunately I'm not aware of a mechanism to do what you'd like by default.
You can write to an Excel file and then combine them using VBS (from SAS) which is a duct tape type solution that requires WIndows and is probably buggy.

ODS EXCEL will overwrite the file each time.
PROC EXPORT will not export graphics.

Getting your table is fine, the graph is not. Another option - generate the graph in Excel and have SAS supply the data/update the data as needed instead of creating it in SAS entirely. I do this for template reports all the time, fastest way to automate a report in my experience.

[akarki001]

Thank you so much for your prompt response.