rounding numbers with a decimal place up the next whole number

[cnilsen]

Hi,

I'm working to enhance an EG report with some new calcs to be used for determining shipping measurements 

My data set will have 3  numeric data columns with whole numbers & numbers with decimal positions.

IE:

5

17.72

13.47

15

6.15

For the values that have no decimal positions, I need to leave those numbers 'as is'

Any value that has a decimal position, I need to always round up to the next whole number with no decimal positions

so my expected results will be:

5

18

14

15

7

Does anyone know of a function or routine I can use for this? 

Any help would be appreciated!

[Reeza · Accepted solution]

CEIL function.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarg...

---

@cnilsen wrote:

Hi,

I'm working to enhance an EG report with some new calcs to be used for determining shipping measurements 

My data set will have 3  numeric data columns with whole numbers & numbers with decimal positions.

IE:

5

17.72

13.47

15

6.15

For the values that have no decimal positions, I need to leave those numbers 'as is'

Any value that has a decimal position, I need to always round up to the next whole number with no decimal positions

so my expected results will be:

5

18

14

15

7

Does anyone know of a function or routine I can use for this? 

Any help would be appreciated!

---

[cnilsen]

That worked PERFECT... thank you for the quick response!
-Chris