From: Ed on
Try converting the xlsx file to a csv or txt file using the SW that
originally created the file. May have to change the GUESSROWS to bring
in the data in the correct format.

demin wrote:
>
> Use the regular import, only import 255 columns.
>
> proc import datafile="C:\temp\aaa.xlsx"
> out=test
> replace;
> sheet='Final Data';
> getnames=yes;
> run;
>
> thanks