topic Re: Using a special character in a proc report define display option in SAS Programming

Using a special character in a proc report define display option

jmextratall — Fri, 09 Apr 2021 17:28:04 GMT

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?

Re: Using a special character in a proc report define display option

FreelanceReinh — Fri, 09 Apr 2021 17:48:24 GMT

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.

Re: Using a special character in a proc report define display option

jmextratall — Fri, 09 Apr 2021 17:56:17 GMT

Perfect! Thank you!!

Re: Using a special character in a proc report define display option

sbxkoenk — Fri, 09 Apr 2021 18:00:21 GMT

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