I recently encountered a weird SAS problem. My base SAS crashes on the 3rd excel file after imports two excel files using the EXCEL engine. This happens when I use libname statement EXCEL engine to read excel files or when I use proc import dbms=excel to import excel files. Again, using the EXCEL engine, I could successfully read or import up to two excel files, but SAS crashes on the 3rd excel file to be imported. If I switch to XLSX engine, there is no issue. Can anyone help me to resolve the issue with EXCEL engine? My SAS version: SAS 9.4 TS Level 1M5 X64_10PRO platform Operating System information: Windows 10 The analytical products: SAS/STAT 14.3 SAS/ETS 13.1 SAS/IML 14.3 Here is the code that cause the problem when I try to read the EXCEL files: LIBNAME Source excel "File_Name.xlsx" MIXED= YES DBMAX_TEXT= 32767 HEADER= NO; PROC SQL; CREATE TABLE Output_Dataset AS SELECT F1 AS COL1 LABEL= "Page" format=$32., INPUT(F2, 8.) AS COL2 LABEL= "Mark1", INPUT(F3, 8.) AS COL3 LABEL= "Mark2", INPUT(F4, 8.) AS COL4 LABEL= "Mark3", INPUT(F5, 8.) AS COL5 LABEL= "Mark4" FROM Source."Sheet_Name$"n (firstobs = 6 obs = 6) ; QUIT; LIBNAME Source CLEAR; PROC IMPORT datafile="File_Name.xlsx" OUT=Output_Dataset DBMS=EXCEL REPLACE ; RANGE="Sheet_Name$"; GETNAMES=YES; MIXED=YES; RUN;
... View more