topic export table and graph in one sheet without removing existing sheet in SAS Programming

export table and graph in one sheet without removing existing sheet

akarki001 — Tue, 28 Sep 2021 20:11:38 GMT

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.

Re: export table and graph in one sheet without removing existing sheet

Reeza — Tue, 28 Sep 2021 20:17:40 GMT

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.

Re: export table and graph in one sheet without removing existing sheet

akarki001 — Tue, 28 Sep 2021 20:23:02 GMT

Thank you so much for your prompt response.