Hi, Since you did not post data, no one can run your code. However I do not observe what you describe. Using SAS 9.4M5 and either ODS EXCEL or ODS TAGSETS.EXCELXP, I do not have any wrapping for the spanning header, as shown below:
Notice that I took EVERYTHING out of the code except the font specification and my long header did not wrap.
I have a few comments about your code, you've mixed some ODS options and style overrides with LISTING only options. For example WIDTH=15 or WIDTH=20 and FLOW are all listing only options that are ignored by ODS destinations.
I also notice that you seem to NOT use units of measure such as font_size=1.5? 1.5 what? pixels, points??? makes more sense to specify 10pt because 1.5 pt is really, really small. Even 1.5 pixels would be pretty tiny. You've commented out CELLHEIGHT. As you can see in my output, I didn't need to use CELLHEIGHT -- my fonts seem to be 10pt for the data cells and 12pt for the header cells. Did you want to go bigger or smaller than that?
I didn't mess with borderwidths -- a borderwidth of 1, again is 1 pixel...I generally find you need a larger borderwidth for them to get bigger. Also there is a distinct chance that Excel won't honor your borderwidths.
The use of 3 style overrides in 1 DEFINE statement is going to force ODS and PROC REPORT to try to resolve all the settings.
if you want some style elements in common across all items on the report, then put what you want in the overrides in the PROC REPORT statement -- but 3 overrides in one DEFINE is just confusing.
I'm not seeing issues with my simplified version of your code. So my guess is something in your combination of overrides is messing up the spacing.
Cynthia
... View more