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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.