DATA Step, Macro, Functions and more

ERROR: DBMS type EXCEL not valid for import.

Reply
Occasional Contributor
Posts: 6

ERROR: DBMS type EXCEL not valid for import.

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;

 

 

Super Contributor
Posts: 490

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

Check this 

How to Import an Excel File to SAS University Edition

 

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

Super User
Posts: 17,868

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 609 views
  • 0 likes
  • 3 in conversation