topic ERROR: DBMS type EXCEL not valid for import. in SAS Programming

ERROR: DBMS type EXCEL not valid for import.

sss2 — Thu, 04 Feb 2016 15:00:28 GMT

I am working on SAS studio and trying to import excel file.Apart from excel, I have also tried to convert the file to csv and xml format, but none of them worked.

Everytime I try to import the file, the error occurs.

proc import out = sales
Datafile = "C:\SASUniversityEdition\myfolders\Sales.xml"
DBMS = xml replace;
run;

Re: ERROR: DBMS type EXCEL not valid for import.

mohamed_zaki — Thu, 04 Feb 2016 15:11:28 GMT

Check this

How to Import an Excel File to SAS University Edition

Follow the steps mentioned and if you still having problems post again.

Re: ERROR: DBMS type EXCEL not valid for import.

Reeza — Thu, 04 Feb 2016 15:37:18 GMT

You say Excel but your file reference appears to be XML.

Is it an Excel file or an XML. The process for importing the two are different.