Date: Tue, 25 Feb 2003 13:47:09 -0500
Reply-To: Daixin <dx35y@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Daixin <dx35y@YAHOO.COM>
Subject: Error & Fatal message when using DDE
I'm using FILENAME DDE to read an excel worksheet into SAS. The code is
rather basic, but I got error & fatal (as if error is not enough) messages.
Below are what the log says.
filename readata dde 'Excel|z:\carcr\[prostate.xls]CA!a6:k45' ;
data prostate ;
infile readata ;
input race $ interval $ n d w p cp p_star cp_star r cr ;
run ;
NOTE: The infile READATA is:
DDE Session,
SESSION=Excel|z:\carcr\[prostate.xls]CA!a6:k45,RECFM=V,LRECL=256
ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step
program. Aborted during the EXECUTION phase.
I'm using SAS 8e on Windows NT. What might be the problem?
Thanks!
|