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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.