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>
Subject: Re: how to read data from the excel files?
Content-Type: text/plain; charset=ISO-8859-1
You need the product SAS/Access PC file Format.
When/if you have this, you can use this code:
PROC IMPORT OUT= WORK.e
Range can also be an Excel Range.
Instead of Range statement you can use SHEET=.
Hope this helps,
"tm" <firstname.lastname@example.org> wrote in message news:<email@example.com>...
> 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
> Thanks a lot.