Importing issue

[mv44]

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.

[Jagadishkatam]

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;

[Tom]

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.