topic Re: Import Excel files in SAS DI Studio in New SAS User

Import Excel files in SAS DI Studio

Pat_5 — Thu, 06 Feb 2020 15:07:25 GMT

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.

Re: Import Excel files in SAS DI Studio

LinusH — Thu, 06 Feb 2020 15:15:49 GMT

You mean User Written external file, right?

What do you mean you don't have direct access to files?

Is your PROC IMPORT working outside DI Studio?

Re: Import Excel files in SAS DI Studio

Pat_5 — Thu, 06 Feb 2020 15:24:38 GMT

Yes, I mean User Written an external file

I don't have direct access to the folder where the files are uploaded. I don't know if that's a problem.

How can I compare that my PROC IMPORT works outside SAS DI?

Re: Import Excel files in SAS DI Studio

LinusH — Thu, 06 Feb 2020 15:37:02 GMT

Try the code in Enterprise Guide, SAS Studio or even in the DI Studio code editor.

Once working there, try to implement in the metadata.