BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Batman
Quartz | Level 8

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;
1 ACCEPTED SOLUTION

Accepted Solutions
Batman
Quartz | Level 8

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

View solution in original post

2 REPLIES 2
Batman
Quartz | Level 8

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

Ksharp
Super User
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;

Ksharp_0-1750128655370.png