DATA Step, Macro, Functions and more

Importing issue

Reply
New Contributor
Posts: 2

Importing issue

Hi,

 

I'm getting Error while importing xlsx file.

 

Error:- Data Set "_XLSXIMP._firstsheet_" not found

 

code: proc import datafile='location\car_retail_price.xslx' out= car dbms= xlsx replace;

run;

 

please help.

Trusted Advisor
Posts: 1,137

Re: Importing issue

could you please check the path of the xlsx file.
and please also check if you have the license to access the PC files. If you do not have the access to access/PC files then you cannot convert the excel file into dataset.

to check the access to pc files use

proc setinit;
run;
Thanks,
Jag
Super User
Super User
Posts: 7,074

Re: Importing issue

Make sure the file really is an XLSX file. Perhaps someone just renamed an XLS file or even an HTML file to fool Windows into using Excel to open the file.

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