topic How to remove number after decimal. in SAS Procedures

How to remove number after decimal.

SAM2014 — Tue, 24 Jun 2014 07:09:51 GMT

Value

1.234.00

879.00

2.00

11.548.00

Output

1234

879

11548

How to remove number after decimal.

Thanks

Re: How to remove number after decimal.

Kurt_Bremser — Tue, 24 Jun 2014 07:34:53 GMT

x = round(x,1);

Re: How to remove number after decimal.

SAM2014 — Tue, 24 Jun 2014 07:39:12 GMT

Thanks. Your answer very helpful

Re: How to remove number after decimal.

naveen20jan — Thu, 03 Jul 2014 05:14:26 GMT

Hi SAM ,

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

data have ;

input id $12.;

datalines;

1.234.00
879.00

2.00
11.548.00

;

data want ;

set have ;

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

else

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

;

run;

Re: How to remove number after decimal.

rcwright — Thu, 03 Jul 2014 18:53:46 GMT

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

;;;;