p-value format

[MaartenC]

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?

[Kurt_Bremser · Accepted solution]

The SAS format for this is Ew.

[ChrisHemedinger]

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 */