You can use the CEIL function in SAS to return the smallest integer that is greater than or equal to some numeric value.
The following example shows how to use the CEIL function in practice.
Note: The opposite of the CEIL function in SAS is the FLOOR function.
Example: How to Use CEIL Function in SAS
Suppose we have the following dataset in SAS that contains information about the average items sold by various employees at some company:
/*create dataset*/
data my_data;
input employee $ avg_sales;
datalines;
Andy 12.3
Bob 14.5
Chad 8.44
Derrick 12.87
Eric 8.01
Frank 10
George 11.5
Henry 11.99
Isaac 7.64
;
run;
/*view dataset*/
proc print data=my_data;
We can use the CEIL function to return the smallest integer that is less than or equal to each numeric value in the avg_sales column:
/*create new dataset*/
data new_data;
set my_data;
ceil_avg_sales = ceil(avg_sales);
run;
/*view new dataset*/
proc print data=new_data;
Notice that the new column called ceil_avg_sales contains the smallest integer that is less than or equal to each numeric value in the avg_sales column.
For example:
- The value 12.30 becomes 13.
- The value 14.50 becomes 15.
- The value 8.44 becomes 9.
- The value 12.87 becomes 13.
And so on.
Additional Resources
The following tutorials explain how to perform other common tasks in SAS:
How to Round Numbers in SAS
How to Remove Commas from Strings in SAS
How to Display Values in Percent Format in SAS