Is it possible to import an Excel Table into SAS using Proc Import? In Excel, the table has a name, in this case it's "TBL", and appears in the Name Manager. However, the range associated with "TBL" does not contain the header row which contains the variable names. I've tried using "range=" since this works with named ranges but it does not appear to work with tables. The table is in a sheet with other data, pivot tables, graphs, etc. so "sheet=" will not work. Any insight is appreciated. Thanks in advance.
proc import out= WANT
datafile= "C:\ExcelFile.xlsm"
dbms= EXCEL replace;
range= "TBL";
run;
... View more