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
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.
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.