DATA Step, Macro, Functions and more

Having issue with representation of decimal

Reply
Occasional Contributor
Posts: 6

Having issue with representation of decimal

Hi,

    I have an issue with representation of decimal values.

For eg.

   12.1234567890123456789

i defined it with an informat 30.20 and format 30.20, but the output is truncated as SAS stores only a maximum of 8 bytes i.e. 16 places.

Which format should i define to have the precision without truncation. This precision is mandatory in my case for calcualtions and reporting. Losing the precision would be an issue.

Please help!

I tried best32. too. It did not work.

Thank you

Contributor
Posts: 60

Re: Having issue with representation of decimal

Posted in reply to khchaitanya

only best12. will work, automatically SAS will show the numbers in Exponentially when it exceeds more than 12 digits.

SAS Employee
Posts: 26

Re: Having issue with representation of decimal

Posted in reply to khchaitanya

SAS handles up to 15 digits of significance in numeric variables.

Here are documentation links you may find useful:

http://support.sas.com/techsup/technote/ts654.pdf
http://support.sas.com/techsup/technote/ts230.html

Jan

Ask a Question
Discussion stats
  • 2 replies
  • 172 views
  • 0 likes
  • 3 in conversation