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.
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.
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:
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9. Sign up by Dec. 31 to get the 2024 rate of just $495. Register now!
How to Concatenate Values
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
