Curt,

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.,: http://www.listserv.uga.edu/cgi-bin/wa?A2=ind0804b&L=sas-l&D=1&O=A&P=79470 or, if you want that in short form,: http://xrl.us/bjzfy

HTH, Art -------- On Wed, 30 Apr 2008 10:22:26 -0700, Seeliger.Curt@EPAMAIL.EPA.GOV wrote:

>Folks, > >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, >cur > >-- >Curt Seeliger >Computer Science Corporation - Contractor to ORD >Data Ranger >seeliger.curt@epa.gov >541/754-4638