I like to use tagsets.excelxp to export output to excel.
The problem is I can never export more than one table to the same file, even if I specify different sheets each time.
The file still gets overwritten.
Is there a solution?
You're doing it wrong
See AND RUN the sample code under the home page, and they export multiple tables, see Data Driven Worksheets for an example.
Base SAS: Demo: ExcelXP Tagset and Microsoft Excel
You need to close the file AFTER you've finished all your "proc prints" or other procedures that you want outputted to the file.
You cannot append to an already created Tagsets.ExcelXP file.
View solution in original post
Thanks alot!
Gonna save me alot of time
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Register now!