topic Re: ODS TAGSETS TABLEEDITOR in ODS and Base Reporting

ODS TAGSETS TABLEEDITOR

P_S_ — Thu, 18 Oct 2012 16:14:19 GMT

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;

Re: ODS TAGSETS TABLEEDITOR

shalinisas — Mon, 24 Jun 2013 12:12:09 GMT

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

Re: ODS TAGSETS TABLEEDITOR

Chevell_sas — Mon, 24 Jun 2013 12:58:46 GMT

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

Re: ODS TAGSETS TABLEEDITOR

P_S_ — Mon, 24 Jun 2013 18:57:44 GMT

Works !!!. Thanks Chevell@sas.

Re: ODS TAGSETS TABLEEDITOR

neha_sas — Wed, 12 Mar 2014 13:58:49 GMT

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

Re: ODS TAGSETS TABLEEDITOR

Reeza — Wed, 12 Mar 2014 14:35:08 GMT

Post your question in a new thread.

Re: ODS TAGSETS TABLEEDITOR

neha_sas — Wed, 12 Mar 2014 14:53:04 GMT

I am not able to open a new thread !

Re: ODS TAGSETS TABLEEDITOR

Reeza — Wed, 12 Mar 2014 17:13:57 GMT

The link below doesn't work?

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

Re: ODS TAGSETS TABLEEDITOR

neha_sas — Thu, 13 Mar 2014 06:13:01 GMT

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