ODS - # character from column label doesn't appear in excel output

[Diana_K]

Hello,

I am new with both ODS and proc reports, and I have a variable with the label as "Sample #" but I can't get the # to come through the excel report as well.

I've attached a picture of the attributes of my variables, the proc report program as well as the excel output.

Thank you!

[FreelanceReinh · Accepted solution]

Hello @Diana_K and welcome to the SAS Support Communities!

With the option SPLIT = '#' of the PROC REPORT statement you told SAS to interpret the "#" as a marker where to put a line break: A column header of the form "First#Second" would be written as

First
Second

So, just remove the SPLIT= option (to use the default split character "/") or specify a different split character (e.g., split = '~') which does not occur as text in your column headers.

[Diana_K]

Aaaaaah thank you, yes, I feel silly now.

I've picked up this program from someone else, indeed changing the # into something else solved the issue.

Much appreciated!