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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: