Hello,
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?
Thank you,
Here is the code:
ods tagsets.tableeditor file="C:\exampleaa.html"
options(
button_text = "Create Pivot"
auto_excel = "yes"
pivotrow = "region,product"
pivotdata="stores,inventory"
pivotdata_stats="sum"
pivot_format="light10"
sheet_name="TEST"
quit="NO"
);
proc print data=sashelp.shoes;
run;
ods tagsets.tableeditor close;
To have this appear as columns rather than rows, add the PIVOTDATA_TOCOLUMNS="yes" option which should do this.
SAS support Can you please help I have the same problem!!!!!
To have this appear as columns rather than rows, add the PIVOTDATA_TOCOLUMNS="yes" option which should do this.
Works !!!. Thanks Chevell@sas.
Hi Chevell,
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).
Thanks
Post your question in a new thread.
I am not able to open a new thread !
The link below doesn't work?
Thanks Reeza, I have now posted it as a new question.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.