make 0 instead of 0.0000000000027

[subrat1]

HI I have a column called Claim, I want to create a new column New_claim as shown below  

Claim	New_Claim
0.00000027	0
-0.0000345	0
-0.00000066	0
0.000045	0
-0.00009	0
0.000000056	0
-0.00000123	0

[Tom · Accepted solution]

Are you just looking for the ROUND function?

It is hard to tell from your example if you want to round the value to integers?

new_claim = round(claim,1);

Or perhaps to hundredths?

new_claim = round(claim,0.01);

[jklaverstijn]

Indeed we need to know the exact rule to be applied. Besides ROUND() there are also INT() and FUZZ().  Depending on the requirements one can pick and choose.

- Jan.

[Reeza]

Depending on what you're doing this may be relevant. 

If that value is calculated, it may be easier to change to calculation. 

http://support.sas.com/documentation/cdl/en/lrcon/69852/HTML/default/viewer.htm#p0ji1unv6thm0dn1gp4t...