topic Re: how to reading in num value with more than 16 digits! in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91325#M26065 <HTML><HEAD></HEAD><BODY><P>does the table server help, with its extension to data types in SAS.</P><P>It was called something like "data step 2" before GA in earlier releases of SAS9</P></BODY></HTML> Tue, 14 Aug 2012 22:03:17 GMT Peter_C 2012-08-14T22:03:17Z how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91318#M26058 <HTML><HEAD></HEAD><BODY><P>I have a variable in ORACLE database with value like 12345678901234567890--20 digits.</P><P>But SAS only support up to 16 digits.</P><P>Is there anyway to read in that 20 digits number without loss of accuracy?</P><P>Thank you</P></BODY></HTML> Mon, 13 Aug 2012 10:34:18 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91318#M26058 jjjoy 2012-08-13T10:34:18Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91319#M26059 <HTML><HEAD></HEAD><BODY><P>By using Formats&nbsp;&nbsp; you can able to display numeric variables which length is more then 16.</P><P></P><P>Ex..</P><P></P><P>data dsn;</P><P>a=12345678910122341258;</P><P>format a best20.;</P><P>run;</P><P>proc print;</P><P>run;</P><P></P><P>Regards..</P><P>Sanjeev.K</P></BODY></HTML> Mon, 13 Aug 2012 11:15:18 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91319#M26059 kuridisanjeev 2012-08-13T11:15:18Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91320#M26060 <HTML><HEAD></HEAD><BODY><P>I think it is not possible as Numeric............:) If you derive as character just use length.&nbsp; </P></BODY></HTML> Mon, 13 Aug 2012 11:31:22 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91320#M26060 yaswanthj 2012-08-13T11:31:22Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91321#M26061 <HTML><HEAD></HEAD><BODY><P>It is not a matter of importing the value, but rather one of storage.&nbsp; SAS uses a length of 8 to store numerics, this allows 16 digits to be stored accurately (depending on your OS).&nbsp; See <A href="http://support.sas.com/techsup/technote/ts654.pdf">http://support.sas.com/techsup/technote/ts654.pdf</A> for more information.</P><P></P><P>So what to do?&nbsp; It depends.&nbsp; What do you want to do with the data value?&nbsp; Arithmatic?&nbsp; Is it a code that can be converted to character as suggested above?</P></BODY></HTML> Mon, 13 Aug 2012 17:48:27 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91321#M26061 ArtC 2012-08-13T17:48:27Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91322#M26062 <HTML><HEAD></HEAD><BODY><P>try to enforce conversion to character to store in SAS. The option</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DBSASTYPE</P><P>might help</P></BODY></HTML> Mon, 13 Aug 2012 21:20:27 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91322#M26062 Peter_C 2012-08-13T21:20:27Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91323#M26063 <HTML><HEAD></HEAD><BODY><P>We also have such large oracle numeric dimension keys.</P></BODY></HTML> Mon, 13 Aug 2012 23:01:37 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91323#M26063 RobertH 2012-08-13T23:01:37Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91324#M26064 <HTML><HEAD></HEAD><BODY><P>If these are just key values can't they be treated as character strings?&nbsp; If you truly need them to be numeric, you will need to tell us what it is that you are trying to accomplish with them. </P></BODY></HTML> Tue, 14 Aug 2012 18:10:37 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91324#M26064 ArtC 2012-08-14T18:10:37Z Re: how to reading in num value with more than 16 digits! https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91325#M26065 <HTML><HEAD></HEAD><BODY><P>does the table server help, with its extension to data types in SAS.</P><P>It was called something like "data step 2" before GA in earlier releases of SAS9</P></BODY></HTML> Tue, 14 Aug 2012 22:03:17 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-reading-in-num-value-with-more-than-16-digits/m-p/91325#M26065 Peter_C 2012-08-14T22:03:17Z