topic Re: proc report slash (/) missing on proc report result in SAS Enterprise Guide

proc report slash (/) missing on proc report result

Daily1 — Mon, 17 Jul 2023 12:06:41 GMT

data three;
	infile datalines;
	input a $ b $ x $ y $ z $ m $;
return;
datalines;
A/A 21 22 23 24 25
AB 26 27 28 29 30
;
run;

proc report data=three;
run;

"/" is missing on my result. pls help. Thanks

i want this type output but i need A/A on result. why / is missing on result?

Re: proc report slash (/) missing on proc report result

PaigeMiller — Mon, 17 Jul 2023 11:35:21 GMT

When I run your code, I see the slash in the PROC REPORT output.

Please show us a screen capture of what you are seeing. Please use the "Insert Photos" icon to include your screen capture in your reply. Do NOT attach files. Also, what SAS interface are you using (Base SAS, Enterprise Guide, SAS Studio, other) and what output destination are you using?

Re: proc report slash (/) missing on proc report result

Tom — Mon, 17 Jul 2023 11:47:51 GMT

Tell PROC REPORT to use a different character as the SPLIT character.

data three;
	infile datalines;
	input a $ b  x $ y $ z $ m $;
return;
datalines;
A/A 21 22 23 24 25
AB 26 27 28 29 30
;

proc report data=three split='|';
  column  a,(b );
  define a / across;
run;

Re: proc report slash (/) missing on proc report result

Daily1 — Mon, 17 Jul 2023 17:31:07 GMT

https://communities.sas.com/t5/SAS-Enterprise-Guide/proc-report-slash-missing-on-proc-report-result/td-p/885016

Re: proc report slash (/) missing on proc report result

Daily1 — Mon, 17 Jul 2023 17:38:52 GMT

Solution:

data three;
   infile datalines;
   input a $ b $ x $ y $ z $ m $;
datalines;
A/A 21 22 23 24 25
AB 26 27 28 29 30
;
run;

proc report data=three nowd;
   column a b x y z m;
run;

Re: proc report slash (/) missing on proc report result

Cynthia_sas — Mon, 17 Jul 2023 18:22:13 GMT

Hi:

Another character specification that can cause this behavior is ODS ESCAPECHAR, as shown below in #1 example:

As shown in the #2 report, with ODS ESCAPECHAR set to a different character, the slash in the data shows.

Interestingly, when I have SPLIT='/' I do see the A/A in the data cell:

Running SAS 9.4M7.

Cynthia

Re: proc report slash (/) missing on proc report result

Tom — Mon, 17 Jul 2023 18:36:06 GMT

To have PROC REPORT recognize split char in DATA (as opposed to HEADERS) you have to

Define the column to use the FLOW option.
Direct the output to the LISTING destination instead of ODS.

Re: proc report slash (/) missing on proc report result

Cynthia_sas — Mon, 17 Jul 2023 21:54:02 GMT

Hi, @Tom:
That's correct; however the original posting showed HTML output not LISTING, and the code showed no change to the SPLIT= option, so the default was in effect. I haven't had a chance to test the original code in EG yet, but I suspect it won't make a difference.
Thanks for the clarification.
Cynthia