Import XLSX using excel engine

[Ronein]

Hello

I have XLSX file and I want to import it using excel engine.

When I go to start and paste the path  \\path\zaad_batuah.xLSX  then I can see the XLSX file (So this path is correct).

However I get an error that the file doesn't exist

Is there anything wrong with my code?

libname RRR clear;
libname RRR XLSX   "\\path\LoansInfo.xLSX"; 
data    LoansInfo;
set RRR.LoansInfo;
run;

[Oligolas]

Hi, two things:

1.The excel file you are trying to import needs to be closed or in a share mode.

2.The dataset you are using in the set statement 'RRR.LoansInfo' has to be a sheet in your excel file.

I.e.: If LoansInfo isn't a sheet name in your excel file it won't work.

[andreas_lds]

3. just because you can see the file from your computer, does not necessarily mean, that the sas-session sees it, too.