Creating a Pivot Table with existing data in a workbook

Elliott — Mon, 15 Aug 2016 15:15:57 GMT

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,

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

Cynthia_sas — Tue, 16 Aug 2016 12:17:44 GMT

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

topic Creating a Pivot Table with existing data in a workbook in ODS and Base Reporting

Creating a Pivot Table with existing data in a workbook

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