topic Re: Can't import Excel file into SAS 9.4 in Microsoft Integration with SAS

Can't import Excel file into SAS 9.4

mayoralc — Mon, 09 Jul 2018 14:50:45 GMT

Hi all, thank you for you help. I cannot import excel files into SAS 9.4.

The error is the following:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

Re: Can't import Excel file into SAS 9.4

Reeza — Mon, 09 Jul 2018 15:00:36 GMT

Do you have the required license?

You would need SAS Access to PCFILES.

You can check what's licensed with:

proc setinit;run;

And what's installed with:

proc product_status;run;

@mayoralc wrote:

Hi all, thank you for you help. I cannot import excel files into SAS 9.4.

The error is the following:

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

Re: Can't import Excel file into SAS 9.4

mayoralc — Mon, 09 Jul 2018 15:05:47 GMT

Hi, thank you for your answer, I have checked it out, I have access interface to DB2 and access to pc files according to the log

Re: Can't import Excel file into SAS 9.4

Reeza — Mon, 09 Jul 2018 15:16:32 GMT

Then post the full code and log that's generating the errors.

@mayoralc wrote:

Hi, thank you for your answer, I have checked it out, I have access interface to DB2 and access to pc files according to the log

Re: Can't import Excel file into SAS 9.4

mayoralc — Mon, 09 Jul 2018 15:49:43 GMT

I have made it using:

libname in xlsx 'C:\xxx.xlsx';
proc copy inlib=in outlib=work; run;

But still it is messy since it import all sheets. How can I get my wizard back to select what sheets I want to import into which libs?