proc import for xlsx in on demand for academics

[vicdicenzo]

I am trying to import an xlsx file using on demand for academics.  I have cretaed a folder and uploaded the data. I have created a library and copied that as a path but I get an error message that the file does not exist.

OPTIONS LS=100 PS=100 NOCENTER NODATE NONUMBER;

libname NCSTB "/home/xxxxxxxx0/2020/NCSTB";

/** Import an XLSX file. **/

PROC IMPORT DATAFILE= "/home/xxxxxxxx0/2020/NCSTB/STB TL FREQ Data.XLSX"
OUT=WORK.ALL
DBMS=XLSX
REPLACE;
RUN;

This seems different from SAS UE but I don't know how to fix.  Thanks!

[Kurt_Bremser · Accepted solution]

Make sure that the spelling of the filename is absolutely correct, in particular regarding upper/lowercase.

Excel stores with a lowercase extension (xlsx, not XLSX).