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?
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 */
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.