topic Re: ODS - # character from column label doesn't appear in excel output in ODS and Base Reporting

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

Diana_K — Fri, 06 Jan 2023 07:59:25 GMT

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!

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

FreelanceReinh — Fri, 06 Jan 2023 08:59:42 GMT

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.

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

Diana_K — Fri, 06 Jan 2023 09:12:22 GMT

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!