topic Unable to import xlsx file using PROC IMPORT. in SAS Programming

Unable to import xlsx file using PROC IMPORT.

441418 — Fri, 31 Mar 2023 16:24:07 GMT

Unable to import xlsx file using PROC IMPORT. I tried to use DBMS = xlsx on SAS 9.4 M7.

Re: Unable to import xlsx file using PROC IMPORT.

Tom — Fri, 31 Mar 2023 16:20:30 GMT

Don't attach files. If you want to share text click on the Insert Code icon and paste the text into the pop-up window. It you want to attach an image you can paste it into the normal editor box. Or click on the Insert Photos icon and either drag it there or browse to the file and select it.

Re: Unable to import xlsx file using PROC IMPORT.

CodeName — Fri, 31 Mar 2023 16:24:58 GMT

Use SAS/ACCESS Interface to OLEDB
In SAS/ACCESS interface to OLEDB, you can submit the following code to create or read an .xlsx file with Microsoft office 2007 OLEDB

libname LibTest oledb init_string="Provider=Microsoft.ACE.OLEDB.12.0;
data source='C:\Excelfiles\Air.xlsx';
extended Properties=Excel 12.0";

data Test;
set LibTest.'Air3'n;
run;

Re: Unable to import xlsx file using PROC IMPORT.

Kurt_Bremser — Fri, 31 Mar 2023 16:26:11 GMT

@441418 wrote:

Unable to import xlsx file using PROC IMPORT. I tried to use DBMS = xlsx on SAS 9.4 M7.

Open the file in question with Excel or other office software to see if it is valid.