The error "ERROR: File MYLIB7X.'Sheet1$'.DATA does not exist" occurs in SAS/ACCESS® Interface to PC Files


When using a DATA step and LIBNAME reference to enter a Microsoft Excel file into a SAS data set, the data is not found. As a result, the following message occurs:

ERROR: File MYLIB7X.'Sheet1$'.DATA does not exist.

Adding LIST output after the FILENAME and LIBRARY definitions shows that the physical file name changes incorrectly during the library assignment. Here is an example:

The Physical Filename is "c:\users...\myfile.xlsx"

Testing found that choosing a file name label that did not contain exactly eight characters caused the physical file name definition to be incorrectly changed in the library assignment. Since the file name no longer refers to the correct input file, there is no data to be loaded.

When changing to a file name reference name that contains eight characters, the correct input file path is retained, and the data loads successfully.

The Physical Filename from the first image changed to "c:\users...\myfile2.xlsx"