Hi, I'm trying to import xlsx file into SAS 9.4 M7 (32-bit) without success. This is my SAS code: /* Import data */ PROC IMPORT OUT=WORK.RFI_CONTACT DATAFILE="Y:\Biostat\RFI\RFI_draft_20220126.xlsx" DBMS=XLSX REPLACE; RANGE="CONTACT DETAILS"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; run; and this is the error: ERROR: DBMS type XSLX not valid for import. I think that the problem is because my Office environment could be 64-bit but I don't know how to solve the problem. I don't want to use the wizard. Can you help me? I have downloaded SAS 32-bit version because it was suggested by the system during the installation process. Many thanks!
... View more