topic Re: ERROR: Import unsuccessful. See SAS Log for details. in SAS Programming

ERROR: Import unsuccessful. See SAS Log for details.

nemezies — Tue, 23 Feb 2021 05:38:16 GMT

Hi, I'm new to this. Please help me.

I'm trying to proc import like this:

proc import datafile='/folders/myfolders/desksas.xls' dbms=xls
out=work replace;
sheet='desksas';
getnames=yes;
run;

but when I run it, the log result I got is like this:

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         proc import datafile='/folders/myfolders/desksas.xls' dbms=xls
 74         out=work replace;
 75         sheet='desksas';
 76         getnames=yes;
 77         run;
 
 Spreadsheet isn't from Excel V5 or later.  Please open it in Excel and Save as V5 or later
 Requested Input File Is Invalid
 ERROR: Import unsuccessful.  See SAS Log for details.
 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: PROCEDURE IMPORT used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds
       
 78         
 79         
 80         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 92

Can somebody help me with this?

Re: ERROR: Import unsuccessful. See SAS Log for details.

qoit — Tue, 23 Feb 2021 06:26:47 GMT

It looks like that SAS is telling you "Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later". If excel doesn't work, can you save as a CSV and try the IMPORT procedure with DBMS = CSV?

Re: ERROR: Import unsuccessful. See SAS Log for details.

Kurt_Bremser — Tue, 23 Feb 2021 07:02:59 GMT

Open the workbook file in Excel and save it to CSV (so you can read it with a data step) or at least XLSX, so you can read it with the more modern and platform-independent XLSX engine.

Re: ERROR: Import unsuccessful. See SAS Log for details.

Amir — Tue, 23 Feb 2021 08:32:29 GMT

Hi @nemezies,

Are you having the same problem as found in the below post, where it looks like the file name extension had been changed?

https://communities.sas.com/t5/SAS-Programming/Error-of-Excel-not-v5-when-using-PROC-IMPORT/td-p/498055

Kind regards,

Amir.

Re: ERROR: Import unsuccessful. See SAS Log for details.

Kurt_Bremser — Tue, 23 Feb 2021 10:37:25 GMT

On second thought, I also consider it likely that it is a file saved with the wrong extension.