Hello! I'm having difficulties importing an xlsx file... In addition to the Import Wizard (which gives "ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement.), I've tried also the following: ---> LIBNAME data 'C:\Users\User\Documents\VacCov\VacCovData.xlsx'; ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement ---> LIBNAME data PCFILES PATH='C:\Users\User\Documents\VacCov\VacCovData.xlsx'; seems to import all tabs, but when I try to open one it says it doesn't exist or cannot be displayed ---> PROC IMPORT DATAFILE="C:\Users\User\Documents\VacCov\VacCovData.xlsx" DBMS=EXCELCS OUT=WORK.FFF REPLACE; SHEET='data'; RUN; ERROR: Unable to transcode data to/from UCS-2 encoding. ERROR: Import unsuccessful. See SAS Log for details. To solve the errors in the first 2 attempts, I installed the SAS PC Files Server following an older thread on the board, but that didn't really help. (During the deployment, SAS Private Java Runtime Environment (64-bit) failed to install and Install Post Processing was completed with errors... not sure that has something to do with it.) Any help is much appreciated!
... View more