Date:         Thu, 10 Nov 2005 02:47:32 -0800
Reply-To:     Peter <crawfordsoftware@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter <crawfordsoftware@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Reading Excel files
Comments: To: sas-l@uga.edu
In-Reply-To:  <22F95BC7C879D211AB120008C7A43B8008B979AD@usuwphmsx01.usuwd.astrazeneca.net>
Content-Type: text/plain; charset="iso-8859-1"

If your sheets conform.....
sas9.....
sas/access to pc file formats.......
excel library engine ......
treats all sheets and names ranges potentially as datasets.
Try something like:
libname wbook excel 'yourpath\yourWorkBook.xls' ;
proc contents data= wbook._all_; run;

you'll probably need to refer to individual sheets with "name
constant"n style like:
  proc contents data=wbook."sheet1$"n ; run;

In sas913 online doc, there is a relevant section at
http://support.sas.com/onlinedoc/913/getDoc/en/acpcref.hlp/a001250848.htm
titled: How to Access XLS Files from SAS

Might be easier in Enterprise Guide...