topic Can we use Proc report to add sheet to existing excel file in ODS and Base Reporting

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

ashna — Mon, 19 Nov 2018 21:47:48 GMT

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

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

Reeza — Mon, 19 Nov 2018 21:54:52 GMT

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.