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
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
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.