Using a special character in a proc report define display option

[jmextratall]

I am trying to create report output using proc report. For one of my variables, I want the column header to read "FPR (Non-Fraud/Fraud)" to show how it was derived. My define statement looks like this:

define FPR /Center display "FPR/(Non-Fraud/Fraud)";

However, both '/' in the quotes creates a line return instead of displaying the second / in between Non-Fraud and Fraud. 

How can I get that second / to display in my output report column header?

[FreelanceReinh · Accepted solution]

Hi @jmextratall,

You can specify a different split character in the PROC REPORT statement using the SPLIT= option, e.g.

proc report data=... split='|';

and then use that in place of the first slash in the column header.

[jmextratall]

Perfect! Thank you!!

[sbxkoenk]

Hello,

I was about to write the same answer as @FreelanceReinh .

Just wanted to add this:

@jmextratall 

It's always better to include a bit of (working) code in your question using a SASHELP dataset that everybody has available.

People can then copy/paste in their editor, submit and correct.

The code entered should not even make sense, something like:

proc report data=sashelp.class SPLIT='#';
   column name sex age height weight;
   define sex / center display "FPR/(Non-Fraud/Fraud)";
run;
QUIT;

will do.

Cheers,

Koen