https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323550#M271215 <P>Greetings,</P><P>&nbsp;</P><P>I am looking to&nbsp;generate pivot table using tagsets.tableeditor and saving as excel.</P><P>&nbsp;</P><P>CAn anyone please help me with the same.</P><P>&nbsp;</P><P>&nbsp;</P><P>Best,</P><P>Vikas</P> Tue, 10 Jan 2017 09:23:51 GMT Tmacfan 2017-01-10T09:23:51Z https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323550#M271215 <P>Greetings,</P><P>&nbsp;</P><P>I am looking to&nbsp;generate pivot table using tagsets.tableeditor and saving as excel.</P><P>&nbsp;</P><P>CAn anyone please help me with the same.</P><P>&nbsp;</P><P>&nbsp;</P><P>Best,</P><P>Vikas</P> Tue, 10 Jan 2017 09:23:51 GMT https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323550#M271215 Tmacfan 2017-01-10T09:23:51Z https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323552#M271216 <P>Have you already read the documentation for the tagset: <A href="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/" target="_blank">http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/</A>?</P> Tue, 10 Jan 2017 09:42:39 GMT https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323552#M271216 Kurt_Bremser 2017-01-10T09:42:39Z https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323558#M271217 Hi Kurt,<BR />Thanks for the revert but I already tried this.<BR />This creates a save as button but I need to save the pivot in excel automatically.<BR /><BR />Also I am using pc sas 9.3 Tue, 10 Jan 2017 10:04:11 GMT https://communities.sas.com/t5/SAS-Programming/generate-pivot-table-using-tagsets-tableeditor-and-saving-as/m-p/323558#M271217 Tmacfan 2017-01-10T10:04:11Z