Jay, Take a look at the below. Problem1: when use option sheet_name=" Excel ", can't name raw data, pivot chart sheets separately A) A) You are correct, the pivot table currently uses the prefix of the raw data sheet. This is something that can be added. Problem2: when use option pivotdata_fmt="[blue] $#,###.##~$#,###.##", the output excel data doesn't return the desired color and $ format. B) A) This occurs when you use the column numbers to represent the columns rather than the column names when using the pivot table options. This should work the same using either method. The below is an example which uses the column names should provide a short term workaround. ods tagsets.tableeditor file="c:\temp.html" style=sasweb options( button_text="Excel Pivot Export" pivotrow = "Age" pivotcol = "Sex" pivotdata = "Weight" pivotdata_stats = "sum" sheet_name=" Pivot" pivotdata_fmt="[blue]$#,###.##" pivot_format="table10" chart_type="linemarkers" excel_autofilter="yes" pivotcharts="yes" chart_title="Pivot chart" auto_format="color2" ); proc report data=sashelp.class nowd ; column name age sex height weight; title "Sorting data"; define year / display; rbreak after / summarize; run; ods tagsets.tableeditor close; Problem3: When use option image_path="C:\logo.jpg" url="none" , it won't show the logo picture in html email file. A) A) In the current release images are not embedded into the HTML file, therefore it is looking for the image on your C:\ drive. You can store the images on a web server and refer to it using HTTP addressing. Problem4: When use option web_tabs="tab1,tab2" with option pivotcharts="yes" It will only create the pivot chart for output in tab1 but not tab2 after export. A) The readme file for the tagset download should mention some of the interactions between the options which it does not currently do. Some options don't really work well together. For instance this Web_tabs= option will export only the tab that has focus which is why you see the current behavior. . Problem5: When use option autofilter="yes", it conflicts with option PRINT_DIALOG="yes" and PRINT_ZOOM="yes". Plus, any way we can hide the autofilter when print the html output because it looks messy in the printout? A) A) These items have been noted and will be addressed. S
... View more