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
Thanks. Your answer very helpful
Hi SAM ,
We can also use the below piece iof code for the same .
data have ;
input id $12.;
datalines;
0
10
1
;
data want ;
set have ;
if index (id , '.' )= 0 then x= id ;
else
x= substr(id,1,(index(id,'.'))-1)
;
run;
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
;;;;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.