just odbc into the workbook and you will see all tables in the
libname. a proc datasets will give you all tables name. simply loop
through them with macro.
On Wed, Apr 30, 2008 at 1:22 PM, <Seeliger.Curt@epamail.epa.gov> wrote:
> How does one list worksheet names in an Excel file so that PROC IMPORT can
> import them by name?
> I'd like to read several arbitrarily named worksheets into SAS, but I'm
> currently confounded by the need to name those sheets directly. Is there
> a way to cycle through N sheets without explicitly naming them?
> Thanks for your pointers,
> Curt Seeliger
> Computer Science Corporation - Contractor to ORD
> Data Ranger
ChoicePoint Precision Marketing
Email : firstname.lastname@example.org
Blog : statcompute.spaces.live.com