Hi @Reeza@ChrisHemedinger@LinusH
These are the error messages I received running on different options. Is there any other solution to the 64-bit/32-bit compatibility?
%let Path_i1="\\awnjpsas02\Corporate-Asia\Production\SG\inputs\sasinputs.xlsx";
proc import datafile=&Path_i1 out=lob dbms=excel replace; sheet="lob";
ERROR: Failed to connect to the Server: .
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
%let Path_i1="\\awnjpsas02\Corporate-Asia\Production\SG\inputs\sasinputs.xlsx";
proc import datafile=&Path_i1 out=lob dbms=excelcs replace; sheet="lob";
ERROR: Failed to connect to the Server: .
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
%let Path_i1="\\awnjpsas02\Corporate-Asia\Production\SG\inputs\sasinputs.xlsx";
proc import datafile=&Path_i1 out=lob dbms=pcfiles replace; sheet="lob";
ERROR: DBMS type PCFILES not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
proc import out=lob datafile="\\awnjpsas02\Corporate-Asia\Production\SG\inputs\sasinputs.xlsx" dbms=excel replace; sheet='lob';
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
... View more