Can't import Excel file into SAS 9.4

[mayoralc]

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.

[Reeza]

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.

---

[mayoralc]

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

[Reeza]

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

---

[mayoralc]

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?