topic Re: How to truncate values after decimal ? in SAS Programming

How to truncate values after decimal ?

nikunjgattani — Tue, 17 Mar 2015 10:32:03 GMT

Hi,

I want to remove the values after decimal places. For ex -

13.265 should become 13

-12.514 should become -12

Regards,

Nikunj

RW9 — Tue, 17 Mar 2015 10:40:10 GMT

Well, you need to round the value. There are several options:

floor(value) = takes the minimum e.g. 13.265 becomes 13

ceil(value) = takes the maximum e.g 13.265 becomes 14

Then ther's the round() function:

There are many other functions for working with numbers (int() is another).

Vish33 — Tue, 17 Mar 2015 10:42:26 GMT

use round function ex: round(variable_name,2) else use formats.

user24feb — Tue, 17 Mar 2015 11:08:54 GMT

Use the integer function: Truncated_Variabel=Int(Variable);