It seems proc import can retrieve data from Excel if the data is in a sheet by itself using the "sheet=" statement, known range i.e., "A1:C10", or named range using the "range=" statement. What I don't see is an easy way to import the data if it is an Excel Table. Something like a "table=" statement in the code below to accomplish this would be extremely helpful. I apologize if this already exists, I couldn't find anything. Thanks in advance for your attention to this matter.
proc import out= WANT
datafile= "C:\ExcelFile.xlsm"
dbms= EXCEL replace;
TABLE= "TBL";
run;