03-13-2014 02:12 AM
1)Is there a way that I could directly create Pivot table from sas instead of creating a HTML file with a " Create Pivottable " button on it.
The reason i ask is that I need to export the SAS data into a Pivot in Unix and upload it at a certain location.
Also, the data I am dealing with is huge and opening a HTML file is taking a lot of time , let alone the time it takes to create the Pivot Table
2)Second question: Is there any option that can be used to just retain the excel tab with Pivot table and delete the rest of the sheets ( including data sheet).
03-13-2014 06:58 AM
As far as I am aware there is no "pivot table" file format, but it is normally part of an Excel file. With this in mind, I don't see any way to directly create this from SAS using tagsets etc. so you would need to investigate the Open XML document format used by latest incarnations of Excel, Overview of the XML file formats in Office 2010
You can pretty much build any type of Excel file directly as text files and zip them up. Its really not straightforward though, took a fair time to get just a few values into a new file doing it this way when I tried as there are several files/folder with the xlsx (which is a zip - rename the extension .zip and you can open it).
One way could be to create the pivot table as you would in Excel. Then rename the to zip and open and see what xml files are generated. From there work back to your SAS program.