reading a big numeric field from IQ to sas

[Jose7]

Hi experts,

I have a table in sybase IQ with a numeric field like this 

74882512059898578830423 

 it´s a numeric(23,0), but when i read this number in a sas query, shows me a diferent number 

74882512059898582269952 and also like this 7.48825120598986E+22

 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.

[ballardw · Accepted solution]

What arithmetic are you doing with a number with that many digits?

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.