SAS Excel

[SP_SAS]

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

[Reeza]

Unfortunately not at this point in time 😞

[SP_SAS]

Thanks for reply.

[Reeza]

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.

[art297]

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