From: demin on
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