DATA Step, Macro, Functions and more

How to truncate values after decimal ?

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

How to truncate values after decimal ?


Hi,

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

13.265 should become 13

-12.514 should become -12

Regards,

Nikunj


Accepted Solutions
Solution
‎03-17-2015 07:08 AM
Super Contributor
Posts: 336

Re: How to truncate values after decimal ?

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

View solution in original post


All Replies
Super User
Super User
Posts: 7,401

Re: How to truncate values after decimal ?

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:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

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

Frequent Contributor
Posts: 117

Re: How to truncate values after decimal ?

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

Solution
‎03-17-2015 07:08 AM
Super Contributor
Posts: 336

Re: How to truncate values after decimal ?

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 9664 views
  • 6 likes
  • 4 in conversation