Date:         Thu, 22 Jul 2004 05:51:08 -0700
Reply-To:     Stig Eide <stigeide@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stig Eide <stigeide@YAHOO.COM>
Organization: http://groups.google.com
Subject:      Re: how to read data from the excel files?
Content-Type: text/plain; charset=ISO-8859-1

Hi!
You need the product SAS/Access PC file Format.
When/if you have this, you can use this code:
PROC IMPORT OUT= WORK.e
            DATAFILE= "D:\e.xls"
            DBMS=EXCEL2000 REPLACE;
     RANGE="Sheet1$";
     GETNAMES=YES;
RUN;
Range can also be an Excel Range.
Instead of Range statement you can use SHEET=.
Hope this helps,
Stig Eide
Norway

"tm" <s030716@sparc20c.sta.cuhk.edu.hk> wrote in message news:<cdnb50$2es4$1@justice.itsc.cuhk.edu.hk>...
> Hi Hi,
>      i have an excel file which consists of 6 sheets ( sheet1 to sheet6),
> where each sheet stores the same structure of data. What is the procedure of
> reading the data from the excel sheet by sheet?
> In fact, i have over 100 excel files ( that means 600 worksheets of data). I
> would know the procedure of reading the data from an excel sheet by sheet
> automatically.
>
> Thanks a lot.