I have an user who wants to round down any values between .45 and .49. The user doesn't want it to automatically round up to .5.
How do I check on decimal points only for any decimal values between .45 and .49 and then round down to .4?
You could use the IFN function:
data have; input x @@; cards; 1.44 2.45 3.49 4.50 5.54 6.55 ; data want; set have; r=ifn(.45<=mod(x,1)<=.49, int(x)+.4, round(x,.1)); run;
If x can also be negative and then the same rule is to be applied, use
r=ifn(.45<=abs(mod(x,1))<=.49, int(x)+sign(x)*.4, round(x,.1));
But how do I check for .45 - .49, then round down?
This floor function might work but I don't want to affect any other decimal values that aren't between .45 and .49.
You can always include an IF statement to handle just the numbers between .45 and .49
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.