SAS EG 8.2 error on PROC IMPORT

RyanJB — Wed, 19 Aug 2020 13:17:13 GMT

Running a very simple PROC IMPORT (Excel) that works fine on EG 7.1 but fails on EG 8.2. The error report doesn't mean much to me. See below for the relevant part of the log and the IMPORT statement.

proc import datafile = "X:\data\online_only.xlsx" dbms = excel out = dat_raw replace;
 /* log info below */
36         %LET _CLIENTTASKLABEL=;
37         %LET _CLIENTPROCESSFLOWNAME=;
38         %LET _CLIENTPROJECTPATH=;
39         %LET _CLIENTPROJECTPATHHOST=;
40         %LET _CLIENTPROJECTNAME=;
41         %LET _SASPROGRAMFILE=;
42         %LET _SASPROGRAMFILEHOST=;
43         
44         ;*';*";*/;quit;

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed.  See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):

Can anyone help me understand what is causing this error?

The only other lines above this are setting a library name (which is done successfully) and some global options (also successfully, though the only relevant part for this project is validvarname).

options pageno = 1 yearcutoff = 1950 number spool validvarname = v7; 
goptions device = png;

Re: SAS EG 8.2 error on PROC IMPORT

Kurt_Bremser — Wed, 19 Aug 2020 13:56:55 GMT

Are you sure that you connect to the same workspace server definition? Compare your connection profiles and the server you use for code execution.

Alternatively, use dbms=xlsx for a test.

Re: SAS EG 8.2 error on PROC IMPORT

RyanJB — Wed, 19 Aug 2020 14:09:18 GMT

dbms = xlsx fixed it (I thought I had already done that, but clearly did not!)

Thank you!

topic SAS EG 8.2 error on PROC IMPORT in SAS Enterprise Guide

SAS EG 8.2 error on PROC IMPORT

Re: SAS EG 8.2 error on PROC IMPORT

Re: SAS EG 8.2 error on PROC IMPORT