https://communities.sas.com/t5/SAS-Programming/reading-a-big-numeric-field-from-IQ-to-sas/m-p/802732#M316048 <P>What arithmetic are you doing with a number with that many digits?</P> <P>&nbsp;</P> <P>You should show exactly how you connected to Sybase to retrieve that data. Someone with experience connecting to that database may have a suggestion but it may be converting to character in the database before reading into SAS.</P> Fri, 18 Mar 2022 04:39:13 GMT ballardw 2022-03-18T04:39:13Z https://communities.sas.com/t5/SAS-Programming/reading-a-big-numeric-field-from-IQ-to-sas/m-p/802731#M316047 <P>Hi experts,</P><P>&nbsp;</P><P>I have a table in sybase IQ with a numeric field like this&nbsp;</P><PRE><SPAN>74882512059898578830423 <BR /></SPAN></PRE><P>&nbsp;<SPAN>it´s a numeric(23,0), but when i read this number in a sas query, shows me a diferent number&nbsp;</SPAN></P><PRE><SPAN>74882512059898582269952 and also like this 7.48825120598986E+22</SPAN></PRE><P><SPAN>&nbsp;is there a way to obtain the original number that i have in sybase IQ ??, i have tried to convert to text, but i obtain the same.</SPAN></P> Fri, 18 Mar 2022 04:19:20 GMT https://communities.sas.com/t5/SAS-Programming/reading-a-big-numeric-field-from-IQ-to-sas/m-p/802731#M316047 Jose7 2022-03-18T04:19:20Z https://communities.sas.com/t5/SAS-Programming/reading-a-big-numeric-field-from-IQ-to-sas/m-p/802732#M316048 <P>What arithmetic are you doing with a number with that many digits?</P> <P>&nbsp;</P> <P>You should show exactly how you connected to Sybase to retrieve that data. Someone with experience connecting to that database may have a suggestion but it may be converting to character in the database before reading into SAS.</P> Fri, 18 Mar 2022 04:39:13 GMT https://communities.sas.com/t5/SAS-Programming/reading-a-big-numeric-field-from-IQ-to-sas/m-p/802732#M316048 ballardw 2022-03-18T04:39:13Z