Can we use Proc report to add sheet to existing excel file

[ashna]

Hello everyone,

I'm wondering if there is a way to use Proc Report to add an tab to existing excel file. 

I have an excel file with report, need to write summary of these reports in New_tab in same excel file.

Any suggestion?

Thanks 

Ashna

[Reeza]

Make the excel file a template document linked to unformatted data. Then you can export to the unformatted data. Unfortunately ODS Excel does not support adding worksheets to a workbook, so PROC EXPORT is pretty much the main option.