Error: File X.Sheet.DATA does not exist

jerrylshen — Mon, 15 Jul 2019 20:33:34 GMT

I've done a Google search of this error and it seems none of the results were applicable.

Both the Excel file and the SAS code programs are in the same folder.

The multisheet-Excel file has a sheet named "Dictionary"

LIBNAME XLSLIB xlsx "K:\Folder1\Folder2\FileName.xlsx";

data dict;
set XLSLIB.Dictionary;
/*ERROR: File XLSLIB.Dictionary.DATA does not exist.*/ ...
run;

I've also tried this, but it also has the same error:

data XLSLIB.Dictionary;
    set XLSLIB.Dictionary;

https://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

It should just read and not overwrite anything.

Thanks

Re: Error: File X.Sheet.DATA does not exist

ChrisNZ — Thu, 18 Jul 2019 02:05:27 GMT

What tables do you see when you open the XLSLIB library?

topic Re: Error: File X.Sheet.DATA does not exist in SAS Programming

Error: File X.Sheet.DATA does not exist

Re: Error: File X.Sheet.DATA does not exist