Hello everyone-
I'm facing much the same problem as the OP - I need to import the data from a single tab from multiple Excel 2007 files. Our upgrade of 9.2 to phase 2 to read 2007 is in the works.
I have done multiple file reads from .csv files into one dataset, but we have had problems with corrections not getting done through both source files, thus the switch to direct read.
I found a macro that will read multiple sheets out of multiple Excel files, and I could take out the multiple tab section for my case.
http://www2.sas.com/proceedings/sugi31/034-31.pdf
I will be reading only the tab 'finals' from Excel (*.xlsx) files from a specific directory, and the Excel files will not have consistent naming.
Does anyone have a simpler way to do this?
Thanks for your help!
Wendy
LIBNAME GETIT EXCEL "test.xlsx" MIXED=NO SCAN_TIMETYPE=ANY ;
DATA NEW ;
SET GETIT.'FINALS$'n ;
RUN ;
LIBNAME GETIT CLEAR ; RUN ;