generate pivot table using tagsets.tableeditor and saving as excel

Tmacfan · Posted 01-10-2017 04:23 AM

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 · Posted 01-10-2017 04:42 AM

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

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Tmacfan · Posted 01-10-2017 05:04 AM

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

generate pivot table using tagsets.tableeditor and saving as excel

Re: generate pivot table using tagsets.tableeditor and saving as excel

Re: generate pivot table using tagsets.tableeditor and saving as excel

generate pivot table using tagsets.tableeditor and saving as excel

Re: generate pivot table using tagsets.tableeditor and saving as excel

Re: generate pivot table using tagsets.tableeditor and saving as excel

Click image to register for webinar

Classroom Training Available!