As soon as you move data through SAS, you are subject to its limits, which means a maximum precision of 15 decimal digits because of the 8 byte real format that SAS uses for numbers.
I suggest you find a way to transfer the data more directly. Unload to a text file with proper formatting, and load from that, without using SAS.
As soon as you move data through SAS, you are subject to its limits, which means a maximum precision of 15 decimal digits because of the 8 byte real format that SAS uses for numbers.
I suggest you find a way to transfer the data more directly. Unload to a text file with proper formatting, and load from that, without using SAS.
Just guessing, but since sas numbers have at max 15 significant digits, some information is lost during transfer.
See http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#numvar.htm for details about how numbers are stored.
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.