Hello! I'm having trouble importing an external file in excel format to SAS DI Studio. Inside SAS, I'm creating an external file > User input... We don't have direct access to files in SAS. In the metadata section I put the following code: PROC IMPORT OUT=WORK.file; DATAFILE="/mydata/Sample Data.xlsx" DBMS=xls REPLACE; SHEET="Sheet1$"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; The file is created, but it does not load any data and with the File Reader transformation and I get the following error: ERROR: FILE = OR TABLE= IS REQUIERED AND MUST BE SPECIFIED Excel only has one sheet with different types of data. I don't know if I have to define the SAS code in the external file differently, but I have defined the columns well or you can't load external files in excel format this way. Could someone tell me a possible solution, please? Thank you very much.
... View more