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;
Never mind. Posted this in the wrong thread. I'll post it in SAS programming.
Never mind. Posted this in the wrong thread. I'll post it in SAS programming.
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;
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.