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

[ANKH1]

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. 

[A_Kh]

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; 

[ANKH1 · Accepted solution]

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;

[Reeza]

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

[ANKH1]

ok