topic Re: Proc report does not work when the output file type is excel and it has special characters in SAS Programming

Proc report does not work when the output file type is excel and it has special characters

ANKH1 — Mon, 05 Feb 2024 19:18:02 GMT

Hi,

I ran proc report and apparently it does not like when a value for character value has the symbol "<". The value is <0.0001.

Re: Proc report does not work when the output file type is excel and it has special characters

A_Kh — Mon, 05 Feb 2024 19:35:57 GMT

Hi,

Can you post the sas code you ran as well?

Depending on assigned formats values may get displayed differently. For example, <0.0001 seems like a p-value. If so, then specifying pvalue6.4 format in define statement should resolve the issue.

define varname/........format=pvalue6.4;

Re: Proc report does not work when the output file type is excel and it has special characters

ANKH1 — Tue, 06 Feb 2024 15:01:50 GMT

Thanks for responding. I realized that I just had to change off to on in protectspecialchars=on. This solved the problem!

The code for proc report is

proc report data = dsout nowd missing split = '~' spacing=2 style(column)=[protectspecialchars=on asis=on];
column var estimate pvalue;
define ....;
run;

Re: Proc report does not work when the output file type is excel and it has special characters

Reeza — Tue, 06 Feb 2024 15:39:10 GMT

Please mark the question as resolved and select the solution you posted regarding protectspecialchars option.

Re: Proc report does not work when the output file type is excel and it has special characters

ANKH1 — Tue, 06 Feb 2024 16:37:54 GMT