08-15-2016 11:15 AM
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?
08-16-2016 08:17 AM