|Date: ||Sat, 7 Apr 2007 09:33:17 -0400|
|Reply-To: ||Arthur Tabachneck <art297@NETSCAPE.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Arthur Tabachneck <art297@NETSCAPE.NET>|
|Subject: ||Re: Excel to sas|
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:
On Thu, 5 Apr 2007 15:31:53 -0400, Sas Biology <sasbio@GMAIL.COM> wrote:
>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 ;
>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?