The SAS Output Delivery System and reporting techniques

Creating a Pivot Table with existing data in a workbook

Reply
Contributor
Posts: 74

Creating a Pivot Table with existing data in a workbook

I am trying to open an existing multi page workbook and create a pivot table for each sheet using sas.  I am not having much luck with the ods tagsets.tableeditor examples I have found.  They all want to produce a button that then opens excel.  That does not work for me.  I am already using ods to create the output in an excel sheet and emailing it to myself with sas.  I want to add the pivot tables so I don't have to manually create them.  Is there any information available that will help me achieve this?

 

Thanks,

SAS Super FREQ
Posts: 8,868

Re: Creating a Pivot Table with existing data in a workbook

Hi:
TAGSETS.TABLEEDITOR works by using JavaScript to take the originally produced HTML table and then produce an Excel workbook/sheets. So, I am not sure whether you can do what you want, directly with the destination. This may be a question for Tech Support.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 264 views
  • 0 likes
  • 2 in conversation