BookmarkSubscribeRSS Feed
LB
Quartz | Level 8 LB
Quartz | Level 8

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

2 REPLIES 2
Cynthia_sas
SAS Super FREQ

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

LB
Quartz | Level 8 LB
Quartz | Level 8

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1263 views
  • 3 likes
  • 2 in conversation