data a;
   a=1.123456789;
 run;

proc export data=a 
            dbms=xlsx 
            outfile='c:\sastest\mydigits.xlsx' replace;
     sheet='fred';
run;

Workarounds

To resolve the problem, do one of the following:

• Use DBMS=EXCELCS or DBMS=EXCEL, depending on which operating system and version of Microsoft Office are installed.
  • Use DBMS=EXCEL if you are using SAS and Excel on Windows and the bits match. That is, 32-bit SAS and 32-bit Office, or 64-bit SAS and 64-bit Office.
  • Use DBMS=EXCELCS if the bit architecture of SAS and Windows do not match or if you are not running on a Windows platform.
• Or install SAS^® 9.4. The number of digits has been expanded to 15 in SAS 9.4.

Operating System and Release Information