topic Re: p-value format in SAS Enterprise Guide

p-value format

MaartenC — Thu, 13 Oct 2016 13:16:44 GMT

Hi all,

I would like for my procedures (for example 'proc logistic') to output (html) p-values in a scientific format. I already used a proc template before to output the p-values the exact way, but now I would like it in the form of: xE-d, where the E stands for 10. E.g.: 0.00012 should become 1.2E-4. I could not find any format of that kind.

Can someone help?

Re: p-value format

Kurt_Bremser — Thu, 13 Oct 2016 13:28:35 GMT

The SAS format for this is Ew.

Re: p-value format

ChrisHemedinger — Thu, 13 Oct 2016 17:22:43 GMT

You might also be interested in how SAS works with p-value and odds ratio formats behind-the-scenes - @Rick_SAS wrote a blog post about this.

Sample code that demonstrates:

data FmtExample(drop=d);
do d = -5 to 3;
   raw = 10**d;
   oddsRatio = raw;
   if d<=0 then pVal = raw;   /* a p-value must be less than 1 */
   else pVal = .;
   output;
end;
format raw BEST8. oddsRatio ODDSR8.3 pVal PVALUE6.4;
run;
 
options missing=" ";          /* display missing values as blanks */
proc print noobs; run;
options missing=".";          /* reset display of missing values */