Dear all,

         the version of SAS  i used is v8 and i want to import the data from
the excel files.  Here are the commands i used in v8 version:

PROC IMPORT OUT= WORK.one
            DATAFILE= "C:\Documents and Settings\Desktop\Book1.xls"
            DBMS=EXCEL     REPLACE;
     GETNAMES=YES;
     DATAROW=2;
RUN;


However, it was warned that the DBMS=EXCEL was in improper use.  What is the
problem ?

Also, how can the spreadsheets within the same excel file be read into the
SAS automatically?

Thanks a lot!!!

Regards,
TM

You need to be more specific in the version of DBMS=

Valid values are: Excel97 or EXCEL2000

tm wrote:

>Dear all,
>
>         the version of SAS  i used is v8 and i want to import the data from
>the excel files.  Here are the commands i used in v8 version:
>
>PROC IMPORT OUT= WORK.one
>            DATAFILE= "C:\Documents and Settings\Desktop\Book1.xls"
>            DBMS=EXCEL     REPLACE;
>     GETNAMES=YES;
>     DATAROW=2;
>RUN;
>
>
>However, it was warned that the DBMS=EXCEL was in improper use.  What is the
>problem ?
>
>Also, how can the spreadsheets within the same excel file be read into the
>SAS automatically?
>
>Thanks a lot!!!
>
>Regards,
>TM
>
>
>

--
============================================================
Robin & Charmaine Templer
Wellington, New Zealand

Email: robin.templer@xtra.co.nZ
FAX  : 64-4-476-4299
Phone: 64-4-476-4299