topic Re: DBMS TYPE XLSX not valid for import in SAS Studio

DBMS TYPE XLSX not valid for import

Aiman — Mon, 04 May 2020 09:14:09 GMT

Hi, I tried to import and read my xlsx data to sas studio, im running into this error "XLSX not valid for import" and "FILE.WORK.IMPORT.DATA doest not exist", this is the code that I run , it is from sas snippet library.

/* Generated Code (IMPORT) */
/* Source File: raw input data.xlsx */
/* Source Path: /Users/maiman.khalid/My Folder/raw input data.xlsx */
/* Code generated on: May 4, 2020, 4:05:09 PM */

proc sql;
%if %sysfunc(exist(WORK.IMPORT)) %then %do;
    drop table WORK.IMPORT;
%end;
%if %sysfunc(exist(WORK.IMPORT,VIEW)) %then %do;
    drop view WORK.IMPORT;
%end;
quit;



FILENAME REFFILE FILESRVC FOLDERPATH='/Users/maiman.khalid/My Folder'  FILENAME='raw input data.xlsx';

PROC IMPORT DATAFILE=REFFILE
	DBMS=XLSX
	OUT=WORK.IMPORT;
	GETNAMES=YES;
RUN;

PROC CONTENTS DATA=WORK.IMPORT; RUN;

proc print data=work.import(obs=3);
run;

Re: DBMS TYPE XLSX not valid for import

andreas_lds — Mon, 04 May 2020 10:44:54 GMT

Please post the full log as text.

Re: DBMS TYPE XLSX not valid for import

AhmedAl_Attar — Mon, 04 May 2020 11:50:42 GMT

Try using the xlsx libname engine instead

/* because Excel field names often have spaces */
options validvarname=any;
 
libname xl XLSX "/folders/myfolders/raw input data.xlsx";   *<--- Change the path;
 
/* discover member (DATA) names */
proc datasets lib=xl; quit;

/* read in one of the tables */
data work.import;
  set xl.<Sheet Name>;  *<--- Change the SHEET Name;
run;
libname xl CLEAR;

Hope this helps,

Ahmed