topic Re: Importing issue in SAS Programming

Importing issue

mv44 — Sat, 15 Jul 2017 05:33:45 GMT

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.

Re: Importing issue

Jagadishkatam — Sat, 15 Jul 2017 06:22:42 GMT

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;

Re: Importing issue

Tom — Sat, 15 Jul 2017 16:21:32 GMT

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.