topic Import XLSX using excel engine in SAS Programming

Import XLSX using excel engine

Ronein — Mon, 13 Jan 2020 09:30:48 GMT

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 — Mon, 13 Jan 2020 10:31:49 GMT

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 — Mon, 13 Jan 2020 11:28:56 GMT

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