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

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