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.
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.
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
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
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?
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.