SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

another tagsets.excelxp question

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

another tagsets.excelxp question

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?  


Accepted Solutions
Solution
‎02-25-2014 03:45 PM
Grand Advisor
Posts: 16,324

Re: another tagsets.excelxp question

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


All Replies
Solution
‎02-25-2014 03:45 PM
Grand Advisor
Posts: 16,324

Re: another tagsets.excelxp question

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.

Occasional Contributor
Posts: 16

Re: another tagsets.excelxp question

Thanks alot!

Gonna save me alot of time

Post a Question
Discussion Stats
  • 2 replies
  • 358 views
  • 1 like
  • 2 in conversation