If the cell value in the Microsoft Excel file is 0.00626, Microsoft Excel displays 0.0063 as the value (due to the custom column format).

For example, execute the following IMPORT procedure code:

proc import out= TEST_info_prod
     datafile="&path\test.xlsx"
     dbms=xlsx replace;
     getnames=YES;
run;

After executing the PROC IMPORT code, the following occurs:

• In SAS 9.3M2, a value of 0,00626 occurs. The BEST format is applied automatically by SAS.
• In SAS 9.4M3, a value of 0,0063 occurs. The COMMA15.4 format is applied automatically by SAS.

Workaround

To circumvent this issue, change the custom format to the General format in the Microsoft Excel file.

Note that you can change the column type by using a DATA step after importing the data, but you will not be able to change the precision back to the longer precision. However, you can change the precision to a shorter precision.