BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
gusfryk01
Calcite | Level 5

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?  

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

You're doing it wrong Smiley Happy

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

2 REPLIES 2
Reeza
Super User

You're doing it wrong Smiley Happy

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.

gusfryk01
Calcite | Level 5

Thanks alot!

Gonna save me alot of time

sas-innovate-2024.png

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!

Discussion stats
  • 2 replies
  • 942 views
  • 1 like
  • 2 in conversation