ODS TAGSETS TABLEEDITOR

[P_S_]

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;

[shalinisas]

SAS support Can you please help I have the same problem!!!!!

[Chevell_sas · Accepted solution]

To have this appear as columns rather than rows, add the PIVOTDATA_TOCOLUMNS="yes" option which should do this.

[P_S_]

Works !!!. Thanks Chevell@sas.

[neha_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

[Reeza]

Post your question in a new thread.

[neha_sas]

I am not able to open a new thread !

[Reeza]

The link below doesn't work?

https://communities.sas.com/community/support-communities/post!input.jspa?containerType=14&container...

[neha_sas]

Thanks Reeza, I have now posted it as a new question.