Date:         Thu, 18 Nov 2004 18:33:56 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: How to import an excel file with several sheets to SAS
Comments: To: "Amy L. Sheng" <lhsheng_1@YAHOO.COM>

If you are on SAS 9, use proc import's sheet= option.  For example,

PROC IMPORT OUT= WORK.ONE
            DATAFILE= "C:\Book2.xls"
            DBMS=EXCEL REPLACE;
     SHEET="Sheet1$";
     GETNAMES=YES;
     MIXED=YES;
     SCANTEXT=YES;
     USEDATE=NO;
     SCANTIME=NO;
RUN;

Art
----
On Thu, 18 Nov 2004 11:12:12 -0500, L. Sheng <lhsheng_1@YAHOO.COM> wrote:

>I want to import the 4 sheets in one excel file to SAS. How can I do it
>to create 4 sas data sets corresponding to each sheet in that excel file?
>
>Thank you.