06-20-2014 06:44 AM
Configuration : ( SAS 9.3 TS Level1M2 running on X64_7PRO platform ) ; MS Excel 2007 ; ExcelXP Tagset version v1.130, 08/02/2013
I have modified the STATISTICAL parent style into one of my own (refer template.sas). This is being used with other macros (refer scorecard.sas) to produce the output ScorecardResults.xls. It seems that despite the 'height=1.5in" specification for table header, SAS ignores it while producing the output. Can you help me understand why.
To be clear on my end objective - example - tab named 'Population Stability', the header row height is 14. Suppose, I want to make this double, that is 28.
06-20-2014 07:55 AM
Have you tried setting the AUTOFIT_HEIGHT option, and ROW_HEIGHTS?
I am not sure there is such an options as height in templates, at least I can't find it in the templates I was looking at?
06-20-2014 10:34 AM
Hi, You are exactly right. These 2 sub-options, specific to TAGSETS.EXCELXP, will make the table header row higher.
ods tagsets.excelxp file='c:\temp\testht2.xml' style=styles.htmlblue
options(doc='Help' row_heights='75,0,0,0,0,0,0' autofit_heights='no');
proc print data=sashelp.class;
ods _all_ close;
06-24-2014 05:13 AM
Thanks for your suggestions. Is there a way to implement such features through a 'style' definition? I had shared the custom template that I am using. In that I want to make the header of all data tables to be wider.
I am using a series of macros that will produce many tables - specifying row_height in each of them separately is not feasible.
The way I can specify
class Header /
cellpadding = 10
height = 1.5in
bordercolor = cxB0B7BB
backgroundcolor = cxEDF2F9
color = cx112277;
Is there any option to increase the row height?
06-24-2014 05:29 AM
Try the option: ROW_HEIGHT_FUDGE
Also refer to the ExcelXp documentation at: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset
06-20-2014 10:27 AM
SAS did not ignore your HEIGHT= option. To prove this, run simplified code as shown on the attached screen shot. As you can see from the output, your approach works just fine in destinations that respect the SAS setting. But Excel has certain defaults for column width and row height and no matter what you set in the style template, when you are sending report output to Excek, you have to look for other ways, such as the AUTOFIT_HEIGHT suboption and the ROW_HEIGHTS suboption to get Excel to pay attention to your changes.