Solved
Contributor
Posts: 58

# make 0 instead of 0.0000000000027

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

Accepted Solutions
Solution
‎02-25-2017 12:43 PM
Super User
Posts: 8,070

## Re: make 0 instead of 0.0000000000027

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

All Replies
Solution
‎02-25-2017 12:43 PM
Super User
Posts: 8,070

## Re: make 0 instead of 0.0000000000027

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

Valued Guide
Posts: 533

## Re: make 0 instead of 0.0000000000027

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.

Super User
Posts: 23,663

## Re: make 0 instead of 0.0000000000027

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...

☑ This topic is solved.