topic Re: PROC IMPORT xlsx file problem in SAS Programming

PROC IMPORT xlsx file problem

Avi02 — Thu, 14 May 2020 15:30:04 GMT

Hi:

I am trying to import a XLSX file and convert to a SAS dataset, but for some reason I get the below message in SAS Log which is very vague with no ERROR codes shown:

SAS Code:

proc import datafile='../view/abc.xlsx'

dbms=xlsx replace

out=work.abc;

getnames=yes;

run;

SAS log message:

"No worksheets in the .XLSX file.

Requested input file is invalid.

ERROR: Import unsuccessful. See SAS Log for Details"

SAS Software 9.4 (TS1M5) being run on Linux 3.10.0-957.21.3.el7.x86_64 (LIN X64) platform.

Am I missing something here? Anyways to resolve this?

Thank you,

Avi.

Re: PROC IMPORT xlsx file problem

ChrisNZ — Fri, 15 May 2020 00:37:52 GMT

>No worksheets in the .XLSX file.

How many sheets in your file? Did you try the sheet= statement?

Re: PROC IMPORT xlsx file problem

Avi02 — Fri, 15 May 2020 01:46:01 GMT

Just one sheet and yes, tried with the SHEET option as well with the same ERROR message.

Re: PROC IMPORT xlsx file problem

ChrisNZ — Fri, 15 May 2020 02:48:15 GMT

SAS does not see that sheet. It probably has some special attributes, though I am unsure what these might be. Try creating a new sheet with the same contents. Not that Excel provides no metadata, so reading an Excel file yields unpredictable results in terms of variable type or length.