topic Re: SAS Excel in ODS and Base Reporting

SAS Excel

SP_SAS — Tue, 19 Nov 2019 19:35:52 GMT

I have an excel file that has a few sheets. I want to add more sheets with ods excel to this existing file. is it possible doing similar things like, proc export + sheet='xxx', using ods statement.

Thanks,

Santosh

Re: SAS Excel

Reeza — Tue, 19 Nov 2019 19:38:31 GMT

Unfortunately not at this point in time 😞

Re: SAS Excel

SP_SAS — Tue, 19 Nov 2019 20:11:32 GMT

Thanks for reply.

Re: SAS Excel

Reeza — Tue, 19 Nov 2019 22:01:50 GMT

One workaround is to export it to a new workbook and use VBS to combine the workbooks. This is pretty easy, assuming you won't have any overlap in data.

Re: SAS Excel

art297 — Tue, 19 Nov 2019 22:36:50 GMT

If you're on a Windows based computer or server then take a look at the exportxl macro. I think it can do what you described, and more. You can download it from:

http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

Art, CEO, AnalystFinder.com