BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
vonda12
Fluorite | Level 6

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

There was more or less exactly the same question earlier today:

https://communities.sas.com/t5/Base-SAS-Programming/ERROR-when-using-SAS-Enterprise-Guide-64bit-9-04...

 

You just need to use dbms=xlsx.  Note in my answer there you need to change to:

libname tmp xlsx 'C:\workspace\test.xlsx';

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

There was more or less exactly the same question earlier today:

https://communities.sas.com/t5/Base-SAS-Programming/ERROR-when-using-SAS-Enterprise-Guide-64bit-9-04...

 

You just need to use dbms=xlsx.  Note in my answer there you need to change to:

libname tmp xlsx 'C:\workspace\test.xlsx';
vonda12
Fluorite | Level 6

Thank you!

 

The LIBNAME statement still doesn't work for me, but PROC IMPORT is OK.

 

(In my original post I forgot to mention that I did try DBMS=xlsx as it was suggested somewhere else and it didn't work then, but somehow now it does :))

 

Thanks again for the help!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 1175 views
  • 0 likes
  • 2 in conversation