02-04-2016 10:00 AM
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;
02-04-2016 10:11 AM
Follow the steps mentioned and if you still having problems post again.
02-04-2016 10:37 AM
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.