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;
The 2025 SAS Hackathon has begun!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.