proc import for xlsx in on demand for academics

vicdicenzo — Sun, 25 Jul 2021 21:22:48 GMT

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!

Re: proc import for xlsx in on demand for academics

Kurt_Bremser — Mon, 26 Jul 2021 05:28:15 GMT

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).

topic proc import for xlsx in on demand for academics in New SAS User

proc import for xlsx in on demand for academics

Re: proc import for xlsx in on demand for academics