topic Re: make 0 instead of 0.0000000000027 in SAS Programming

make 0 instead of 0.0000000000027

subrat1 — Sat, 25 Feb 2017 12:16:52 GMT

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

Re: make 0 instead of 0.0000000000027

Tom — Sat, 25 Feb 2017 12:27:22 GMT

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);

Re: make 0 instead of 0.0000000000027

jklaverstijn — Sat, 25 Feb 2017 14:37:09 GMT

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.

Re: make 0 instead of 0.0000000000027

Reeza — Sat, 25 Feb 2017 15:33:23 GMT

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#p0ji1unv6thm0dn1gp4t01a1u0g6.htm