Utility of sas floor and sas ceil functions.
Floor integer function sas.
The ceil function rounds up.
If the argument s value is within 10 12 of an integer the function results in that integer.
Briefly i want to mention the sas floor and sas ceil functions.
The int function returns the integer portion of the argument truncates the decimal portion.
If the value of argument is positive the int function has the same result as the floor function.
If the value of argument is negative the int function has the same result as the ceil function.
The round function rounds to the nearest integer.
If the argument s value is within 1e 12 of an integer the function results in that integer.
The int function returns the integer portion of the argument truncates the decimal portion.
Therefore with the floorz function you might get unexpected results.
The int function rounds towards zero.
In the case below it will return 2.
If the value of argument is positive int argument has the same result as floor argument.
If the argument is within 1e 12 of an integer the floor function fuzzes the result to be equal to that integer.
The functions that perform rounding are the same in the data step as in the sas iml language.
The floorz function uses zero fuzzing.
Unlike the floorz function the floor function fuzzes the result.
If the value of argument is negative the int function has the same result as the ceil function.
If the value of argument is positive the int function has the same result as the floor function.
Therefore with the floorz function you might get unexpected results.
If the argument s value is within 1e 12 of an integer the function results in that integer.
The floor function rounds down.
The floor function fuzzes the results so that if the results are within 1e 12 of an integer the floor function returns that integer.
If sas reads y with a different informat or if a program other than sas reads y then there is no guarantee that the characters 0 3 would produce a value of exactly 3 10.
It will be easier to understand their role now that you understood the explanation above about sas round function.
The floor function returns the largest integer that is less or equal to the argument.
Round treats the rounding unit as a.
For example and while.
When the rounding unit is the reciprocal of an integer the round function computes the result by dividing by the integer.
If the value of argument is positive the int function has the same result as the floor.