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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.