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!
CEIL function.
@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!
CEIL function.
@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!
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!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: