I have an Excel file with a table containing several columns of numeric values. I imported this file into a SAS project using the Data Import Wizard, and all columns appear correctly. However, in the last column, exactly two numbers are missing and are replaced with 0.

Here’s what I have tested so far:

Not a formatting or length issue – All numbers in the table have the same format. Some numbers have more digits and are imported correctly. Linking issue? – If I copy and paste the problematic numbers as values (instead of keeping them as linked values), they are correctly imported into SAS. This suggests that the issue is related to the linking of values. However, all numbers in the table reference the same source, yet only two of them fail to import correctly.

Why does this happen? How can I ensure that all linked values are imported properly into SAS?

Any insights would be appreciated!