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?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!