Hello,
If you want to generate the pivot table without having to select the export button from the HTML page, you can use the other method of generating the pivot table. This method requires that you point to an an existing Excel/HTML/XML/CSV file or create one that can be used as the data source to the pivot table. The TableEditor tagset can then point to this data and with options generate the JavaScript processing instructions on how to generate the pivot tables. The below blog explains this in detail, please let me know of any problems.
https://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/
Sincerely,
Chevell
... View more