Since you're talking about using proc import, I'll assume that you have
SAS/ACCESS for PC Files.
If so, I think the easiest method is to identify the spreadsheet in a
libname and then run a proc sql to get the names. See, e.g.,:
or, if you want that in short form,: http://xrl.us/bjzfy
On Wed, 30 Apr 2008 10:22:26 -0700, 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,
>Computer Science Corporation - Contractor to ORD