Can someone suggest a fix that will make the "<0.5%" format work?
proc format;
picture custpcttwo
/*format values above .5% as whole percentages*/
.005-high='0009%' (round) (mult=100)
/*for those btw 0 and .5% format as "<0.5%"*/
low-<.005 = '<0.5%'
;
run;
data a;
x=.005;
y=.0003;
run;
proc print data=a;
var x y;
format x y custpcttwo.;
run;
proc format;
picture custpcttwo(round)
/*format values above .5% as whole percentages*/
.005-high='0009%' (mult=100)
/*for those btw 0 and .5% format as "<0.5%"*/
low-<.005 = '<0.5%' (noedit)
;
run;
data a;
x=.005;
y=.0003;
run;
proc print data=a;
var x y;
format x y custpcttwo.;
run;
2025 SAS Hackathon: There is still time!
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!