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.
Cheers
Abhishek
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?
Hi, You are exactly right. These 2 sub-options, specific to TAGSETS.EXCELXP, will make the table header row higher.
Cynthia
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;
run;
ods _all_ close;
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 /
vjust=m
cellpadding = 10
height = 1.5in
bordercolor = cxB0B7BB
backgroundcolor = cxEDF2F9
color = cx112277;
Is there any option to increase the row height?
Thanks
Abhishek
Hi,
Try the option: ROW_HEIGHT_FUDGE
Also refer to the ExcelXp documentation at: Base SAS: Quick Reference for TAGSETS.EXCELXP Tagset
Hi:
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.
cynthia
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.