The SAS Output Delivery System and reporting techniques

tagsets.tableeditor and pivot tables

Reply
Frequent Contributor
Frequent Contributor
Posts: 133

tagsets.tableeditor and pivot tables

Hello all-

Happy Friday-

I have a couple of questions regarding the tagsets.tableeditor and output to Excel (and XML)

Here is the basic code I have-It is simply summing the values of a numerator and denominator-

ods tagsets.tableeditor

file="temp.html"

    options(   

           

                sheet_name="HAP Rates"

                auto_excel="yes"

                excel_save_file="P:\example1.xlsx" quit="NO"

                pivotrow="fac_id"

                pivotdata="numer,den"

                pivotdata_stats="sum"

                PIVOTDATA_TOCOLUMNS="yes"

                /*pivotdata_caption="NUM,DEN"*/

                pivotpage = "month" ) ;

Here are my questions-

1) Why does the pivotdata_caption option not work as it should-when I un-comment it out -It only gives me the first column and not the second.

2) Is there is a way to actually hide the underlying sheet (without manual intervention after the production.)

3) How can I color the headers for the columns?

4) How can I make sure that the underlying date format prints correctly (in Excel)

5) How can I actually save as an XML file, not just using the xml extension.

I am sure that I will have more questions, but this is just a start.

Thanks for your time.

Lawrence

SAS Super FREQ
Posts: 8,719

Re: tagsets.tableeditor and pivot tables

Hi:

  These are all good questions for Tech Support. You might find some of the color-related answers here: Base SAS: Creating a Data Grid Like VB.NET .

cynthia

Frequent Contributor
Frequent Contributor
Posts: 133

Re: tagsets.tableeditor and pivot tables

Thanks Cynthia.

I will forward to SAS technical support.

I had gone over that page before but it does not contain the documentation that I need.

Lawrence

Ask a Question
Discussion stats
  • 2 replies
  • 411 views
  • 3 likes
  • 2 in conversation