I wouldn't bother with using PROC IMPORT if you can get the LIBNAME engine to work. 21 character member name shouldn't be a problem since SAS names can be up to 32 characters long, unless you have option VALIDVARNAME=V6 set. You might have made other changes to the file when you opened it to change the sheetname.
... View more