How to remove number after decimal.

[SAM2014]

Hi

Value

0

10

1.234.00

879.00

1

2.00

11.548.00

Output

0

10

1234

879

1

2

11548

How to remove number after decimal.

Thanks

[Kurt_Bremser · Accepted solution]

x = round(x,1);

[SAM2014]

Thanks. Your answer very helpful

[naveen20jan]

Hi SAM ,

We can also  use the below piece iof code for the same .

data have ;

input id  $12.;

datalines;

0

10

1. 1.234.00
2. 879.00

1

1. 2.00
2. 11.548.00

;

data want ;

set have ;

if index (id , '.' )= 0 then x= id  ;

else

x= substr(id,1,(index(id,'.'))-1)

;

run;

[rcwright]

Trouble with using the round function is that it can lead to incorrect results, as the following example demonstrates. A better(?) solution for what you want to do is to use the Int() or Intz() function.

data r ;

     input x ;

     y = round(x,1);

     z1 = Int(x);

     z2 = Intz(x);

datalines;

5.05

5.50

5.55

;;;;