generate pivot table using tagsets.tableeditor and saving as excel

[Tmacfan]

Greetings,

I am looking to generate pivot table using tagsets.tableeditor and saving as excel.

CAn anyone please help me with the same.

Best,

Vikas

[Kurt_Bremser]

Have you already read the documentation for the tagset: http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/?

[Tmacfan]

Hi Kurt,
Thanks for the revert but I already tried this.
This creates a save as button but I need to save the pivot in excel automatically.

Also I am using pc sas 9.3