Is anyone aware of any options in PROC REPORT to swiych off the spanning of column headers when using characters such as "+". I have a report with a column header of "++" and this is, as expected, repeating "+" across the width of the column (> 2 characters in width).
So far the only solution I have been able to think of is to create a column header of "[++]" and this stops the spanning of the column header.
Has anyone got any other solutions or knows of a way of turning this spanning off?
The use of special characters for spanning headers only works for LISTING. When you route your output to other ODS destinations, you should NOT get spanning headers, but should just see the character + or * once.
According to the doc,
In traditional (monospace) SAS output, if the first and last characters of a header are one of the following characters, then PROC REPORT uses that character to expand the header to fill the space over the column or columns:
:- = \_ .* +
so if you pick some character that's NOT in the above list (like the # or ^), you should NOT get repeating characters even in LISTING window.
Thanks for the swift reply. I still route PROC REPORT to the listing destination as that's what's required most of the time in my day-to-day job.
I'd already encountered the "<" ">" repeating functionality. I managed to get round the problem by inserting a blank character (using BYTE(160)) before and after the "++" and this stopped the spanning characters.
Another example of having to fool SAS into doing what you want it to do rather than it doing what it's been asked to do. Not that I'm complaining ... after all it keeps you on your toes.