topic Re: Custom formatting in New SAS User

Custom formatting

Batman — Mon, 16 Jun 2025 19:06:27 GMT

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;

Re: Custom formatting

Batman — Mon, 16 Jun 2025 19:15:11 GMT

Never mind. Posted this in the wrong thread. I'll post it in SAS programming.

Re: Custom formatting

Ksharp — Tue, 17 Jun 2025 02:51:03 GMT

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;