The original requester wrote me, off-line, indicating that they did not have sas/access to pc.

Thus, on to two of the other alternatives, namely xml or dde.

A search of the archives should bring up numerous examples of using dde.

A paper on xml can be found at: http://support.sas.com/rnd/papers/sugi29/ExcelXML.pdf

Art ------- On Thu, 5 Apr 2007 15:31:53 -0400, Sas Biology <sasbio@GMAIL.COM> wrote:

>Hi, > >I was trying to read data into sas from excel. I am working on unix and >the release of SAS is 8.02. > >Here is my code > >proc import datafile="aaa.xls" out=bbb DBMS=EXCEL97 replace ; > SHEET="'ccc'"; > GETNAMES=YES; >run ; > >The log file displayed > >ERROR: DBMS type EXCEL97 not valid for import. >NOTE: The SAS System stopped processing this step because of errors. > >The excel version I use is excel 2003 . While this didn't work I also >tried by saving the excel file as a 'Microsoft Excel 97 - Excel >2003&5.0/95 workbook.xls' type file, but this didn't work either. > >Can anyone help me out? > >thanks