How to auto exporting pivot table to excel without clicking the button on HTML?

[AmberLOL]

Hi All,

I want to auto export the pivot table and creating a new excel file at the same time, but do not use the step of HTML.

Is there a way to realize it? Could you provide a sample code ? Thank you.

[ChrisHemedinger]

Check out 's recent article about this:

http://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/

Chris