The SAS Output Delivery System and reporting techniques

ODS TAGSETS TABLEEDITOR

Accepted Solution Solved
Reply
Contributor
Posts: 42
Accepted Solution

ODS TAGSETS TABLEEDITOR

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;

Attachment

Accepted Solutions
Solution
‎06-24-2013 08:58 AM
SAS Employee
Posts: 87

Re: ODS TAGSETS TABLEEDITOR

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

View solution in original post


All Replies
N/A
Posts: 1

Re: ODS TAGSETS TABLEEDITOR

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

Solution
‎06-24-2013 08:58 AM
SAS Employee
Posts: 87

Re: ODS TAGSETS TABLEEDITOR

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

Contributor
Posts: 42

Re: ODS TAGSETS TABLEEDITOR

Works !!!. Thanks Chevell@sas.

Occasional Contributor
Posts: 10

Re: ODS TAGSETS TABLEEDITOR

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

Grand Advisor
Posts: 16,367

Re: ODS TAGSETS TABLEEDITOR

Post your question in a new thread.

Occasional Contributor
Posts: 10

Re: ODS TAGSETS TABLEEDITOR

I am not able to open a new thread !

Grand Advisor
Posts: 16,367

Re: ODS TAGSETS TABLEEDITOR

Occasional Contributor
Posts: 10

Re: ODS TAGSETS TABLEEDITOR

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

Post a Question
Discussion Stats
  • 8 replies
  • 2111 views
  • 1 like
  • 5 in conversation