When I run it with EXCEL it gives me this error. It worked with EXCEL before but gave me error for yesterday and today. (Yesterday, window was update automatically)
28 proc import datafile = "K:\Variant Taskforce\Variant Codes\Variant Types and Snomed_V20220126.xlsx"
29 out = work.Variants
30 dbms= EXCEL replace;
31 RANGE = "Most Recent$";
32 GETNAMES=YES;
33 MIXED=YES;
34 SCANTEXT=YES;
35 USEDATE=YES;
36 SCANTIME=YES;
37 run;
1 The SAS System 09:05 Tuesday, February 22, 2022
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):
real time 1.73 seconds
cpu time 0.04 seconds
38
39 %LET _CLIENTTASKLABEL=;
40 %LET _CLIENTPROCESSFLOWNAME=;
41 %LET _CLIENTPROJECTPATH=;
42 %LET _CLIENTPROJECTPATHHOST=;
43 %LET _CLIENTPROJECTNAME=;
44 %LET _SASPROGRAMFILE=;
45 %LET _SASPROGRAMFILEHOST=;
46
47 ;*';*";*/;quit;run;
2 The SAS System 08:48 Tuesday, February 22, 2022
48 ODS _ALL_ CLOSE;
49
50
51 QUIT; RUN;
52
... View more