10-18-2012 12:14 PM
I am using ods tableeditor tagsets to create an excel pivot table from sas.
I am using sashelp.shoes dataset for my example.
I have region and product as my pivotrow variables. For my pivotdata variables I am using stores and inventory and I am using pivotdata_stats = "sum".
Now the problem I am having is the sum for stores and inventory appear in the rows in the excel spreadsheet. I would like these stats to appear in the column.
Is there a way to do this directly from sas?
Here is the code:
ods tagsets.tableeditor file="C:\exampleaa.html"
button_text = "Create Pivot"
auto_excel = "yes"
pivotrow = "region,product"
proc print data=sashelp.shoes;
ods tagsets.tableeditor close;
03-12-2014 09:58 AM
I saw your post on tagset table editor. I was wondering if 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
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).