Thanks for your quick reply! I agree that I would be having this problem with a character ID but for now I just have to live with it. I'll start a new (and more accurate) thread about the issue if it doesn't resolve soon otherwise. ... View more

Hi all! I'm having exactly the same problem as @HULK in the original post. I have a table in Oracle database with ID variable having some 16-digit-values . Reading them to SAS server works fine and all the values are displayed correctly on SAS server but if I write them to Oracle (or Excel) again, 16. digit converts to 0. I'm confused why this is happening since both environments "understand" the original & correct values. I have a workaround but I'm still wondering if there's something one could do to prevent this error. ... View more