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
![sas.PNG sas.PNG](https://communities.sas.com/t5/image/serverpage/image-id/35887iE0C60F5FE1B61D3E/image-size/large?v=v2&px=999)
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.