topic rounding numbers with a decimal place up the next whole number in SAS Enterprise Guide

rounding numbers with a decimal place up the next whole number

cnilsen — Thu, 29 Oct 2020 17:23:20 GMT

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:

17.72

13.47

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:

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

Any help would be appreciated!

Re: rounding numbers with a decimal place up the next whole number

Reeza — Thu, 29 Oct 2020 17:28:01 GMT

CEIL function.

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lefunctionsref&docsetTarget=n12bhb0oxndi2bn11205ojzgbdrw.htm&locale=en

@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!

Re: rounding numbers with a decimal place up the next whole number

cnilsen — Thu, 29 Oct 2020 17:41:05 GMT

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