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?
Thank you.
Probably ten or twelve or 134 ways to do this. Here's one:
round_down_variable = floor(variable*10)/10;
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.
Hello @CurtisER,
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));
@CurtisER wrote:
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.